Wednesday, June 16, 2021

coe_xfr_sql_profile

Example: SQL Tuning Task Options (Doc ID 2461848.1)



Good Plan Hash Value Not Showing in One of the RAC Node for Sqlid Even After Forcing Plan (Doc ID 2422536.1)


Encouraging CBO to Pickup a Better Execution Plan Using the COE XFR SQL Profile Script (Doc ID 1955195.1)
at

1 comment:

inflation hedge funds said...

Thanks for the informative article! waiting for your next post unicorn private equity

July 13, 2021 at 6:42 AM

Post a Comment

Subscribe to: Post Comments (Atom)

user level export and import

expdp parfile=PLCT170.par oracle@uslp123sd7dfcvxsza > more PLCT050.par userid= "/ as sysdba" dumpfile=T050.dmp logfile=expdpT0...

  • Scripts required for 12.2.X custom
    1) For new table creations - after creating the table in custom schema execute below script to generate editoning view and synonym for it in...
  • How to hold the concurrent programs
    1) To hold the specific concurrent program Hold update fnd_concurrent_requests set HOLD_FLAG='Y' where PHASE_CODE='P'...
  • coe_xfr_sql_profile
    Example: SQL Tuning Task Options (Doc ID 2461848.1) Good Plan Hash Value Not Showing in One of the RAC Node for Sqlid Even After Forcing Pl...