Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL query to determine the users of undo tablespace

Re: SQL query to determine the users of undo tablespace

From: joel garry <joel-garry_at_home.com>
Date: 5 Apr 2007 14:15:11 -0700
Message-ID: <1175807711.258586.255490@n59g2000hsh.googlegroups.com>


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.html
Received on Thu Apr 05 2007 - 16:15:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US