how can you generate profile of pl/sql applications to identify performance bottlenecks?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  


hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  


If we issue alter database begin backup. What happens to database?

2 Answers  






How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  


what do you understand by fine-grained auditing?

0 Answers   Oracle,


How would you go about increasing the buffer cache hit ratio?

2 Answers  


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,


Explain the use of table functions.

1 Answers  


what is logical system in sap basis

0 Answers  


Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  


Categories