-
I am querying following sql statement as an OPS$USER.
SELECT DISTINCT id from SCOTT.USER_ID;
60Rows returned in 9Seconds.
But....
I queried same sql statement as an user SYS, it takes only .10 second to return.
This is on Sun Solaris 8 and Oracle 8.1.7.
SORT_AREA_SIZE = 960KB and this table has index.
Any idea why it takes much longer to get results if I run as an OPS$USER??????
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|