| Problem in v$sort_usage [message #58835] |
Fri, 03 October 2003 05:27  |
dasdeba
Messages: 1
Registered: October 2003
|
Junior Member |
|
|
hi,
I am using Oracle 9i rel 2 (32 bit) on Solaris 9 (64 bit). We are also using Weblogic server where taste table name is dual. It means that for testing connection , it uses "select coun(*) from dual" statement at 5 minutes interval.
1) I want to find out the sqls which have been performed through disk sorts.Can anybody tell me how to find out these sqls ?
2) Actually there are few rows in the v$sort_usage which have segtype as lob_data. But there are no lob fields against those tables. Even sometimes "select count(*) from dual" statement is also coming into v$sort_usage where segtype is lob_data. There are some sqls which are accessing single table but that does not have any lob field and these sqls are also coming into v$sort_usage where segtype is lob_data . Now why segtype is lob_data ?
Deba
|
|
|
|
| Re: Problem in v$sort_usage [message #58840 is a reply to message #58835] |
Fri, 03 October 2003 07:36  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
It looks like you are using temporary_lobs in your database. These get stored in your temp tablespace and hence show up in your v$sort_usage as LOB_DATA.
Join v$sort_usage to v$sqlarea to get the sqltext that uses sorts.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
