List five most important parameter in 9i affecting performance?
No Answer is Posted For this Question
Be the First to Post Answer
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
Do you need a commit after ddl statements?
What is different type of rman backup?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
What is the difference between truncate and delete? How would a full table scan behave after?
What happens if the constraint name is left out of a constraint clause?
What is the meaning of database backup?
Explain procedure to change characterset of a database.
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 can you determine the space left in a file system?
What is the easiest method to create a file on unix?
How to drop an oracle database?