Thursday 30 October 2014

How to get maximum cursors in oracle?

Hi,  I am going to restart my blogging, Now I am telling about Maximum cursor count in our  oracle db settings. Here is the query to pick up that buddy [:) kidding actually I mean that property]..


SELECT NAME,
       value
FROM   v$parameter
WHERE  NAME = 'open_cursors'; 




 here   v$parameter  : A view have all parameter settings
           NAME        : Parameter Name ['open_cursors']
           value       : Value set to the parameter


Note : Default cursor count is 600 in oracle.


Thank you... :)