QU: Parsing SQLs to sift out the similar ones

Dear All,

The (unique) sqls that were issued on the production database in the past two months have been captured in a table.

The uniqueness here is defined as a combination of HASH_VALUE and PIECE from V$SQL_TEXT.

What is the best way to sift out the sqls that are similar-structured?

Thanking you in advance.

Yours Very Sincerely
V Sa

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet