SQL> select object_name from dba_objects where object_name = 'DBMS_JAVA';
OBJECT_NAME
-------------------------------------------------------------------------------------------------------
DBMS_JAVA
DBMS_JAVA
DBMS_JAVA
- JAVA_POOL_SIZE 확인
SQL> show parameter java
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
java_max_sessionspace_size integer 0
java_pool_size big integer 0
java_soft_sessionspace_limit integer 0
- SHARED_POOL_SIZE 확인
SQL> show parameter shared_pool_size
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
shared_pool_size big integer 0
- 파라미터 정보 확인
SQL> l
1 SELECT name, value FROM v$parameter
2* WHERE UPPER(name) LIKE '%DB%'
SQL> /
NAME VALUE
----------------------------------------------------------------------------------------------
dbwr_io_slaves 0
db_file_name_convert
db_block_buffers 0
db_block_checksum TRUE
db_block_size 8192
.....
PFILE, SPFILE 파일
- PFILE 생성
- SPFILE 생성
- 조회
SQL> select value from v$parameter where name='control_files';
VALUE
-------------------------------------------------------------------------------------------------------/oracle/app/oracle/oradata/OCRL/control01.ctl, /oracle/app/oracle/oradata/OCRL/control02.ctl, /oracle/app/oracle/oradata/OCRL/control03.ctl
SQL> show parameter control_files;
NAME TYPE VALUE
---------------- --------- ------------------------------
control_files string /oracle/app/oracle/oradata/OCR
L/control01.ctl, /oracle/app/o
racle/oradata/OCRL/control02.c
tl, /oracle/app/oracle/oradata
/OCRL/control03.ctl
SQL> SELECT name FROM V$CONTROLFILE;
NAME
----------------------------------------------------------------------------------------------
/oracle/app/oracle/oradata/OCRL/control01.ctl
/oracle/app/oracle/oradata/OCRL/control02.ctl
/oracle/app/oracle/oradata/OCRL/control03.ctl
- Log Group 정보
SQL> SELECT groups, current_group#, sequence# FROM V$THREAD;
GROUPS CURRENT_GROUP# SEQUENCE#
---------- -------------- ----------
3 1 35
GROUPS : Online redo log group의 수
CURRENT_GROUP# : 현재 log group 번호
- Group, Member 정보
SQL> select group#, sequence#, bytes, members, status FROM v$LOG;
GROUP# SEQUENCE# BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- --------------------------------
1 35 52428800 1 CURRENT
2 33 52428800 1 INACTIVE
3 34 52428800 1 INACTIVE
- CURRENT : LGWR Process 가 현재 사용중인 상태.
- ACTIVE : 사용중이지는 않지만 긴 트랜젝션으로 인해 Recovery 에 필요한 상태.
- INACTIVE : Recovery 에도 필요하지 않은 상태
SQL> select group#, status, member from v$logfile;
GROUP# STATUS MEMBER
----------------------------------------------------------------------------------------------
3 STALE /oracle/app/oracle/oradata/OCRL/redo03.log
2 STALE /oracle/app/oracle/oradata/OCRL/redo02.log
1 /oracle/app/oracle/oradata/OCRL/redo01.log
[참고 : 오라클클럽 (www.oracleclub.com)]