1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / ram prakash soni

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

Post New Answer

More DB Administration Interview Questions

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,




Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

What happens on checkpoint? : sql server DBA

0 Answers  

how can you process messages in order asynchronously?

0 Answers   Oracle,

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

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

2 Answers  

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories