QU: Parsing SQLs to sift out the similar ones
From: <vidya.shankar_at_firstdatacorp.com>
Date: 1998/02/05
Message-ID: <886710213.1784217605_at_dejanews.com>#1/1
Date: 1998/02/05
Message-ID: <886710213.1784217605_at_dejanews.com>#1/1
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 UsenetReceived on Thu Feb 05 1998 - 00:00:00 CET