一個簡單的Oracle預存程序測試資料插入效率

一，測試準備

1 建立表資料空間

SQL> create tablespace cat_data nologging

datafile '/home/Oracle/app/oracle/oradata/catdb/cat_data.dbf' size 4096M

extent management local autoallocate;

 2，建立表索引空間

SQL> create tablespace cat_index nologging

datafile '/home/oracle/app/oracle/oradata/catdb/cat_index.dbf' size 4096M

extent management local autoallocate;

3，建立使用者

SQL> create user cat identified by cat default tablespace cat_data account unlock;

SQL> grant connect, resource to cat;

SQL> grant select on v_$instance to cat;

SQL> grant select on v_$session to cat;

SQL> grant select any table to cat;

SQL> grant alter any sequence to cat;

SQL> grant create any trigger to cat;

SQL> grant create any directory to cat;

SQL> grant create any procedure to cat;

SQL> grant create any table to cat;

SQL> grant dba to cat;

更多Oracle相關資訊見Oracle 專題頁面 http://www.bkjia.com/topicnews.aspx?tid=12

1 2 3 下一頁