SQL Performance (MOSC)

MOSC Banner

please clarify on below query

edited Jul 18, 2013 9:37PM in SQL Performance (MOSC) 6 commentsAnswered
Helllo Everyone,

Could you please help me for below query and kindly correct me if i am wrong anywhere?

query 1:I executed below query and it took 35 minutes to complete the task.In this case db_cache_size is 448m.
 
create table TEST.AI_ODS_RAW_MTNA_MSG_VADDAS AS SELECT * FROM ACCOUNTINFO.AI_ODS_RAW_MTNA_MSG_TBL_TEST;
 
-->Table AI_ODS_RAW_MTNA_MSG_TBL_TEST size is 104m and its lob size is 2gb.

-->below is the wait event when I executed the above query.
 
USERNAME    MACHINE                   STATUS      SID    SERIAL# SPID         SQL_ID        EVENT                          RUNNING_IN_MINS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center