Category Archives: Uncategorized

EBS concurrent jobs(custom), which does simple selects for formatting, is taking significantly longer time (~ 8-9 mins)in Exadata Linux environment compared to AIX (< 2 mins). The spool output file was created under /applcsf/out and was about 568MB in size. Here’s a sample query: selectCASE_OWNER_DIV||’|’||CASE_OWNER_LOGIN||’|’||CASE_OWNER_NAME||’|’||CASE_STATUS||’|’||CASE_STATUS_REASON||’|’||to_char(CASE_STATUS_DATE,’dd-mm-yyyy’)||’|’||….…..……to_char(WOA_ISSUE_DATE,’dd-mm-yyyy’)||’|’||to_char(CASE_OWN_LAST_ACTION,’dd-mm-yyyy’)||’|’||to_char(CLIENT_LAST_ACTION,’dd-mm-yyyy’)from xxexp_marple Trail & error: We implemented the tried & testedContinue reading “EBS performance issue due to NFS mount options”