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
- 5445 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
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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is replication? : sql server DBA
What purpose does the model database server? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is the difference between clustered and non-clustered index? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Explain materialized views and how they are used.
How can you control the amount of free space in your index pages? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what is the role of dip user in our database?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can you schedule a job in database?
