-
Temporary tablespace filled up
How can I make the temp tablespace free up.
User ran a query last night and has taken 80 % of tablespace. but temp tablespace has not been freed up. If you restart the database the temp tablespace gets freed up, but is there any other way how a tablespace can free up.
-
Bet you're looking at the temp space through OEM aren't you.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
Adding to above, if the user runs one more create table as selct query, it would take 60% more. User is going to get an Error when the temp tablespace is filled. I want to free up the temp tablespace. is there any way I can do that??
When i issue below command I see free space 100%
select SUBSTR(SYSDATE,12) "TIME",Current_Users, Total_Blocks, Used_Blocks, Free_Blocks,
Round(100 * free_blocks / total_blocks,2) "% FREE"
from V$SORT_SEGMENT;
But if my freespace was 20% then what would be solution. I have my PCTINCREASE As 100 and initial and next 8mb.
-
I am looking at temp space through TOAD.
-
create a new one and drop the old.
-
create a new one and drop the old.
That cannot be solution every time and I guess thats not correct practice.
-
twmp will always show as full
are you getting unable to extend errors?
-
I am getting unable to extentd error
ORA-1652: unable to extend temp segment by 1024 in tablespace TEMP
-
How big is tablespace TEMP? Can you increase it's size?
Has the users CTAS sql got a cartesian join in it?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|