For good performance in oracle need tunning your database. Can use Build Table for the example :
Build Table :
BEGIN SYS.DBMS_STATS.GATHER_TABLE_STATS ( OwnName => 'DIARYCODING_DB' ,TabName => 'TRANSACTION' ,Estimate_Percent => 0 ,Degree => 4 ,Cascade => FALSE ,No_Invalidate => FALSE); END;
Do build some table in database until finish.
www.diarycoding.com