Oracle Log

Wednesday, March 28, 2012

Finding Literal Sqls

a better way to find literal sqls in oracle 10g

Finding literal sqls, example for ORACLE 10g & 11g

SELECT force_matching_signature, COUNT(1)
FROM v$sql
WHERE force_matching_signature > 0
  AND force_matching_signature <> exact_matching_signature
GROUP BY force_matching_signature
HAVING COUNT(1) > 10
ORDER BY 2


POSTED BY Oracle Log TIME: 5:03 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Oracle Log
View my complete profile

Archive

  • ►  2016 (1)
    • ►  January (1)
  • ►  2015 (8)
    • ►  October (1)
    • ►  September (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (2)
  • ►  2014 (1)
    • ►  March (1)
  • ►  2013 (4)
    • ►  December (1)
    • ►  July (3)
  • ▼  2012 (8)
    • ►  December (1)
    • ►  November (4)
    • ►  August (1)
    • ▼  March (2)
      • How to see environmental variables of a running pr...
      • Finding Literal Sqls
  • ►  2011 (6)
    • ►  September (1)
    • ►  July (1)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2010 (22)
    • ►  December (4)
    • ►  October (2)
    • ►  September (1)
    • ►  August (3)
    • ►  July (8)
    • ►  April (4)
  • ►  2009 (9)
    • ►  October (2)
    • ►  July (1)
    • ►  April (2)
    • ►  March (4)
  • ►  2008 (22)
    • ►  October (2)
    • ►  September (2)
    • ►  August (5)
    • ►  April (6)
    • ►  March (6)
    • ►  January (1)
  • ►  2007 (5)
    • ►  September (2)
    • ►  August (3)

My Links

  • Assoc. Prof. Dr. Bülent Saka

Certification

Certification
Powered by Blogger.