List five most important parameter in 9i affecting performance?
No Answer is Posted For this Question
Be the First to Post Answer
How can you tell if an index on particular table is used or not used in 9i?
Which rman command is used to create an exact replica of a database innew host?
What is different type of rman backup?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
What is the difference between a database and instance?
What are the various ingredients of sga?
When using oracle export/import what character set concerns might come up? How do you handle them?
You see multiple extents in the temporary tablespace. Is this a problem?
What are some indications that you need to increase the shared_pool_size parameter?
What is explain plan and how is it used?
How can you determine if an oracle instance is up from the operating system level?