Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Unanswered: strage recursion

    Hi all

    I am trying to understand from where V$SESSION_WAIT_CLASS takes its data:
    sql> select * from dba_synonyms where synonym_name = upper('v$session_wait_class')
    OWNER SYNONYM_NAME
    ------------------------------ ------------------------------
    TABLE_OWNER TABLE_NAME
    ------------------------------ ------------------------------
    DB_LINK
    ----------------------------------------------------------------------

    PUBLIC V$SESSION_WAIT_CLASS
    SYS V_$SESSION_WAIT_CLASS

    sql> select text from dba_views where view_name = 'V_$SESSION_WAIT_CLASS' and owner = 'SYS';
    TEXT
    --------------------------------------------------------------------------------

    select "SID","SERIAL#","WAIT_CLASS_ID","WAIT_CLASS#","WAI T_CLASS","TOTAL_WAITS", "TIME_WAITED" from v$session_wait_class

    it seems like v$session_wait_class is a public synonym for SYS.V_$SESSION_WAIT_CLASS which is a view selecting from v$session_wait_class again.
    I don't understand how it can be, any do ?

    Thanks,
    Avishai

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
      1  select owner, object_name, object_type from dba_objects
      2* where object_name like '%WAIT_CLASS%'
    SQL> /
    
    OWNER                          OBJECT_NAME                      OBJECT_TYPE
    ------------------------------ -------------------------------- -------------------
    SYS                            V_$SESSION_WAIT_CLASS            VIEW
    PUBLIC                         V$SESSION_WAIT_CLASS             SYNONYM
    SYS                            V_$SYSTEM_WAIT_CLASS             VIEW
    PUBLIC                         V$SYSTEM_WAIT_CLASS              SYNONYM
    SYS                            V_$SERVICE_WAIT_CLASS            VIEW
    PUBLIC                         V$SERVICE_WAIT_CLASS             SYNONYM
    SYS                            GV_$SESSION_WAIT_CLASS           VIEW
    PUBLIC                         GV$SESSION_WAIT_CLASS            SYNONYM
    SYS                            GV_$SYSTEM_WAIT_CLASS            VIEW
    PUBLIC                         GV$SYSTEM_WAIT_CLASS             SYNONYM
    SYS                            GV_$SERVICE_WAIT_CLASS           VIEW
    PUBLIC                         GV$SERVICE_WAIT_CLASS            SYNONYM
    SYS                            WRH$_SERVICE_WAIT_CLASS          TABLE PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS          TABLE
    SYS                            WRH$_SERVICE_WAIT_CLASS_PK       INDEX
    SYS                            WRH$_SERVICE_WAIT_CLASS_BL       TABLE
    SYS                            WRH$_SERVICE_WAIT_CLASS_BL_PK    INDEX
    SYS                            DBA_HIST_SERVICE_WAIT_CLASS      VIEW
    PUBLIC                         DBA_HIST_SERVICE_WAIT_CLASS      SYNONYM
    SYS                            WRH$_SERVICE_WAIT_CLASS_PK       INDEX PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS          TABLE PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS_PK       INDEX PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS          TABLE PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS_PK       INDEX PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS          TABLE PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS_PK       INDEX PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS          TABLE PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS          TABLE PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS_PK       INDEX PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS_PK       INDEX PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS          TABLE PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS_PK       INDEX PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS          TABLE PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS_PK       INDEX PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS          TABLE PARTITION
    SYS                            WRH$_SERVICE_WAIT_CLASS_PK       INDEX PARTITION
    
    36 rows selected.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •