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']
Note : Default cursor count is 600 in oracle.
Thank you... :)
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... :)