Re: 11gR2 - what patch level?
- From: Nuno Souto <dbvision@xxxxxxxxxxxx>
- Date: Tue, 06 Jul 2010 15:56:03 +1000
That's on a fully populated installation, with all features being used.
In our HR/Payroll db of which only HCM is being used, we have 29000
tables and 34000 indexes. Of these only about 2000 have any data,
everything else is empty. Or at least, that's what a full export shows.
That is my worry.
--
Cheers
Nuno Souto
dbvision@xxxxxxxxxxxx
Go-Faster Consultancy Ltd. wrote,on my timestamp of 6/07/2010 7:17 AM:
Although I haven't played with this feature in conjunction with
PeopleSoft myself, I don't think it would be a huge problem.
Most of the empty tables in PeopleSoft are PeopleSoft Temporary Records
- these are normal database tables used for temporary working storage by
Application Engine programs. PeopleSoft (since version 8) creates many
identical temporary tables and allocates different tables to different
instances of the same program. It is better than multiple concurrent
processes sharing the same temporary record (and before someone askes
they don't use Global Temporary Tables because they are Oracle specific).
You tend to get the same temporary tables reused repeatedly. You might
have 10 copies of a table, but if you only ever run one instance of a
program which uses that table at any one time, then normally you should
only ever access the same temporary table, and you might never access
the other 9. So, you only create the one physical segment.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
