Re: temporary space issue

From: Mladen Gogala <no_at_email.here.invalid>
Date: Wed, 9 Feb 2011 18:49:40 +0000 (UTC)
Message-ID: <pan.2011.02.09.18.49.39_at_email.here.invalid>

On Wed, 09 Feb 2011 09:54:09 -0800, ddf wrote:

> And V$SORT_USAGE is not the same definition given to V_$SORT_USAGE;
> describe both views (as I did) and you will see differences.

David, V$SORT_USAGE and V_$SORT_USAGE are synonyms.

QL> select table_owner,table_name from dba_synonyms   2 where synonym_name='V$SORT_USAGE';

TABLE_OWNER TABLE_NAME

------------------------------ ------------------------------
SYS			       V_$SORT_USAGE

Elapsed: 00:00:00.16
SQL> select * from v$version;

BANNER

---

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production NLSRTL Version 10.2.0.5.0 - Production

Elapsed: 00:00:00.09
SQL> connect system_at_vmso
Enter password:

---

Connected.
SQL> select table_owner,table_name from dba_synonyms   2 where synonym_name='V$SORT_USAGE';

TABLE_OWNER TABLE_NAME

------------------------------ ------------------------------
SYS			       V_$SORT_USAGE

Elapsed: 00:00:00.13
SQL> select * from v$version;

BANNER

---

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production

Elapsed: 00:00:00.09

SQL> 
SQL> 
SQL> desc v$tempseg_usage
 Name					   Null?    Type
 ----------------------------------------- -------- 
----------------------------
 USERNAME					    VARCHAR2(30)
 USER						    VARCHAR2(30)
 SESSION_ADDR					    RAW(4)
 SESSION_NUM					    NUMBER
 SQLADDR					    RAW(4)
 SQLHASH					    NUMBER
 SQL_ID 					    VARCHAR2(13)
 TABLESPACE					    VARCHAR2(31)
 CONTENTS					    VARCHAR2(9)
 SEGTYPE					    VARCHAR2(9)
 SEGFILE#					    NUMBER
 SEGBLK#					    NUMBER
 EXTENTS					    NUMBER
 BLOCKS 					    NUMBER
 SEGRFNO#					    NUMBER

SQL> desc v$sort_usage
 Name					   Null?    Type
 ----------------------------------------- -------- 
----------------------------
 USERNAME					    VARCHAR2(30)
 USER						    VARCHAR2(30)
 SESSION_ADDR					    RAW(4)
 SESSION_NUM					    NUMBER
 SQLADDR					    RAW(4)
 SQLHASH					    NUMBER
 SQL_ID 					    VARCHAR2(13)
 TABLESPACE					    VARCHAR2(31)
 CONTENTS					    VARCHAR2(9)
 SEGTYPE					    VARCHAR2(9)
 SEGFILE#					    NUMBER
 SEGBLK#					    NUMBER
 EXTENTS					    NUMBER
 BLOCKS 					    NUMBER
 SEGRFNO#					    NUMBER

SQL>

-- 
http://mgogala.byethost5.com

Received on Wed Feb 09 2011 - 12:49:40 CST