Re: temporary space issue

From: ddf <oratune_at_msn.com>
Date: Wed, 9 Feb 2011 09:54:09 -0800 (PST)
Message-ID: <57ac20fe-1d13-4765-9a94-d5c871bc69cb_at_a8g2000pri.googlegroups.com>

On Feb 9, 10:41 am, Mladen Gogala <n..._at_email.here.invalid> wrote:
> 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

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 Fitzjarrell Received on Wed Feb 09 2011 - 11:54:09 CST