We have some very large tables in our database like around 100 million rows, and sometimes we'll have an analyst do a select * from [TH] and it will just bring back that first set in the sql window..which is not all the rows..just like 15-20 or so, but anyway our Grid Control in oracle monitors this and shows it as a very large 'other' wait state..so when we cancel that..or select from another smaller table, that wait state goes away. Has anybody seen anything like this before?
Huge Wait state in Oracle Grid Control
- Thread starter LDub
- Start date
The cursor for that query remains open until you issue a new query (or close the SQL Window). There is no real "wait state" though, and you should find the same behavior with other query tools.
Similar threads
- Discussion