Help -> ORA-03113 - Page 2

Paul · #16 (**permalink**) 02-22-02, 13:43

Quote:

would buy you a pint or something; but it seems your not quite round the corner...

Actually, I'm from the UK... I've been living & working in the US for the past 4 years on an H1B visa.
[QUOTE]
How can i avoid the same mistake again; won't it still happen when i try and delete the rows?

Quote:

Set the rollback segmen tablespace files to auto extend. This can be done through the OEM. You might also want to set FAST_START_PARALLEL_ROLLBACK to LOW. This is in the initialization parameters like before.

Quote:

Is there anyway to calculate the size of undo/rollback things neccessary to complete an operation
e.g. numberofrowstodelete/numberofrowsintable * 4 or something???

I'm sure there is, but that's way too complicated for me

Quote:

just out of curiousity what kind of machines should i be using for this amount of data (100mill rows) when its being processed alot?

Difficult to say without knowing what sort of processing. But as an example, one of my machines is a quad 500Mhz Xeon NT 4.0 box with 2GB RAM. It processes 13 million row batches of data and does some OLAP type analysis on it. It's fine. NT is actually very good at doing one thing quickly. The problems start when more than one user needs to access the data.

PS. DML is Data Manipulation Language (deleting, inserting, updating rows of data)... as opposed to DDL, Data Definition Language (creating, deleting objects)

rhs98 · #17 (**permalink**) 02-22-02, 14:00

I noticed you were in the US and have an expat's website. Also that i appears you own/run this whole website! It's been really useful so far!

I will try those ideas/comments you had about the undo/rollback. Just don't understand why i need to be able to undo stuff...

i am doing this [pseudo code];

Code:

get the first date in the database
get the last date in the database

all dates now in UTC curtosy of java.text.simpledateformat!

do this to each of the above
 trunc(dateinUTC/604800)*604800

for x=first to last date, step by a week
 update colx for allrecords in this week to contian x
 commit
 for each record with colx=x
  assignit a unique number incrementing from 120
commit
 reformat a bitmasked number
 update upto three columns depending upon the result
commit

Anyway; it's gone seven - meant to have left at 3:45pm

.
If ya come back to the uk, that pint offer still stands!

Internet Services

Web Development

Digital Marketing

Consumer Tech