설치된 오라클 제품 확인 admin
2011.10.26 13:58 Edit
접속되어 있는 오라클 서버의 기본 정보..
활성화 되어
SQL> select NAME, VERSION, DETECTED_USAGES, CURRENTLY_USED, FIRST_USAGE_DATE, LAST_USAGE_DATE from DBA_FEATURE_USAGE_STATISTICS where CURRENTLY_USED = 'TRUE' order by 1,2;
NAME VERSION DETECTED_USAGES CURRE FIRST_USA LAST_USAG
---------------------------------------------------------------- ----------------- --------------- ----- --------- ---------
Audit Options 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Automatic Maintenance - Optimizer Statistics Gathering 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Automatic Maintenance - SQL Tuning Advisor 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Automatic Maintenance - Space Advisor 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Automatic SGA Tuning 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Automatic SQL Execution Memory 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Automatic SQL Tuning Advisor 11.2.0.1.0 1 TRUE 26-OCT-11 26-OCT-11
Automatic Segment Space Management (system) 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Automatic Storage Management 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Automatic Undo Management 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Character Set 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
LOB 11.2.0.1.0 1 TRUE 26-OCT-11 26-OCT-11
Locally Managed Tablespaces (system) 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Locally Managed Tablespaces (user) 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Logfile Multiplexing 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Oracle Java Virtual Machine (system) 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Partitioning (system) 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
RMAN - Disk Backup 11.2.0.1.0 2 TRUE 14-OCT-11 26-OCT-11
Recovery Area 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Recovery Manager (RMAN) 11.2.0.1.0 2 TRUE 14-OCT-11 26-OCT-11
SecureFiles (system) 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
Segment Advisor 11.2.0.1.0 2 TRUE 14-OCT-11 26-OCT-11
Server Parameter File 11.2.0.1.0 3 TRUE 27-JUN-11 26-OCT-11
23 rows selected.
Oracle Edition 확인
col product for a40
col version for a20
col status for a20
OS 정보 확인
수고하세요~
SQL> select * from product_component_version;
PRODUCT VERSION STATUS
---------------------------------------- -------------------- --------------------
NLSRTL 11.2.0.1.0 Production
Oracle Database 11g Enterprise Edition 11.2.0.1.0 Production
PL/SQL 11.2.0.1.0 Production
TNS for Linux: 11.2.0.1.0 Production
OS 정보 확인
select PLATFORM_NAME from v$database;
PLATFORM_NAME
-----------------------------------------------------------------------------------------------------
Linux IA (32-bit)
SQL> select * from v$osstat;
STAT_NAME VALUE OSSTAT_ID COMMENTS CUM
------------------------------ ---------- ---------- ---------------------------------------------------------------- ---
NUM_CPUS 1 0 Number of active CPUs NO
IDLE_TIME 647375 1 Time (centi-secs) that CPUs have been in the idle state YES
BUSY_TIME 161972 2 Time (centi-secs) that CPUs have been in the busy state YES
USER_TIME 21787 3 Time (centi-secs) spent in user code YES
SYS_TIME 113590 4 Time (centi-secs) spent in the kernel YES
IOWAIT_TIME 4159 5 Time (centi-secs) spent waiting for IO YES
NICE_TIME 450 6 Time (centi-secs) spend in low-priority user code YES
RSRC_MGR_CPU_WAIT_TIME 0 14 Time (centi-secs) processes spent in the runnable state waiting YES
LOAD 1.02929688 15 Number of processes running or waiting on the run queue NO
PHYSICAL_MEMORY_BYTES 2125312000 1008 Physical memory size in bytes NO
TCP_SEND_SIZE_MIN 4096 2000 TCP Send Buffer Min Size NO
TCP_SEND_SIZE_DEFAULT 16384 2001 TCP Send Buffer Default Size NO
TCP_SEND_SIZE_MAX 4194304 2002 TCP Send Buffer Max Size NO
TCP_RECEIVE_SIZE_MIN 4096 2003 TCP Receive Buffer Min Size NO
TCP_RECEIVE_SIZE_DEFAULT 87380 2004 TCP Receive Buffer Default Size NO
TCP_RECEIVE_SIZE_MAX 4194304 2005 TCP Receive Buffer Max Size NO
GLOBAL_SEND_SIZE_MAX 1048586 2006 Global send size max (net.core.wmem_max) NO
GLOBAL_RECEIVE_SIZE_MAX 4194304 2007 Global receive size max (net.core.rmem_max) NO
18 rows selected.
Trackbacks 0
Comments 2
-
psb
2012.01.06 18:04
*.248.255.1
-
cuwoom
2012.01.10 14:34
*.6.1.2
DBA_FEATURE_USAGE_STATISTICS 이 뷰.... 11g 부터 정식 지원되는 뷰인덧... 선생님 왜 이럼?