Hi Saludes,
That was an excellent solution it worked perfectly. But tell me what are
the side effects of changing this parameter. It means I cannot use
theoptimizer features of 9i.
Regards,
Shahed Baig . M
"Harold Flores " <[Email address protected]
26/01/2005 18:25
To: SHAHED.[Email address protected]
cc:
Subject: RE: Query issue in 9i
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
Change the init ora Optimizer_features_enable to 8.1.7 and restart the db,
this will solve your problem
Saludes
Harold Antonio Flores Hernandez
Supervisor de Soporte Tecnico, Redes y Comunicaciones
INISER
Tel. 266-6772 ext 3706 Fax:266-5636
cel: 088-14257
mail: [Email address protected]
-----Mensaje original-----
De: Shahed
[mailto:oracledba-ezmlmshield-x85493189.[Email address protected]
Enviado el: Martes, 25 de Enero de 2005 04:53 a.m.
Para: LazyDBA Discussion
Asunto: Re: Query issue in 9i
Hi,
I have noticed that when I execute the query in 9i, I/O Phys Read in
Sessions screen (OEM) is showing a value of 4500 for each execution of the
query.
Whereas in 8i it is only 5.
same case with logical reads.
System Params
shared_pool_reserved_size 55364812
shared_pool_size 528482304
db_block_buffers 0
db_block_checking FALSE
db_block_checksum TRUE
db_block_size 8192
db_cache_advice ON
db_cache_size 142606336
db_file_multiblock_read_count 16
sga_max_size 1309747452
Can you help.
Regards,
Shahed Baig . M
"kazi " <oracledba-ezmlmshield-x74885030.[Email address protected]
25/01/2005 10:53
To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: Re: Query issue in 9i
You should provide more data. But first you should gather statistics.
Older way:
analyze table AAA compute statistics;
will do, but it is better to use dbms_statistics. If your problem persist,
then serious approach to optimizing should be taken. Consider:
- indexes,
- size of table
- distribution of values in critical columns (histograms)
- your query
- whole execution plan data
...
KAzi
Shahed wrote:
>Hi gurus,
>
>I have migrated from 8i to 9i. There is a query which was quite faster
>in
>8i (1sec) but it became slow in 9i (1 min).
>I ran the explain plan. The position value is as follows
>in 8i Cost =1846
>in 9i Cost = 93241102
>
>pls suggest how to fix this issue
>
>Both have optimizzer_mode set to "choose".
>
>Regards,
>Shahed Baig . M
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
>see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com By using this list you agree
>to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see
http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to
these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page