Interested to Buy Any Domain ? << Click Here >> for more details...
You're getting high "busy buffer waits" - how can you find
what's causing it?
- 1 Answers
- 5381 Views
- I also Faced
- E-Mail Answers
Answer Posted / braj123
1.By using statspack report find buffer busy wait events.
2.>select * from V$system_event where event like '%wait%';
3.>select * from v$waitstat;
Solutions:
* Identify and eliminate hot blocks from the application
via changing the PCTFREE and PCTUSED values to reduce the
number of rows per data block.
* Each instance has its own freelist groups.
* Increase the number of rollback segments.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
how to restore files with rman?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What are the steps you will take to improve performance of a poor performing query?
what are the performance views in an oracle rac environment?
what is a crs resource?
Why does Oracle not permit the use of PCTUSED with indexes?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the commands you'd issue to show the explain plan for "select * from dual"?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What are the recovery models for a database? : sql server DBA
how can you enable flashback feature?
how can you schedule a job in database?
