Home » RDBMS Server » Server Administration » Query size and Time
Query size and Time [message #50853] Thu, 11 April 2002 02:45 Go to next message
ridvan
Messages: 2
Registered: April 2002
Junior Member
hi everyone,
I am looking for how can I get a query result size in Oracle and also the query time I mean how many seconds or minutes a query holds for result.

Report message to a moderator

Re: Query size and Time [message #50854 is a reply to message #50853] Thu, 11 April 2002 02:48 Go to previous messageGo to next message
shri
Messages: 15
Registered: November 2001
Junior Member
use a tool called TOAD(quest product)

Report message to a moderator

Re: Query size and Time [message #50859 is a reply to message #50853] Thu, 11 April 2002 07:05 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
In SQLPlus, do 'set timing on' which gives the time it has taken to execute the query.

Report message to a moderator

Re: Query size and Time [message #50881 is a reply to message #50853] Fri, 12 April 2002 01:52 Go to previous message
ridvan
Messages: 2
Registered: April 2002
Junior Member
All are good solutions but i want to know if i can find the time at server side. when a query executed I want to know its timing and also beside this its result size in kilobytes.

Report message to a moderator

Previous Topic: Auto extend
Next Topic: Database migration between NT and Unix
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 13:35:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.