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


Please Help Members By Posting Answers For Below Questions

What is the use of profile paramater ztta/roll_area?

684


What is the role of “ application server” ?

643


list some common errors faced with jspm while updating java stcks.and solutions.

2203


How do you kill a job in SAP?

680


What is the database backup strategy in your company?

1741






What is difference between oracle 9i and oracle 10g?

1330


Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance

2123


What is luw (logical unit of work)?

635


How to see when were the optimizer stats last time run?

672


Mention what is the purpose of table usr02?

656


How you connect ECC to EP?

1602


What is oracle Architecture?

1686


Explain checkpoint?

575


What is password policy?

786


What are the regular activities u do in solution manager and how

1620