What is tkprof and how is it used?
No Answer is Posted For this Question
Be the First to Post Answer
How do you install statspack?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
As an oracle dba what are the entire unix file you should be familiar with?
How many control files should you have? Where should they be located?
What parameters control copy latches?
Explain force logging feature in 9i.
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
What are the goals of dba?
What do you understand by the term 'system change number (scn)'?
What is the difference between a database and instance? What is the relation between them?
Discuss row chaining, how does it happen? How do you correct it?
When using oracle export/import what character set concerns might come up? How do you handle them?