What does mean by SWAP? Where should we monitor this? what
is the threshold value for swaps/day? If it is more what
will u do?
Answer Posted / srikanth
the accessed data will sit in the buffer. If someone is
trying to acces the same data, that will be rtrieved fastly
from the buffer. If the buffer is full and some one is
retrieving the data which is not there in the buffer then
that data will be placed in the buffer and the oldest data
in the buffer will be swapped for this. More number of
swaps means more DB hits. If there are more Swaps we can
increase the buffer size
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is the use of profile paramater ztta/roll_area?
What is the role of “ application server” ?
list some common errors faced with jspm while updating java stcks.and solutions.
How do you kill a job in SAP?
What is the database backup strategy in your company?
What is difference between oracle 9i and oracle 10g?
Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance
What is luw (logical unit of work)?
How to see when were the optimizer stats last time run?
Mention what is the purpose of table usr02?
How you connect ECC to EP?
What is oracle Architecture?
Explain checkpoint?
What is password policy?
What are the regular activities u do in solution manager and how