What is tkprof and how is it used?

612

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1195

What are the beneficial tools for administering the database?

543

What is explain plan and how is it used?

612

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

564

I am getting error "no communication channel" after changing the domain name? What is the solution?

602

You see a wait on lms process in statspack, what does that mean?

574

What does the no logging option do? Why would we be careful of using it?

603

When should you increase copy latches? What parameters control copy latches?

572

What skills do you need to be an administrator?

570

Why are recursive relationships bad? How do you resolve them?

595

Explain the wait events in statspack report 'enqueue'?

583

What is a production dba?

611

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?

693

What is the difference between internal & external schema?

763