This content has been marked as final. Show 3 replies
user9506868 wrote:Please post the details of the database version and OS.
As part of a clone (22.214.171.124) using hot backup, I am running the following.
EXEC FND_CONC_CLONE.SETUP_CLEAN;Are you running the command as apps user?
Every time I run this, it takes a couple hours to finish. That is just too long. Any known performance issues/bugs with running that?
It should not take long time to run it (should take less than a minute). Can you find any errors in the database log file? Any locks in the database? Please make sure you run the command before you bring up any of the application services.
user9506868 wrote:The only thing I could think of is enabling trace and see why the package takes that long to run.
EBS version is 126.96.36.199. DB version is 188.8.131.52
I don't see anything in the alert log while this is running. None of the services besides database and listener are up.
I am running this as APPS user.
SQL PERFORMANCE ANALYZER EXAMPLE [ID 455889.1]
SQL PERFORMANCE ANALYZER 10.2.0.x to 10.2.0.y EXAMPLE SCRIPTS [ID 742644.1]
SQLT (SQLTXPLAIN) - Tool that helps to diagnose a SQL statement performing poorly or one that produces wrong results [ID 215187.1]
TRCANLZR (TRCA): SQL_TRACE/Event 10046 Trace File Analyzer - Tool for Interpreting Raw SQL Traces [ID 224270.1]
You may also log a SR.