Export 8.1.6 [message #50363] |
Wed, 13 March 2002 05:31 |
krb
Messages: 25 Registered: March 2002
|
Junior Member |
|
|
hi,
I am using Oracle 8.1.6 on NT the data is around 3GB. The full export used to take 16-20hrs to complete. Oracle local support here asked me to recreate the view EXU8SPSU in Sys..To my astonishment now the backup takes less than 4hrs.. Can anyone tell me what difference it makes
regards
KRB
|
|
|
|
Re: Export 8.1.6 [message #50367 is a reply to message #50363] |
Wed, 13 March 2002 05:52 |
krb
Messages: 25 Registered: March 2002
|
Junior Member |
|
|
CREATE OR REPLACE VIEW EXU8SPSU (OBJ#, LINE, SOURCE)
AS
SELECT O.OBJ#, S.LINE, S.SOURCE
FROM
SYS.SOURCE$ S, SYS.OBJ$ O
WHERE
S.OBJ#=O.OBJ#
AND O.OWNER#=SID
|
|
|
Re: Export 8.1.6 [message #50371 is a reply to message #50363] |
Wed, 13 March 2002 06:31 |
Sanjay Bajracharya
Messages: 279 Registered: October 2001 Location: Florida
|
Senior Member |
|
|
Interesting.
The view EXU8SPSU is built by catalog 'catexp' so you might as well run the whole catalog 'catexp' (they are harmeless no matter how many times you run them, as sys of coarse).
NOTE: 3 GB data taking 4 hours ? I still think this is quiet a lot, unless your hardware is the bottle neck. I have 17GB of data exported in around 90 min with some serious hardware in UNIX with Oracle 8.1.6. But this is not comapring apple to apple so ...
Try running 'exp' with a bigger BUFFER, I am pretty sure you can cut down from the 4 hours you currently have.
eg.
exp userid=..... buffer=524288
|
|
|
|
|
|
|
Re: Export 8.1.6 [message #50408 is a reply to message #50363] |
Thu, 14 March 2002 03:20 |
Sanjay Bajracharya
Messages: 279 Registered: October 2001 Location: Florida
|
Senior Member |
|
|
Great.
You went from 16-20 hours to 4 hours to 30 minutes...that's awesome.
Oracle rocks, specially when you have tuned things properly.
|
|
|