Home » RDBMS Server » Server Administration » Is user connection possible if temp space is 0%? (10g, RHEL 4)
Is user connection possible if temp space is 0%? [message #446848] Wed, 10 March 2010 12:31 Go to next message
oradbaexp
Messages: 16
Registered: January 2009
Junior Member
Hi

If the temp space left is 0%, i.e. all temp space used up, is it possible to make new DB connection ( can new users still connect to the DB)?

Or re-phrasing the question... How much of temp space (if at all ) is required for a new user to login to DB? Like SORT_AREA_SIZE in PGA. So, as memory sort area is already used ( Temp space is 100% full), can DB make more new connections?


Thanks in advance..

Regards


Re: Is user connection possible if temp space is 0%? [message #446851 is a reply to message #446848] Wed, 10 March 2010 12:33 Go to previous messageGo to next message
BlackSwan
Messages: 24906
Registered: January 2009
Senior Member
>If the temp space left is 0%, i.e. all temp space used up, is it possible to make new DB connection ( can new users still connect to the DB)?

YES or it depends.
Post SQL that you use to determine "temp space left is 0%"
Re: Is user connection possible if temp space is 0%? [message #446853 is a reply to message #446848] Wed, 10 March 2010 12:35 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Or re-phrasing the question... How much of temp space (if at all ) is required for a new user to login to DB?

0

Regards
Michel
Re: Is user connection possible if temp space is 0%? [message #446854 is a reply to message #446848] Wed, 10 March 2010 12:41 Go to previous messageGo to next message
oradbaexp
Messages: 16
Registered: January 2009
Junior Member
this is the sql i used.

select (free_blocks*8)/1024/1024 from v$sort_segment ss where ss.tablespace_name in (select tablespace_name from dba_tablespaces where contents='TEMPORARY');

(FREE_BLOCKS*8)/1024/1024
-------------------------
1.6875

SQL> sho parameter block

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------

db_block_checksum boolean TRUE
db_block_size integer 8192



=======

But , im-material of sql used, is temp space required for a user to connect to DB?

Regards..
Re: Is user connection possible if temp space is 0%? [message #446857 is a reply to message #446854] Wed, 10 March 2010 13:12 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But , im-material of sql used, is temp space required for a user to connect to DB?

Is my previous answer not clear?

Regards
Michel

[Updated on: Wed, 10 March 2010 13:15]

Report message to a moderator

Re: Is user connection possible if temp space is 0%? [message #447210 is a reply to message #446848] Fri, 12 March 2010 06:41 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
The answer was quite bold!!! Laughing
Re: Is user connection possible if temp space is 0%? [message #447305 is a reply to message #447210] Sat, 13 March 2010 07:24 Go to previous messageGo to next message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
Does it not depend on whether its on autoextend?
Re: Is user connection possible if temp space is 0%? [message #447323 is a reply to message #447305] Sat, 13 March 2010 09:13 Go to previous message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you mean 0 could be 00000?

Regards
Michel
Previous Topic: ORA-00607: Internal error occurred while making a change to a data block
Next Topic: How do view table constraints information (the correct way)
Goto Forum:
  


Current Time: Mon Sep 26 23:11:37 CDT 2016

Total time taken to generate the page: 0.25769 seconds