I am querying following sql statement as an OPS$USER.
SELECT DISTINCT id from SCOTT.USER_ID;
60Rows returned in 9Seconds.
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??????