| |
GeekInterview.com > Tech FAQs > Oracle > Database Administration
| Print | |
Question: Strobe report shows that CLOSE CURSOR statement shows poor performance. What could cause this statement performance hit? Thanks.
|
| July 07, 2009 13:46:41 |
#1 |
| santosh Panigrahi |
Member Since: July 2009 Total Comments: 6 |
RE: Strobe report shows that CLOSE CURSOR statement shows poor performance. What could cause this statement performance hit? Thanks.
|
Increate the size of database buffer cache.
Or
Set parameter
pre_page_sge=true
The main adventage is, all pages are touth to physical memory.
The main disadvantages is, it create more active pages & more time to make connect. |
| |
Back To Question | |
