like "buffer gets * blocksize=buffer cache usage" makes sense

Hi Guys,


from buffer gets of sql can find amount of buffer cache used by query

(like "buffer gets * blocksize=buffer cache usage" makes sense)


or any query to find buffer cache used by particular sqlid


Thanks

yes it will be helpful for getting pointers

simple question:
query to find buffer cache used by particular sqlid

Thanks

ok,

actually if can find buffer cache used by particular sqlid,then i can plan and avoid running not so important at peak load time
which significantly use buffer cache ,as currently db showing high cpu,io

yes true but if not required query fetching large amount of rows could occupy buffer cache till completion of execution impacting others like wait,or disk reads due to non availability of buffer cache /blocks

Thanks

ok,

actually if can find buffer cache used by particular sqlid,then i can plan and avoid running not so important at peak load time
which significantly use buffer cache ,as currently db showing high cpu,io

lets say qry1 run every 1 hr is important to run,qry2 run sometimes and not so important but fetch large data,due to qry2 execution and using buffer cache will qry1 be impacted,if so i can plan to run qry2 different non peak time

is there way to block cadot,i just click ignore his messages not sure he is blocked from all of my post,he is frustated person