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 is is a data flow graph?

677


What is the difference between look-up file and look-up, with a relevant example?

702


What is the use of the co> operating system in ab initio?

617


How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

470


What happens when we provide null key to sort, merge and pbks in Abinitio ?

836






What are the co> operating system’s assorted library of integrated components?

654


How co>operating system integrates with legacy codes?

617


What a local lookup is?

605


Explain the methods to improve performance of a graph?

674


How to create repository in abinitio for stand alone system(local nt)?

723


How do you improve the performance of a graph?

675


What do you understand by local lookup?

653


What kind of layouts does abinitio support?

631


How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

3899


What is publickey and private key?what is the use of this two keys?

2346