| Is user connection possible if temp space is 0%? [message #446848] |
Wed, 10 March 2010 12:31  |
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 #446854 is a reply to message #446848] |
Wed, 10 March 2010 12:41  |
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..
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
