BEGIN
DBMS_STATS.GATHER_TABLE_STATS('$DB_NAME', '$TABLE_NAME');
DBMS_STATS.LOCK_TABLE_STATS('$DB_NAME', '$TABLE_NAME');
END;
BEGIN
DBMS_STATS.UNLOCK_TABLE_STATS('$DB_NAME', '$TABLE_NAME');
END;
more..
SELECT To_char(SYSDATE,'CC')
FROM dual; --Century
SELECT To_char(SYSDATE,'YYYY')
FROM dual; --Year (*NOTE reducing the 'Y's reduces the display accordingly) from dual;
SELECT To_char(SYSDATE,'Y,YYY')
FROM dual; --Four digit year with comma
SELECT To_char(SYSDATE,'YYY,Y')
FROM dual; --Comma acts as a seperator. (Comma may be any punctuation eg !,/ etc..) from dual;
SELECT To_char(SYSDATE,'YEAR')
FROM dual; --Year in words
SELECT To_char(SYSDATE,'Q')
FROM dual; --The quarter of the year
SELECT To_char(SYSDATE,'MM')
FROM dual; --The number of the month
SELECT To_char(SYSDATE,'RM')
FROM dual; --The number of the month in roman numerals (Why!?) from dual;
SELECT To_char(SYSDATE,'MONTH')
FROM dual; --The month. (Rpadded to 9 with spaces); For lower case 'Month'.
SELECT To_char(SYSDATE,'WW')
FROM dual; --The week of the year
SELECT To_char(SYSDATE,'W')
FROM dual; --The week of the month
SELECT To_char(SYSDATE,'DDD')
FROM dual; --The day of the year
SELECT To_char(SYSDATE,'DD')
FROM dual; --The day of the month
SELECT To_char(SYSDATE,'D')
FROM dual; --The day of the week
SELECT To_char(SYSDATE,'DAY')
FROM dual; --THURSDAY The day of the week
SELECT To_char(SYSDATE,'DY')
FROM dual; --The day of the week abbreviated
SELECT To_char(SYSDATE,'J')
FROM dual; --Julian Date Number of days since January 1st, 4712BC
SELECT To_char(SYSDATE,'HH')
FROM dual; --hour clock. may also be to_char (SYSDATE,'HH12') from dual;
SELECT To_char(SYSDATE,'HH24')
FROM dual; --hr clock
SELECT To_char(SYSDATE,'MI')
FROM dual; --Minutes
SELECT To_char(SYSDATE,'SS')
FROM dual; --Seconds
SELECT To_char(SYSDATE,'SSSSS')
FROM dual; --The seconds since last midnight 
explain plan for
select * from emp;
select * from table(dbms_xplan.display);
explain plan
set statement_id = 'stmt1' for
select * from emp;
select * from table(dbms_xplan.display('plan_table','stmt1','all'));
select * from table(dbms_xplan.display('plan_table','stmt1','typical'));
select * from table(dbms_xplan.display('plan_table','stmt1','basic'));
당신의 의견을 작성해 주세요.