Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL query to determine the users of undo tablespace
On Apr 5, 9:04 am, "yaru22" <yar..._at_gmail.com> wrote:
> How do I determine which users are using undo tablespace in an Oracle
> 9.2 database?
>
> Thanks.
See metalink Note: 1039126.6 for one way. Google around, I'm sure there are others.
(Mladen, you seem to have missed a line or two in your script)
jg
-- @home.com is bogus. http://www.signonsandiego.com/uniontrib/20070405/news_1b5google.htmlReceived on Thu Apr 05 2007 - 16:15:11 CDT