o_world
Member
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
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