Oracle Database Size for Different Platforms

[o_world]

Dear List,

We're live on Oracle 8.1.6 with Xe on NT. Lately we've been having problems
with our temporary table space in Oracle. In fact its becoming so large (>
5G) that we've had to bring Oracle down & re-boot the box.

We're just wondering what could be causing this (I believe a lot of disk
sorting could be one cause). Also someone mentioned that our database may
now be too large for Oracle on NT. Our data is 30G, if you include all
Oracles "bits" we're pushing 60G.

Is there an upper limit to Oracle on NT or is the problem due to sorting.
JDE uses a union join over F4211/F42119 quite a lot & ours is 9G alone.

Thanks in advance for any advice,

Ian

 

[Carl_Fisher]

There is no upper limit on Oracle on NT (within the limits of NT). We have a
total database of over 60Gb and we are expecting our final database to be
nearer 200 Gb.

We currently have a 5Gb Temporary tablespace, this seems to be big enough
for us, this is fixed - no extents etc., you may need to consider something
larger if you are joining two big tables regularly, possibly 10Gb, after all
NT disk space is cheap, so why be mean with it - we can get 18Gb disks fro
our servers for less than $500.

I am surprised at the need for a full table join so often, is this a UBE or
an Application, you may need to look at Indexing and data selection. Except
for Analysis and Reconciliation I can think of no situation where entire
tables need joining and sorting.



OW733.3 Xe SP 14.2
Enterprise Server - Intel NT + Oracle 8.0.6
Client - Citrix TSE + Some 95 and NT PC's

 

[o_world]

Carl,

Thanks for you're reply. Can you supply more details of your configuration,
do you use clustering, how often do you re-boot you're servers etc. How do
you stop you're Temporary tablespace exceeding its limit. Are there any
other 'house keeping' tasks we should be performing to keep Oracle in good
shape.

As far as I'm aware the business view in question is a standard JDE one.
The reason its used so often is that we have reports that may print from
F4211 or F42119 depending on the status of the order. I guess our real
problem is that F42119 contains 6 million records & we need to purge it

/ Ian

 

[Carl_Fisher]

Our Enterprise Server is a four way Compaq Intel NT box, with 2Gb Ram and
200Gb of Hard drive (SCSI Array Raid 0+1).
We have separate Logical Drives for Oracle Rollbacks and Oracle Temporary.

The Temporary tablespace is fixed in size - so it cannot grow. If it fills
up then a Oracle error is generated.

We regularly monitor Tablespaces and tables (we have an Oracle DBA who does
this once a month), to ensure that tablespaces do not fill up or grow beyond
available disk space.

Other than monitoring we find the most important job is to Optimise the
tables on a weekly basis, this keeps the table statistics up to date and
ensures that queries run efficiently.

As far as rebooting - we do this once a week, however we do stop all Oracle
services once a day - to allow for a full cold backup and restart them
again, this has the effect of clearing down both Temporary and Rollbacks.

Hope that helps.



OW733.3 Xe SP 14.2
Enterprise Server - Intel NT + Oracle 8.0.6
Client - Citrix TSE + Some 95 and NT PC's

 

[o_world]

Carl,

Once again thanks for your reply - its been very helpful.

One more question, I notice from your signiture that you have Windows '95
machines working with Xe. We are in the same boat (infact most of out
clients are '95) and we've been having terrible problems with 2 specific
applications namely batch control (P0011) and the exits to A/R & A/P from
the address book (P01012). The error is always an "invalid Page Fault" in
user.exe (or similiar)

Have you run into these errors & if so how have you resolved them. JDE tell
us the only solution is NT.

Thanks in advance,

Ian Cooke
Xe SP 14.1
Enterprise Server - Intel NT + Oracle 8.1.6, JAS
Client - '95 and NT PC's

 

[Carl_Fisher]

No an no - not seen so not had to resolve it. Sorry.



OW733.3 Xe SP 14.2
Enterprise Server - Intel NT + Oracle 8.0.6
Client - Citrix TSE + Some 95 and NT PC's