http://www.databasejournal.com/news/article.php/3748706/On-Seeing-Double-in-VSQL.htm
On Seeing Double in V$SQLMay 22, 2008 [From Oracle Corp.]Our technologist looks at SQL repetition in V$SQL and differences in cardinality. I often find more than one row in V$SQL for a given SQL statement. I am wondering why that is, which one of those rows represents the "active" SQL statement, and which one users executing that SQL statement in the database will use. The article continues at http://www.oracle.com/technology/oramag/oracle/08-may/o38asktom.html |
The Network for Technology Professionals
Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers