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)
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...
-
1) For new table creations - after creating the table in custom schema execute below script to generate editoning view and synonym for it in...
-
1) To hold the specific concurrent program Hold update fnd_concurrent_requests set HOLD_FLAG='Y' where PHASE_CODE='P'...
-
List out the Jobs which were already on HOLD select request_id, phase_code, status_code from fnd_concurrent_requests where hold_flag = ...
1 comment:
Thanks for the informative article! waiting for your next post unicorn private equity
Post a Comment