Any easy way to chenge the SORT_AREA_SIZE setting of import session?

[AnySQL (d.c.b.a)]

Hi all:

Sort_area_size is critical to the speed of build index, how ever
when we use exp/imp to transfer data, there is no command option to
specify the sort_area_size.

I did a test that an "ALTER SESSION SET SORT_AREA_SIZE ..." command
can be embed into the dmp binary. Why oracle did not provide an option
in imp tool to change the setting.

Is there another easy way to accomplish this?

AnySQL from China
http://www.anysql.net/en/

[j***@gmail.com]

Use of a logon trigger comes to mind.

Jared

[s***@yahoo.com]

Why do you insist on hacking and screwing up things?
Why don't you just learn how to do things properly?

Ever heard of the ALTER SYSTEM set sort_area_size = ... deferred
command?
Probably not, because you don't read manuals, you start screwing up
exports right away.

I hope Oracle's lawyers will find you and crush you, you are a danger
to the profession.

[j***@gmail.com]

Post by s***@yahoo.com
Ever heard of the ALTER SYSTEM set sort_area_size = ... deferred
command?
Probably not, because you don't read manuals, you start screwing up
exports right away.

That would probably be fine if you want all other new sessions to get
the same value for SORT_AREA_SIZE.

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_2013.htm#i2061284

To target a particular user a logon trigger will do the trick.

Perhaps in the future you should check the manual and provide a
reference.

[Chuck]

Post by j***@gmail.com

Post by s***@yahoo.com
Ever heard of the ALTER SYSTEM set sort_area_size = ... deferred
command?
Probably not, because you don't read manuals, you start screwing up
exports right away.

That would probably be fine if you want all other new sessions to get
the same value for SORT_AREA_SIZE.
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_2013.htm#i2061284
To target a particular user a logon trigger will do the trick.
Perhaps in the future you should check the manual and provide a
reference.

The OP doesn't mention what version of Oracle's he's using, but if it's
9i or above why even mess with sort_area_size? You should be using
automatic work area sizing. Set the aggregate pga size to an appropriate
value and imp will use it for it's sort area.

[AnySQL (d.c.b.a)]

Whether to use this new feature is up to the DBA, right?

We may choose to keep on using sort_area_size.

[Sybrand Bakker]

Post by AnySQL (d.c.b.a)
Whether to use this new feature is up to the DBA, right?
We may choose to keep on using sort_area_size.

Sticking to sort_area_size and wasting your time on hacking the
database, instead of learning to use the new features, can be pretty
stupid.

--
Sybrand Bakker, Senior Oracle DBA

[Chuck]

Post by AnySQL (d.c.b.a)
Whether to use this new feature is up to the DBA, right?
We may choose to keep on using sort_area_size.

Yes, but if you explain to him that it will make his life easier, he may
just go for it. While you're at it, if he hasn't switched to automatic
undo management, tell him it will make his life *much* easier. He/she
might want to consider an 9i new features class.

[b***@gmail.com]

or an FAQs site such as:

http://www.jlcomp.demon.co.uk/faq/imp_slow.html