DB 11.2.0.3 on Vista, same query, second execution is extremely slow, what could be the reason?
I have a SQL query, when executed first time, the response time is OK, it finished less than a minute, without changing anything on DB, the same query was executed the second time and now it is over 30 minutes, it is still running. What could be the reason? Thanks
This is the query execution
C:\temp\junk>sqlplus OSM7223_NP/OSM7223_NP@osm7.com
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 29 11:04:14 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> set autotrace on
This is the query execution
C:\temp\junk>sqlplus OSM7223_NP/OSM7223_NP@osm7.com
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 29 11:04:14 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> set autotrace on
0