Home » RDBMS Server » Server Administration » creation tablespace getting hanged (solaris 9)
creation tablespace getting hanged [message #337048] Tue, 29 July 2008 14:00 Go to next message
varunvir
Messages: 363
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.
Re: creation tablespace getting hanged [message #337054 is a reply to message #337048] Tue, 29 July 2008 14:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure it hangs? Maybe it just takes time.

Regards
Michel
Re: creation tablespace getting hanged [message #337055 is a reply to message #337054] Tue, 29 July 2008 15:08 Go to previous messageGo to next message
varunvir
Messages: 363
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,
Re: creation tablespace getting hanged [message #337056 is a reply to message #337048] Tue, 29 July 2008 15:15 Go to previous messageGo to next message
BlackSwan
Messages: 25038
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,
Re: creation tablespace getting hanged [message #337061 is a reply to message #337056] Tue, 29 July 2008 15:34 Go to previous messageGo to next message
varunvir
Messages: 363
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.
Re: creation tablespace getting hanged [message #337142 is a reply to message #337055] Wed, 30 July 2008 01:09 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: How to find version
Next Topic: Packeage Compilation
Goto Forum:
  


Current Time: Mon Dec 05 14:46:26 CST 2016

Total time taken to generate the page: 0.09865 seconds