SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query works fine in DEV instance but not in PROD instance

User487692-OCOct 25 2012 — edited May 8 2013

Hi,
I got an exceptional situation. I wrote a query to get the sign-on audit information. The query works fine in Development instance and executes within 2 seconds. But if i run the same query in production instance it does not finish execution. I checked for around 2 hours and after that i just stopped it. Does any one have any idea to find about the problem like to check temporary table space or any other thing please let me know. so that i can suggest the DBA to check for those parameters.

RDBMS : 11.1.0.7.0
Oracle Applications : 12.1.3

I am using Oracle SQL Developer 2.1.1.64
I am missing TOAD so much. My current organization dont have license to use TOAD.

Regards,
Syed

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2013

Added on Oct 25 2012

5 comments

998 views