Home » RDBMS Server » Performance Tuning » Is it Oracle 10g slower comparatively Oracle 9i
Is it Oracle 10g slower comparatively Oracle 9i [message #166582] Fri, 07 April 2006 02:12 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 08:42:55 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.