컴퓨터활용/오라클

v$session

멜번초이 2003. 10. 12. 00:17
SQL>select * from v$session;  


SQL> desc v$session;  
이름                                      널?      유형  
----------------------------------------- -------- ----------------  
SADDR                                           RAW(8)  
SID                                                NUMBER  
SERIAL#                                         NUMBER  
AUDSID                                          NUMBER  
PADDR                                           RAW(8)  
USER#                                           NUMBER  
USERNAME                                    VARCHAR2(30)  
COMMAND                                     NUMBER  
OWNERID                                       NUMBER  
TADDR                                           VARCHAR2(16)  
LOCKWAIT                                      VARCHAR2(16)  
STATUS                                         VARCHAR2(8)  
SERVER                                         VARCHAR2(9)  
SCHEMA#                                       NUMBER  
SCHEMANAME                               VARCHAR2(30)  
OSUSER                                         VARCHAR2(30)  
PROCESS                                       VARCHAR2(9)  
MACHINE                                        VARCHAR2(64)  
TERMINAL                                       VARCHAR2(10)  
PROGRAM                                       VARCHAR2(48)  
TYPE                                               VARCHAR2(10)  
SQL_ADDRESS                                  RAW(8)  
SQL_HASH_VALUE                             NUMBER  
PREV_SQL_ADDR                               RAW(8)  
PREV_HASH_VALUE                           NUMBER  
MODULE                                           VARCHAR2(48)  
MODULE_HASH                                  NUMBER  
ACTION                                             VARCHAR2(32)  
ACTION_HASH                                    NUMBER  
CLIENT_INFO                                     VARCHAR2(64)  
FIXED_TABLE_SEQUENCE                   NUMBER  
ROW_WAIT_OBJ#                                 NUMBER  
ROW_WAIT_FILE#                                 NUMBER  
ROW_WAIT_BLOCK#                             NUMBER  
ROW_WAIT_ROW#                                 NUMBER  
LOGON_TIME                                       DATE  
LAST_CALL_ET                                    NUMBER  
PDML_ENABLED                                  VARCHAR2(3)  
FAILOVER_TYPE                                  VARCHAR2(13)  
FAILOVER_METHOD                             VARCHAR2(10)  
FAILED_OVER                                      VARCHAR2(3)  
RESOURCE_CONSUMER_GROUP           VARCHAR2(32)  
PDML_STATUS                                     VARCHAR2(8)  
PDDL_STATUS                                      VARCHAR2(8)  
PQ_STATUS                                          VARCHAR2(8)  

'컴퓨터활용 > 오라클' 카테고리의 다른 글

oracle 테이블스페이스 생성  (0) 2005.10.12
clob 컬럼 데이타 조회하기  (0) 2005.10.12
oracle user  (0) 2003.10.12
오라클 유저 생성  (0) 2003.10.12
oracle listener status check  (0) 2003.10.12