Oracle Admin 기능

 

DBMS_JAVA 패키지 설치 여부 확인

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 생성

Control 파일

- 조회

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

Redo Log 파일

- 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)]