OraFAQ Forum: Performance Tuning » Is it Oracle 10g slower comparatively Oracle 9i

Home » RDBMS Server » Performance Tuning » Is it Oracle 10g slower comparatively Oracle 9i

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

Is it Oracle 10g slower comparatively Oracle 9i [message #166582]

Fri, 07 April 2006 02:12

sponguru
Messages: 1
Registered: March 2006
Location: BANGALORE

Junior Member

Hi every body

Our product migrating from Oracle 9i to Oracle10g

we have Reports module,that having so many reports

while iam trying to generating report,i found an issue that is result set comming slowly comparatively is it correct or i did any mistake while configuring that Oracle10g

Can some help in this issue

Advanced thanks
Sreenivas

Report message to a moderator

Re: Is it Oracle 10g slower comparatively Oracle 9i [message #166605 is a reply to message #166582]

Fri, 07 April 2006 03:50

madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india

Member

check the optimizer statistics,query execution plan, also optimizer_index_cost_adj,optimizer_mode, pga_aggregate_target and optimizer_index_caching.

Thanks
Madhu

Report message to a moderator

Previous Topic:	slow connection to oracle 8 server with oracle 9 client
Next Topic:	Performance Tuning Tool

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 13:34:51 CDT 2025