Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: optimize hash join between 2 large tables
Don't think I would do this for a batch process that runs in 2 hours
when the OLTP system is working smoothly. Sounds like a lot of
complexity and not worth the issues it might bring up. However, an
interesting exercise to do in a test environment.
Thanks Mladen.
Paula=20
-----Original Message-----
From: Mladen Gogala [mailto:mgogala_at_allegientsystems.com]=20
Sent: Friday, January 21, 2005 9:58 AM
To: Stankus, Paula G
Cc: oracle-l_at_freelists.org
Subject: Re: optimize hash join between 2 large tables
Paula_Stankus_at_doh.state.fl.us wrote:
>Other then use sort_area_size to sort in memory and parallel query what
>can be done to optimize a pull of 2 large tables joined together where=20
>most of the rows from both tables are selected???
> =20
>
You can put them in a 16K blocksize tablespace. That will speed up the
full table scan, but may also have some undesired consequences as Oracle
will need to maintain another buffer pool, another set of LRU latches,
probably another DBWR and it can be quite an interesting thing in
conjunction with workarea_size_policy set to auto.
-- Mladen Gogala Oracle DBA Ext. 121 BEGIN-ANTISPAM-VOTING-LINKS ------------------------------------------------------ Teach CanIt if this mail (ID 21915383) is spam: Spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D21915383&m=3D45ad= dbeda df3 Not spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D21915383&m=3D45ad= dbeda df3 Forget vote: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D21915383&m=3D45ad= dbeda df3 ------------------------------------------------------ END-ANTISPAM-VOTING-LINKS -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 21 2005 - 10:15:59 CST
![]() |
![]() |