OraFAQ Forum: General » Cursor sharing = exact / similar

Home » Other » General » Cursor sharing = exact / similar (9.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cursor sharing = exact / similar [message #475859]

Sat, 18 September 2010 05:26

rrana
Messages: 1
Registered: September 2010
Location: kolkata,India

Junior Member

Hi

I am using oracle 9i (9.2.0.1.0). At present cursor_sharing = exact. For improve performance I have changed cursor_sharing = similar. After change from exact to similar some sql not working.

Exam.....

SELECT FORACID,ACCT_NAME, SCHM_CODE, ACCT_OWNERSHIP,LEAST(DRWNG_POWER,SANCT_LIM)+CLEAN_ADHOC_LIM+SINGLE_TRAN_LIM+CLEAN_SINGLE_TRAN_LIM+CLR_BAL_AMT-LIEN_AMT-SYSTEM_RESERVE D_AMT+FFD_CONTRIB_TO_ACCT+USED_CLEAN_SINGLE_TRAN_LIM
FROM GBM.GBM_GAM_VIEW
WHERE ACCT_CLS_FLG <> 'Y'
AND DEL_FLG <> 'Y'
AND ENTITY_CRE_FLG = 'Y'
AND schm_type LIKE '%%'
AND SOL_ID = '0457'
AND FORACID LIKE '%04570124163008%'
ORDER BY ACCT_OWNERSHIP,FORACID;

After execute this query no output comes but when cursor_sharing = exact 1000 row fetched.

Can any one help me where is the problem?

Regards
RRANA

[Topic SPLIT by LF]

[Updated on: Sat, 18 September 2010 09:48] by Moderator

Report message to a moderator