OraFAQ Forum: Performance Tuning » Difference in Toad & Oracle Report Builder

Home » RDBMS Server » Performance Tuning » Difference in Toad & Oracle Report Builder

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

Difference in Toad & Oracle Report Builder [message #147486]

Thu, 17 November 2005 17:55

vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton

Member

Hello All,

I had a strage situation. I dunno if this is silly question or not.But this has happened to me working with Toad & Oracle Report Builder.I tried running a query using Toad and i got the result in 5mins. But the same query takes me more than 3 hrs using Oracle Report Builder. Are there any specific reasons why two different tools take different times to execute a query. Any answers to this would be greatly appreciated.

Thanks,
Vikram

Report message to a moderator

Re: Difference in Toad & Oracle Report Builder [message #147537 is a reply to message #147486]

Fri, 18 November 2005 02:33

Frank
Messages: 7901
Registered: March 2000

Senior Member

The reason could be that you timed the retrieval of only the first rows in TOAD, whereas Reports retrieved all necessary rows.
Also, were the optimizer-settings the same?

hth

Report message to a moderator

Re: Difference in Toad & Oracle Report Builder [message #147590 is a reply to message #147537]

Fri, 18 November 2005 06:48

vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton

Member

Frank,

I dint use any hints and the query which i executed was on the same database(but i used different tools on it ). Are there any specific optimizer settings that can be done on Toad.

Thanks,
Vikram

Report message to a moderator

Re: Difference in Toad & Oracle Report Builder [message #147606 is a reply to message #147590]

Fri, 18 November 2005 08:57

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

Whether you "use hints" or not, TOAD fetches the first N records and stops, in effect running with a "FIRST ROWS" hint.

Report message to a moderator

Previous Topic:	recursive relationships
Next Topic:	Bind vs non-Bind query performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 20:39:02 CDT 2024