OraFAQ Forum: SQL & PL/SQL » Stored Queries

Home » SQL & PL/SQL » SQL & PL/SQL » Stored Queries (Oracle 7.3.3.6 Sql Navigator 3.2c5 WinXP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Stored Queries [message #382924]

Mon, 26 January 2009 07:19

da1uwant2meet
Messages: 13
Registered: October 2008
Location: texax

Junior Member

Is there a way to figure out how many times a specific stored query was run?

Report message to a moderator

Re: Stored Queries [message #382928 is a reply to message #382924]

Mon, 26 January 2009 07:43

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is a stored query?
If you mean procedure, there is no way.

Regards
Michel

Report message to a moderator

Re: Stored Queries [message #382930 is a reply to message #382928]

Mon, 26 January 2009 07:57

da1uwant2meet
Messages: 13
Registered: October 2008
Location: texax

Junior Member

Well we have stored queries in a in house program in which our users use, so they dont have to ask us to run them

Report message to a moderator

Re: Stored Queries [message #382931 is a reply to message #382930]

Mon, 26 January 2009 08:02

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

we have stored queries in a in house program

Do you mean the queries are hardcoded in the program?
Where are they stored?
Anyway unless you count the execution by yourself (which is easy if they are in your program or called by your program) you can't have this count.

Regards
Michel

Report message to a moderator

Re: Stored Queries [message #382934 is a reply to message #382931]

Mon, 26 January 2009 08:15

da1uwant2meet
Messages: 13
Registered: October 2008
Location: texax

Junior Member

Yes they are hard coded there...They are stored in the program

Report message to a moderator

Re: Stored Queries [message #382936 is a reply to message #382934]

Mon, 26 January 2009 08:22

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So you can/have to count the executions inside the program.

Regards
Michel

Report message to a moderator

Re: Stored Queries [message #382937 is a reply to message #382936]

Mon, 26 January 2009 08:24

da1uwant2meet
Messages: 13
Registered: October 2008
Location: texax

Junior Member

Thanks Michael, I know how to do it now...!!

Report message to a moderator

Previous Topic:	INDEX
Next Topic:	converting a cursor into a table?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 12:59:22 CST 2025