Re: Different export times using sys or another user.
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: Harel Safra <harel.safra@xxxxxxxxx>
- Date: Mon, 21 Dec 2009 12:27:44 -0300
Export is a cold export, tested on a test server with no other load. (db has
no other user connected, and server has no other consuming process running).
Database is 9.2.0.8, tablespaces are dictionary managed (I know, I know),
there are about 200000 triggers in the DB and DB is about 400GB.
Consistent is set to yes, however there is no other user connected to the
database so contention is not an issue.
Alan.-
On Mon, Dec 21, 2009 at 11:55 AM, Harel Safra <harel.safra@xxxxxxxxx> wrote:
> Are you exporting the database using the parameter consistent = y?
> It'll cause the whole export to be done as a single read only transaction
> and could slow the export because of the need to generate more consistent
> read block images.
> Since consistent=y isn't supported for sys, when the export is run as sys
> it won't be in a read only transaction and may speed things up.
>
> You can find more details here:
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2250
>
> Harel Safra
>
>
> Guillermo Alan Bort wrote:
>
>> So, I have a user, FEXP, with the export full database role. Is it
>> possible that if I call a full export of the database it takes longer (a LOT
>> longer) with the FEXP user than with SYS?
>>
>> All other parameters are the same, and the export is on the exact same
>> database.
>>
>> just curious.
>>
>> cheers.
>> Alan.-
>>
>
Other related posts:
