Advertisement

09.25.2008 at 02:32PM PDT, ID: 23764395 | Points: 500
[x]
Attachment Details

Oracle Database - Test Query Execute Time And Log Results

Asked by jopie916 in VB Script, Oracle Database

Tags: ,

I have an application which uses an Oracle database. We are experiencing random slowness and our DBA group has asked for some statistics to see if there is a pattern. I would like to run a certain query at regular intervals and log the amount of time it took to execute the query.

I'm thinking VBScript,  SQLplus and Windows Task Scheduler? I need help getting VBScript to execute a query and then put the answer in a variable; I can handle it from there. I have VBScript code to handle the logging, etc...  Can VBScript query the database directly?Start Free Trial
[+][-]09.25.2008 at 02:41PM PDT, ID: 22574169

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.25.2008 at 03:08PM PDT, ID: 22574393

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.25.2008 at 03:23PM PDT, ID: 22574513

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.25.2008 at 04:26PM PDT, ID: 22574974

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.25.2008 at 04:38PM PDT, ID: 22575047

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.28.2008 at 12:00PM PDT, ID: 22592163

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.17.2008 at 01:29PM PDT, ID: 22744960

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.17.2008 at 01:30PM PDT, ID: 22744972

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.20.2008 at 01:10AM PDT, ID: 22755740

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-44 - Hierarchy / EE_QW_EXPERT_20070906