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. ********************************************************************** -- //www.freelists.org/webpage/oracle-l