Re: mystic query (???)

From: <vuht2000_at_yahoo.com>
Date: 10 May 2004 09:36:28 -0700
Message-ID: <c9cd729c.0405100836.34a2431c@posting.google.com>

> ...
> "a.chr_id=b.chr_id" <-- same datatype?
> ...
> "and (a.position between b.class_start and b.class_end)"
> are these dates? Is it possible that you're nls settings are different,
> resulting in date conversions?
>
> Are the differences between your init.ora parameter settings between the
> two boxes? Have you used the analyze command, or dbms_stats?

They're all integer (chr_id, position, class_start...) here's sga:
server:

NAME                      VALUE
-------------------- ----------
Fixed Size               451752
Variable Size         201326592
Database Buffers       33554432
Redo Buffers             667648

pc:
NAME                      VALUE
-------------------- ----------
Fixed Size               450680
Variable Size         201326592
Database Buffers       33554432
Redo Buffers             667648

the init.ora files are identical. Some parameters:

db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_count=16

java_pool_size=83886080
large_pool_size=8388608
shared_pool_size=83886080
pga_aggregate_target=25165824
sort_area_size=524288
The 2 versions are fresh and all parameters are default. The only difference is the one on the PC is 9.2.0.1.0 while the one on the server is 9.2.0.5.0 (and maybe something hidden that I didn't find out). The tables involved are identical on the 2 boxes. I did run the analyze command.
Dan, I followed your ideas, and showed you the results, why is it not relevant ? Received on Mon May 10 2004 - 11:36:28 CDT