Re: strange select issue

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Sun, 21 Sep 2003 09:12:39 GMT
Message-ID: <bYdbb.852$xn7.8467520@news-text.cableinet.net>

> Based on p1 of your enqueue event, you're waiting on SS lock. In this
> case, your tablespace is ts# 2. p3=1 simply means this is a local
> enqueue. If your ts# 2 is TEMP, why does the session request for this
> lock? Is TEMP really temporary? What does select * from v$sort_usage
> give? What other wait events show up in v$session_wait at the moment
> (excluding those with word "message")? Anything special in alert.log?
> You may also search on Metalink regarding sort segment for 8.1.5.

thanks - today i also noticed this....

kccrsz: denied expansion of controlfile section 9 by 1337 record(s) the number of records is already at maximum value (65535) krcpwnc: following controlfile record written over: RECID #500246 Recno 43823 Record timestamp

being repeated lots in the alert log - has anyone seen this before and know how to fix it? i have seen the error on gogle but i can't seem to find the solution.

thanks

Tom Received on Sun Sep 21 2003 - 04:12:39 CDT