Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: mystic query (???)
> ...
> "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
![]() |
![]() |