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: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 5 Apr 2007 19:02:52 +0200
Message-ID: <46152bbc$0$15516$426a74cc@news.free.fr> 






"yaru22" <yaru22_at_gmail.com> a écrit dans le message de news: 1175789083.986357.255780_at_d57g2000hsg.googlegroups.com...


| How do I determine which users are using undo tablespace in an Oracle

| 9.2 database?

|

| Thanks.

|




Join dba_segments (or dba_rollback_segs), v$rollstat, v$rollname, v$session and v$transaction.



Regards


Michel
Received on Thu Apr 05 2007 - 12:02:52 CDT












Original text of this message













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