| Understand how optimizer works [message #359559] |
Mon, 17 November 2008 04:57  |
psoftneto
Messages: 44
Registered: July 2008
|
Member |
|
|
Hi all,
I have two databases with the same data and the same statistics.
I don't understand with the plan for the same request is not the same on the two databases.
There is one database on which there is MERGE JOIN CARTESIAN and not on the other database.
What are the parameters which can explain that ?
Thanks.
|
|
|
|
|
|
|
|
|
|
| Re: Understand how optimizer works [message #359810 is a reply to message #359800] |
Tue, 18 November 2008 04:30  |
psoftneto
Messages: 44
Registered: July 2008
|
Member |
|
|
The following init.ora parameters are not the same or are not defined in the database with join cartesian:
java_pool_size
db_cache_size
db_file_multiblock_read_count
db_16K_cache_size
open_cursors
shared_pool_size
sga_max_size
log_checkpoint_interval
cursor_sharing
max_enabled_roles
parallel_max_servers
parallel_automatic_tuning
processes
job_queue_processes
fast_start_mttr_target
log_buffer
pga_aggregate_target
timed_statistics
max_dump_file_size
Database with join cartesian only:
hash_join_enabled=TRUE
query_rewrite_enabled=TRUE
star_transformation_enabled=FALSE
large_pool_size
sort_area_size
Can you tell me if some of those parameters should be aligned ?
Thanks
|
|
|
|
|
|
|
|
| Re: Understand how optimizer works [message #360600 is a reply to message #360584] |
Fri, 21 November 2008 10:04 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Its' weird - comparing this with your other thread its like you're only bothering to tell us half of the details on each thread.
If you honestly believe that making it difficult for us to understand what's going on will improve the quality of advice that you get, then I'd have to ask what colour the sky is on your planet.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
