Home » RDBMS Server » Performance Tuning » some questions on tuning.
some questions on tuning. [message #65880] Thu, 20 January 2005 10:15
Naveen
Messages: 75
Registered: June 2001
Member
I need answers to few or all of the questions below ASAP, can anyone help me ...

1. How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2. What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

3. You're getting high "busy buffer waits" - how can you find what's causing it?

4.Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

5.What would you use to improve performance on an insert statement that places millions of rows into that table?
Previous Topic: improving performace of oracle 9i application server release 1.0
Next Topic: 9i . suddenly started running slow
Goto Forum:
  


Current Time: Thu Mar 28 13:20:35 CDT 2024