Describe how you would monitor and control database
physical file size and growth?

Answer Posted / alok

connect as dba to the database and fire the query
show db_parameter_file; on oracle database (I am not sure
on query, u can search for a similar query)

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are “business rules” in ab initio business rules environment (bre)?

1411


What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

624


What is a cursor? Within a cursor, how would you update fields on the row just fetched?

647


Pdl with an example?

645


Explain about ab initio’s dependency analysis?

633






Why might you create a stored procedure with the with recompile option?

640


Mention what are the different types of parallelism used in abinitio?

574


Explain what is sandbox?

623


Explain what does dependency analysis mean in abinitio?

558


What is a deadlock and how it occurs?

661


What do you understand by overflow errors?

618


How many components in your most complicated graph?

716


What are the primary keys and foreign keys?

542


Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

847


How can you import XML repositories exported from different tools like ODI

3038