OraFAQ Forum: Server Administration » creation tablespace getting hanged

Home » RDBMS Server » Server Administration » creation tablespace getting hanged (solaris 9)

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

creation tablespace getting hanged [message #337048]

Tue, 29 July 2008 14:00

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi I am tng to create tablespace but following statement is getting hanged:-
SQL> CREATE TABLESPACE dev02_PERM DATAFILE '/global/oracle/oradata/Udev10g/dev02_perm.dbf' SIZE 100M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE;
Please tell me the solution.

Report message to a moderator

Re: creation tablespace getting hanged [message #337054 is a reply to message #337048]

Tue, 29 July 2008 14:45

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you sure it hangs? Maybe it just takes time.

Regards
Michel

Report message to a moderator

Re: creation tablespace getting hanged [message #337055 is a reply to message #337054]

Tue, 29 July 2008 15:08

varunvir
Messages: 389
Registered: November 2007

Senior Member

yes Michel i am sure..I kept it for an hour but nothing happend .I tried many times but it is giving no response.
Regards,
Varun Punj,

Report message to a moderator

Re: creation tablespace getting hanged [message #337056 is a reply to message #337048]

Tue, 29 July 2008 15:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Is there anything interesting at the tail end of alert_SID.log file?

Repeatedly issuing

select * from v$sess_io where sid = <new_tbs_sessionid>

& you can see whether or not the statistics are increasing,

Report message to a moderator

Re: creation tablespace getting hanged [message #337061 is a reply to message #337056]

Tue, 29 July 2008 15:34

varunvir
Messages: 389
Registered: November 2007

Senior Member

I dont see anything special at tail of alert.log file and Block_gets and consistent_gets in v$sess_io are increased by 1 when I run the command.

Report message to a moderator

Re: creation tablespace getting hanged [message #337142 is a reply to message #337055]

Wed, 30 July 2008 01:09

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

yes Michel i am sure

How did you verify this?
Hang means no io no cpu just wait on something. What did you do to verify it hangs?

Regards
Michel

Report message to a moderator

Previous Topic:	How to find version
Next Topic:	Packeage Compilation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 22:34:07 CST 2024