OraFAQ Forum: Server Utilities » Getting EXP-00091, error- ora 04031 while performing export

Home » RDBMS Server » Server Utilities » Getting EXP-00091, error- ora 04031 while performing export (oracle 10g ,windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting EXP-00091, error- ora 04031 while performing export [message #391630]

Thu, 12 March 2009 14:22

sekharsomu
Messages: 72
Registered: December 2008

Member

Hi,
i am trying to take a
backup using export command unfortunately i am getting this

EXP-00091: Exporting questionable statistics.

so i tried to set NLS_LANG to utf8(this was what my database is set to ) as suggested in some thread in the forum but unfortunately it is being denied. I am also getting an error at the end as shown in the below code

EXP-00091: Exporting questionable statistics.

. . exporting table                      X_ROUTING         33 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                     X_SALESENG         20 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                     X_SHIPINFO        645 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                          X_TAC          1 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                      X_TAXCODE        721 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                     X_USERSTAC          2 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. exporting synonyms

EXP-00008: ORACLE error 4031 encountered

ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","unknown

object","joxlod exec hp","SGAClass")

EXP-00000: Export terminated unsuccessfully

Please guide me..

Report message to a moderator

Re: Getting EXP-00091, error- ora 04031 while performing export [message #391632 is a reply to message #391630]

Thu, 12 March 2009 14:26

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You can try statistics=none.
For the error, you may want to play with your SHARED_POOL_SIZE

Report message to a moderator

Re: Getting EXP-00091, error- ora 04031 while performing export [message #391638 is a reply to message #391630]

Thu, 12 March 2009 14:44

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Just realized you are in 10g.
shared pool settings depends on options you used (ASSM?)

Report message to a moderator

Re: Getting EXP-00091, error- ora 04031 while performing export [message #391759 is a reply to message #391638]

Fri, 13 March 2009 06:37

sekharsomu
Messages: 72
Registered: December 2008

Member

i didnt use ASSM while creating the data base i also want to remind that i was able to succesfully export the dump just some 10 days ago but now its being denied please do take a look into exp-00091 issue as well

Report message to a moderator

Re: Getting EXP-00091, error- ora 04031 while performing export [message #391765 is a reply to message #391759]

Fri, 13 March 2009 07:06

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>please do take a look into exp-00091 issue as well
Did you try statistics=none ?
>>i was able to succesfully export the dump just some 10 days ago
Then try your luck again when there is much less activity in the database.

Report message to a moderator

Re: Getting EXP-00091, error- ora 04031 while performing export [message #391808 is a reply to message #391765]

Fri, 13 March 2009 11:08

sekharsomu
Messages: 72
Registered: December 2008

Member

with STATISTICS=NONE its going well but still i am left with following error

. exporting synonyms

EXP-00008: ORACLE error 4031 encountered

ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","unknown

object","joxlod exec hp","SGAClass")

EXP-00000: Export terminated unsuccessfully

if u suggest me to increase the sga size please do suggest the amount it should be.
Another question its bit silly but still..
is there a chance of virus loading in shared memory i say this because as u can see it says some unkown code"joxlod exec hop"
**There is already lot of virus floating in the machine

[Updated on: Fri, 13 March 2009 11:10]

Report message to a moderator

Re: Getting EXP-00091, error- ora 04031 while performing export [message #391809 is a reply to message #391808]

Fri, 13 March 2009 11:24

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>if u suggest me to increase the sga size please do suggest the amount it should be.
How can I? Can I choose an arbitrary number?
It is your database, your environment, your load and your operations that effect.
http://download.oracle.com/docs/cd/B28359_01/server.111/b28278/e2100.htm#sthref1831

>>is there a chance of virus loading in shared memory i
Nope. This this has to do something within Oracle memory stack.

Report message to a moderator

Previous Topic:	IMP Datapump error
Next Topic:	Piping STDIN to SQLLDR on Windows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 20:21:39 CST 2024