Re: temporary space issue

From: Mladen Gogala <no_at_email.here.invalid>
Date: Wed, 9 Feb 2011 16:41:19 +0000 (UTC)
Message-ID: <pan.2011.02.09.16.41.19_at_email.here.invalid>

On Wed, 09 Feb 2011 05:28:40 -0800, ddf wrote:

>> David, V$TEMPSEG_USAGE is a synonym for V$SORT_USAGE
>>
>> --http://mgogala.byethost5.com- Hide quoted text -
>>
>> - Show quoted text -

>
> No,; it isn't:

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

TABLE_OWNER TABLE_NAME

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

Elapsed: 00:00:00.14
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.14
SQL> connect system_at_vmso
Enter password:

---

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

TABLE_OWNER TABLE_NAME

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

Elapsed: 00:00:00.22
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.14

-- 
http://mgogala.byethost5.com

Received on Wed Feb 09 2011 - 10:41:19 CST