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
- 5566 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
Explain materialized views and how they are used.
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
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?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Query processing is slow(eg select query)how will u solve that
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is replication? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What the different topologies in which replication can be configured? : sql server DBA
what functionality does oracle provide to secure sensitive information?
What are the different types of indexes available in sql server? : sql server DBA
internal architecture
