Oracle PL/SQL Note-No.1

1.查看目前有以登入的USER
   SQL>conn /as sysdba
   SQL>show user

2.修改USER密碼
   SQL>alter user ctxsys identified by CTXSYS

3.可查詢有哪些USER
   SQL>select username from dba_users;

4.將USER鎖定/解除鎖定
  SQL>alter user ctxsys account lock;
  SQL>alter user ctxsys account unlock;

5.Oracle的全文檢索同步

(1)先以CTXSYS登入DB

    sqlplus /nolog

    conn ctxsys/ctxsys

    執行 SQL>exec ctx_shedule.sql

(2)在以test登入DB

     SQL>conn test/test

     查 testuser索引名稱

     SQL>select index_name from user_indexes 

                where table_name='testuser' and index_type='DOMAIN'
(3)啟動同步(every 5 mins)

     SQL>exec ctx_schedule.startup('步驟2查到的索引名稱','SYNC','5');
(4)執行優化(every 120 mins)  

      SQL>exec ctx_schedule.startup('步驟2查到的索引名稱','OPTIMIZE FAST','120');

6.執行計畫
    SQL>set autotrace off--->default
    SQL>set autotrace on explain -->shows only optimizer execution path
    SQL>set autotrace on statistics
    SQL>set autotrace on
    SQL>set autotrace traceonly