Re: ??? Negative V$ROLLSTAT.XACTS

I had an ORA-600 yesterday, and then I had SMON go wild cleaning up temp segments (as it appears it was doing), and not so long after this one rollback segment started showing -1 active transactions.

The segment cannot be offlined nor dropped.

I think I'll just leave it alone until the next restart of the db. Something must have gone wrong within Oracle after ora-600. I have a TAR open for this error.

Thanks

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Joel Garry" <joel-garry_at_home.com> a écrit dans le message de
news:1107470818.622622.268740_at_o13g2000cwo.googlegroups.com...


> Has the segment been used?

>

> jg

> --

> @home.com is bogus.

> "If you use Java exclusively throughout your application, you should

> expect to encounter performance or functionality limitations during its

> production usage" - Kevin Loney

>