How does one coalesce free space?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between truncate and delete? Why is one faster?
What are some indications that you need to increase the shared_pool_size parameter?
You see multiple fragments in the system tablespace, what should you check first?
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?
What is the difference between a database and instance? What is the relation between them?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
How many types of database software are there?
What kinds of responsibilities does a dba have in a database environment?
What are dba privileges?
Which dba certification is best?
What are the various ingredients of sga?
How do you generate file output from sql?