-
Export Problem - Hanging
Hi all,
Oracle Ver : 8.1.7.2
OP : Sun Solaris 2.7
Problem:-
I've tried exporting a table which has 23 million records (3.1gb) twice and both times it hung at the same point - I put feedback on and it stops at 15 million records (587mb - compressed). I've create a pipe and compressing the pipe to my dump file....
Also, when I try and do a select Count(0) from this table the whole db runs very slow, nearly to a halt...
I've tried the dbverify command on each of my datafiles and it reported no corruption... When not selecting on this table the db is fine with no problems at all
Any ideas????
-
I the gzip actually transfering from the pipe to the .dmp . or is the pipe just growing and growing and eventually filling the filesystem?
When running the exp, make sure the .dmp file in with you are piping to is growing and not only the pipe...
Specifically:
nohup gzip < gzip_pipe > exportfile.dmp.gz &
Cheers...
OCP 8i, 9i DBA
Brisbane Australia
-
the pipe is working properly - I was watching the pipe grow then back to 0 and the dmp file was getting bigger and bigger....
Could the table be corrupt?? - Select count(0) is killing the db!
How do I check to see if it is?
Thanks in advance
-
analyze table table_name validate structure;
OCP 8i, 9i DBA
Brisbane Australia
-
As my db is in CHOOSE mode, but runs in RULE. If I analyze a table it will force it into COST and the db will run like a dog?!
Is there a way around this??
-
Re: Export Problem - Hanging
Originally posted by krw
Hi all,
Oracle Ver : 8.1.7.2
OP : Sun Solaris 2.7
Problem:-
I've tried exporting a table which has 23 million records (3.1gb) twice and both times it hung at the same point - I put feedback on and it stops at 15 million records (587mb - compressed). I've create a pipe and compressing the pipe to my dump file....
Also, when I try and do a select Count(0) from this table the whole db runs very slow, nearly to a halt...
I've tried the dbverify command on each of my datafiles and it reported no corruption... When not selecting on this table the db is fine with no problems at all
Any ideas????
-
-
It won't actully calculate the statistics.
But for future reference you can...
analyze table table_name delete statistics;
OCP 8i, 9i DBA
Brisbane Australia
-
Well, let me ask the obvious.
Are you blowing out the mount point?
MH
I remember when this place was cool.
-
No - we are only using 37%
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|