블로그
- SQL trace, 10046, trcsess and tkprof in Oracle 10g SQL trace, 10046, trcsess and tkprof in Oracle 10gThe quickest way to capture the SQL is being processed by a session is to switch on SQL trace or set the 10046 event for a representative period of time.
- 오라클 10g sqlloader ora10@linux1:[/oracle/app/oracle/product/10.2.0]$ vi sample.ctl load datainfile '/oracle/app/oracle/product ,b sysdate,c char(10)) ora10@linux1:[/oracle/app/oracle/product/10.2.0]$ vi sysdate2.dat 111,STRINGS222
- Oracle 10g R2 New Feature - New in-Memory Sort Algorithm 이란? 이때 달라지는 Plan은 DISTINCT 는 SORT(UNIQUE) GROUP BY는 SORT(GROUP BY)가 됩니다. 8i와 10g실행계획이 틀린건 기존 8i는 Group By절에 >>>> Oracle 10g R2 New Feature - New i.......
- REMOTE_LOGIN_PASSWORDFILE의 설정값 SQL> create user jclee identified by jclee default tablespace users temporary tablespace temp; SQL 불충분합니다 SQL> connect jclee/jclee as sysdba 연결되었습니다 SQL> shutdown 데이터베이스가 닫혔습니다 데이터베이스가 분리되었습니다 ORACLE
← 이전
3 페이지