Strobe report shows that CLOSE CURSOR statement shows poor performance. What could cause this statement performance hit? Thanks.

  • Interview Candidate
  • 1
  • 2039

Showing Answers 1 - 1 of 1 Answers

santosh Panigrahi

  • Jul 12th, 2009
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions