"Oracle" 관련 글 53

v$loghist
Oracle/Oracle_reference 2016. 6. 22. 17:29
SQL> select * from v$loghist; THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM SWITCH_CHANGE# ---------- ---------- ------------- --------- -------------- 1 1 925702 21-JUN-16 956030 1 2 956030 21-JUN-16 956367 1 3 956367 21-JUN-16 971775 1 4 971775 21-JUN-16 988440 1 5 988440 21-JUN-16 998472 1 6 998472 21-JUN-16 1018673 1 7 1018673 21-JUN-16 1039361 1 8 1039361 22-JUN-16 1042273 1 9 1042273 22-JUN-16..
archive mode 변경
Oracle/Oracle_Admin1 2016. 6. 22. 17:27
SQL> alter system switch logfile; System altered. SQL> archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/11.2.0/dbs/arch Oldest online log sequence 23 Current log sequence 25 SQL> SQL> !mkdir -p /u01/arch SQL> alter system set log_archive_dest_1='location=/u01/arch/'; System altered. SQL> shutdown immediate; Database closed..
(Linux)Kernel Parameter : sysctl.conf
Oracle/Oracle_Admin1 2016. 6. 21. 18:19
[oracle@ORACLE-SVR ~]$ cat /etc/sysctl.conf # Kernel sysctl configuration file for Red Hat Linux # # For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and # sysctl.conf(5) for more details. # Controls IP packet forwarding net.ipv4.ip_forward = 0 # Controls source route verification net.ipv4.conf.default.rp_filter = 1 # Do not accept source routing net.ipv4.conf.default.accept_source_..
(Linux)_Kernel Parameter : limits.conf
Oracle/Oracle_Admin1 2016. 6. 21. 18:07
[root@ORACLE-SVR ~]# cat /etc/security/limits.conf # /etc/security/limits.conf # #Each line describes a limit for a user in the form: # # # #Where: # can be: # - an user name # - a group name, with @group syntax # - the wildcard *, for default entry # - the wildcard %, can be also used with %group syntax, # for maxlogin limit # # can have the two values: # - "soft" for enforcing the soft limits ..
SQL문이 실행되는 과정
Oracle/Oracle_Admin1 2016. 6. 16. 04:50
SQL문의 실행 원리 Parse -> Execute -> Fetch 1) User가 SQL 문장을 입력 (ex. select * from 테이블) 2) User Process가 SQL문장 -> Server에 전달한다. 3) SQL을 입력하면 ServerProcess로 전달한다. 4) Server Process는 syntax check -> semantic check -> 권한 검사(parce)를 하게된다. 여기에서 syntax check와 semantic check를 하기위해 Dictionary cache를 사용한다. 5) Shared pool의 library cache에 sql문이 있는지 check(hash 검사) 6) library cache를 Check해서 실행계획등이 있다면 execute 단계로 ..
admin

티스토리툴바