v$sort_usage
- From: "Tracy Rahmlow" <tracy.rahmlow@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 13 Jul 2006 10:05:13 -0500
Oracle 10.1.0.5 on AIX 5.2 -
I have a user with a default temp tablespace of temp1, but when they execute
some sql I have noticed that the tablespace
reported in the tablespace column of v$sort_usage is temp (note different
name). The user is referencing objects that it is not the owner of. Any
ideas?
__________________________________________________
Tracy Rahmlow | Lead Database Analyst
Information Systems
Ameriprise Auto & Home Insurance
AMEX Assurance Company
IDS Property Casualty Insurance Company
3500 Packerland Drive | De Pere, WI 54115-9070
Office: 920.330.5164 | Fax: 920.330.5350
tracy.rahmlow@xxxxxxxx
ameriprise.com/autohome
Ameriprise made the following
annotations on 07/13/06, 08:09:58
------------------------------------------------------------------------------
******************************************************************************
"This message and any attachments are solely for the intended recipient and may
contain confidential or privileged information. If you are not the intended
recipient, any disclosure, copying, use, or distribution of the information
included in this message and any attachments is prohibited. If you have
received this communication in error, please notify us by reply e-mail and
immediately and permanently delete this message and any attachments. Thank you."
******************************************************************************
==============================================================================
Other related posts:
