SMU

Hello List,

I have two questions about SMU. Any suggestion is appreciated.

1) who used undo segments by how much? I am not asking who IS USING here, w=
hich is easy to know by querying v$tranaction, v$process, and etc.
2) when will the undo segment space be released? The parameter undo_retenti=
on does not tell unless I know who used how much undo at what time?

Thanks,

Michael=20


**********************************************************************
This e-mail contains privileged attorney-client communications and/or confi=
dential information, and is only for the use by the intended recipient. Rec=
eipt by an unintended recipient does not constitute a waiver of any applica=
ble privilege.

Reading, disclosure, discussion, dissemination, distribution or copying of =
this information by anyone other than the intended recipient or his or her =
employees or agents is strictly prohibited.  If you have received this comm=
unication in error, please immediately notify us and delete the original ma=
terial from your computer.

Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or SoCal=
Gas, the utilities owned by SET's parent company.  SET is not regulated by =
the California Public Utilities Commission and you do not have to buy SET's=
 products and services to continue to receive quality regulated service fro=
m the utilities.
**********************************************************************

--
http://www.freelists.org/webpage/oracle-l

Other related posts: