How can you tell if a tablespace has excessive fragmentation?
No Answer is Posted For this Question
Be the First to Post Answer
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?
What are some indications that you need to increase the shared_pool_size parameter?
Does dba need to know programming?
What skills does a dba need?
What are the different responsibilities of a dba?
What parameters control copy latches?
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?
You see a wait on lms process in statspack, what does that mean?
How many control files should you have? Where should they be located?
Discuss row chaining, how does it happen? How can you reduce it?
What is da in database?
How do you use automatic pga memory management with oracle 9i and above?