Database Tuning (MOSC)

MOSC Banner

ASH report - Top SQL using literals

edited Nov 2, 2009 2:15AM in Database Tuning (MOSC) 11 commentsAnswered
 The report shows this sql in the list of sql using literals but I do not see any literal.

select this_.PRSPCT_ID as PRSPCT1_94_0_, this_.FRST_NM as FRST2_94_0_, this_.MID_NM as MID3_94_0_, this_.LST_NM as LST4_94_0_, this_.PRTY_ADDR_LNE_1_TXT as PRTY5_94_0_, this_.PRTY_CITY_NM as PRTY6_94_0_, this_.PRTY_PSTL_CD as PRTY7_94_0_, this_.RSRVN_NUM as RSRVN8_94_0_, this_.ADDR_LNE_1_TXT as ADDR9_94_0_, this_.ADDR_LNE_2_TXT as ADDR10_94_0_, this_.CITY_NM as CITY11_94_0_, this_.PSTL_CD as PSTL12_94_0_, this_.PRIM_PH_NUM as PRIM13_94_0_, this_.SCND_PH_NUM as SCND14_94_0_, this_.E MAIL_ADDR_TXT as EMAIL15_94_0_, this_.CMPGN_DT as CMPGN16_94_0_, this_.CMPGN_CELL_CD as CMPGN17_94_0_, this_.CMPGN_VER_ID as CMPGN18_94_0_, this_.ECN_NUM as ECN19_94_0_, this_.CLNT_NUM as CLNT20_94_0_, this_.LN_NUM as LN21_94_0_, this_.CHOICEPOINT_UIK_NUM as CHOICEP22_94_0_, this_.RVS_NUM as RVS23_94_0_, this_.IMPORT_DT as IMPORT24_94_0_, this_.LN_ORIG_SRC_NM as LN25_94_0_, this_.CMPGN_LABEL_01_NM as CMPGN26_94_0_, this_.CMPGN_LABEL_02_NM as CMPGN27_94_0_, this_.CMPGN_LABEL_03_NM as CMPGN28_94_0_, this_.CMPGN_LABEL_04_NM as CMPGN29_94_0_, this_.CMPGN_LABEL_05_NM as CMPGN30_94_0_, this_.CMPGN_DAT_01_TXT as CMPGN31_94_0_, this_.CMPGN_DAT_02_TXT as CMPGN32_94_0_, this_.CMPGN_DAT_03_TXT as

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