Cursor statistics request

2001-05-03 Thread Mohan, Ross
Hey DBAs for big databases, Would you mind running this simple query? I am building a case that we have an extremely unheathly application, and would like to (a) do a reality check, and (b) anonymously cite evidence from other sites. col name format a35 col min format 999 col max format

Re: Cursor statistics request

2001-05-03 Thread Mohammad Rafiq
Under Oracle Financials: NAME minavgvar max --- -- -- opened cursors cumulative 0201 3222968 opened cursors current 0 31 6 335 Order entry

RE: Cursor statistics request

2001-05-03 Thread Hand, Michael T
Ross, Around 500 users, uptime 26days; OLTP system NAME minavgvar max --- -- -- opened cursors cumulative 0 10611282 1107346 opened cursors current 0161