OATM Clarification
From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Tue, 8 Sep 2009 17:05:46 -0700
Message-ID: <a2b1e7610909081705v5b63e4d0g8a522d7c0c0180d8_at_mail.gmail.com>
Hi
In OATM data is placed according to usage. Right? So your data intensive tables in tablespace, stale data in another tabelspace etc.. But one question is if you have two tables that are heavily used (lot of inserts or lot of selects and could happen when two modules accessing different tables are running a concurrent program or could be just a bad select statement). In this case you are probably creating hotspots in an OATM model whereas in the old model, they would be accessed from a different datafile.
Date: Tue, 8 Sep 2009 17:05:46 -0700
Message-ID: <a2b1e7610909081705v5b63e4d0g8a522d7c0c0180d8_at_mail.gmail.com>
Hi
In OATM data is placed according to usage. Right? So your data intensive tables in tablespace, stale data in another tabelspace etc.. But one question is if you have two tables that are heavily used (lot of inserts or lot of selects and could happen when two modules accessing different tables are running a concurrent program or could be just a bad select statement). In this case you are probably creating hotspots in an OATM model whereas in the old model, they would be accessed from a different datafile.
Thank you
Kumar
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 08 2009 - 19:05:46 CDT