Re: [GENERAL] [HACKERS] retrieve statement from catalogs
Re: [GENERAL] [HACKERS] retrieve statement from catalogs
От:
"Jaime Casanova" <el_vigia_ec@hotmail.com>
Дата:
Hi everybody, can anyone tell me if there's a way to retrieve the select instruction executed from the catalogs, or maybe via some structure in a trigger? The reason is that i have some selects constructed on-the-fly (just part of it) and i want to save that in a table in order to know what are the most used for optimizing them. Another reason for doing that is that i don't know all the selects in the program nor the page and this is an easier solution than examine all the code. thanx in advance, el_vigia _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
Re: [GENERAL] [HACKERS] retrieve statement from catalogs
От:
"David Busby" <busby@pnts.com>
Дата:
Can you just use the SQL logging and read that file afterwords? /djb ----- Original Message ----- From: "Jaime Casanova" To: ; ; Sent: Friday, November 07, 2003 14:59 Subject: Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement from catalogs > > Hi everybody, can anyone tell me if there's a way to retrieve the select > instruction executed from the catalogs, or maybe via some structure in a > trigger? > > The reason is that i have some selects constructed on-the-fly (just part of > it) and i want to save that in a table in order to know what are the most > used for optimizing them. > > Another reason for doing that is that i don't know all the selects in the > program nor the page and this is an easier solution than examine all the > code. > > thanx in advance, el_vigia > > _________________________________________________________________ > Protect your PC - get McAfee.com VirusScan Online > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster