| oracle hangs [message #295424] |
Tue, 22 January 2008 05:27  |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
I can not login as any of the users who have default tablespace "treas".The sqlprompt/TOAD just hangs.
I can login as sysdba.
I doubt that the tablespace has run out of space.
I tried to query free space as sysdba but it hanged.
The alert file shows no error message.
|
|
|
|
|
|
| Re: oracle hangs [message #295537 is a reply to message #295424] |
Tue, 22 January 2008 11:19  |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
I am connecting locally.
WHat is the cause of this error?
How to trace a process?
I am sorry but i haven't touched the tuning part of oracle yet.
|
|
|
|
|
|
| Re: oracle hangs [message #295544 is a reply to message #295424] |
Tue, 22 January 2008 12:04 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
Following the link given, i can't see the required user "treas"
SELECT S.SID,
S.SERIAL#,
S.USERNAME,
S.OSUSER
FROM V$SESSION S,
V$PROCESS P
WHERE S.PADDR = P.ADDR
SQL> col sid for 999999
SQL> /
SID SERIAL# USERNAME OSUSER
------- ---------- ------------------------------ ------------------------------
1 1 SYSTEM
2 1 SYSTEM
3 1 SYSTEM
4 1 SYSTEM
5 1 SYSTEM
6 1 SYSTEM
7 1 SYSTEM
8 1 SYSTEM
9 648 SYS SUPERCOMP\Administrator
9 rows selected.
|
|
|
|
| Re: oracle hangs [message #295549 is a reply to message #295544] |
Tue, 22 January 2008 12:27 |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | i can't see the required user "treas"
|
Didn't you say it is the name of the tablespace?
Anyway, if it is not there then it is not connected and then you are not waiting for what you think.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
