maximun open cursor exceeded
Dear all,
I the an error on my application server page "maximun open cursor exceeded". at that time, users were not able to login on my application. the only thing i did was to increase the cursor on my database. This is true also that we had an increased number of users accessing the application.
Now i have to report to management that why i have increased the cursor parameter. Hence, what i want to know how can i monitor my cursor usage. how we can determine the cursor parameter? i have change the cursor parameter from 1000 to 5000. what is the impact of increasing the cursor parameter?
I the an error on my application server page "maximun open cursor exceeded". at that time, users were not able to login on my application. the only thing i did was to increase the cursor on my database. This is true also that we had an increased number of users accessing the application.
Now i have to report to management that why i have increased the cursor parameter. Hence, what i want to know how can i monitor my cursor usage. how we can determine the cursor parameter? i have change the cursor parameter from 1000 to 5000. what is the impact of increasing the cursor parameter?
0