Database Administration (MOSC)

MOSC Banner

getting ORA-01555 ERROR with query Duration=0 sec

edited Aug 5, 2014 6:59AM in Database Administration (MOSC) 2 commentsAnswered

We are getting ORA-01555 Query Duration=0 sec.Any help will be appreciable.

select /*+ parallel(a 8) */ * from FCT_IN_DATA_CS5_stg partition(DATE_20140725170000) a

Sat Jul 26 17:39:30 2014

ORA-01555 caused by SQL statement below (SQL ID: 1mjp09hsuhrzt, Query Duration=0 sec, SCN: 0x0b3c.bda472ba):

/* SQL Analyze(1) */ select /*+  full(t)    no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad  */to_char(count("SERVICECLASS_ID")),to_char(substrb(dump(min("SERVICECLASS_ID"),16,0,32),1,120)),to_char(substrb(dump(max("SERVICECLASS_ID"),16,0,32),1,120)),to_char(count("ACCOUNTGROUP_ID")),to_char(substrb(dump(min("ACCOUNTGROUP_ID"),16,0,32),1,120)),to_char(substrb(dump(max("ACCOUNTGROUP_ID"),16,0,32),1,120)),to_char(count("ACCOUNTVALUEBEFORE_AMOUNT")),to_char(substrb(dump(min("ACCOUNTVALUEBEFORE_AMOUNT"),16,0,32),1,120)),to_char(substrb(dump(max("ACCOUNTVALUEBEFORE_AMOUNT"),16,0,32),1,120)),to_char(count("ACCOUNTVALUEAFTER_AMOUNT")),to_char(substrb(dump(min("ACCOUNTVALUEAFTER_AMOUNT"),16,0,32),1,120)),to_char(substrb(dump(max("ACCOUNTVALUEAFTER_AMOUNT"),16,0,32),1,120)),to_char(count("FAMILYANDFRIENDS_ID")),to_char(substrb(dump(min("FAMILYANDFRIENDS_ID"),16,0,32),1,120)),to_char(substrb(dump(max("FAMILYANDFRIENDS_ID"),16,0,32),

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