Sitemap

Amicuk Programming Answers

Never release the temp space

-0001-11-30   Views:0

Advertisement

It seems my oracle database never release temp space. The usage of temp space kept at 99.8% ,but there was no alarm in alert.log. It is not acceptable to shutdown the machine (7*24). It is said that oracle do not use temp space if the memory for sort

It seems my oracle database never release temp space.
The usage of temp space kept at 99.8% ,but there was no alarm in alert.log.
It is not acceptable to shutdown the machine (7*24).
It is said that oracle do not use temp space if the memory for sorting can hold processing statement.
But there is no large work load on the machine and whenever
select * from v$sort_usage
no record
what s wrong?
how can i release temp space without shutting down the server?
Sun fire v880 4 cpu at 1050Mhz Memory 8G
Solaris 8 0202
Oracle 92

The replay answer
Advertisement
You do not need to worry about it, unless you are getting "Unable to allocate ... in table TEMP" messages.
I believe that the space will be released if you bounce the database.
The 99% you are seeing is like a high water mark, which says that at some point 99% of your TEMP space was used. However no rows in v$sort_usage means that no space is currently being used.
So, relax!

Go to See the other 5 answers

Never release the temp space

Category:DefaultRelease time:-0001-11-30Views:130

It seems my oracle database never release temp space. The usage of temp space kept at 99.8% ,but there was no alarm in alert.log. It is not acceptable to shutdown the machine (7*24). It is said that oracle do not use temp space if the memory for sort[More]

Oracle.sql.BLOB.freeTemporary() is not freeing TEMP space in the database

Category:DefaultRelease time:-0001-11-30Views:130

Hi Folks, We are using oracle.sql.BLOB to store some file information into the database. Allocation of the temp space is done as below BLOB blob=BLOB.createTemporary(conn, false, BLOB.DURATION_SESSION); // this results in the usage of TEMP space from[More]

Temp space problem

Category:DefaultRelease time:2015-10-11Views:130

HI all, I receive an error while executing a procedure. ORA-01652: unable to extend temp segment by 128 in tablespace TEMP can any one please exlain what is the problem. thanks in advance baskar khi First ORA-01652 may occur because there is simply n[More]

Problem with temp space allocation in parallel query

Category:DefaultRelease time:2015-10-11Views:130

Hello I've got a query which matches two large result sets (25m+ rows) against each other and does some basic filtering and aggregation. When I run this query in serial it takes about 30 mins and completes successfully. When I specify a parallel degr[More]

Usage of temp space in oracle

Category:DefaultRelease time:-0001-11-30Views:130

I am using Informatica to load into one table in Oracle . Source and target table contains on CLOB colum. Source table size is 1GB. Target is oracle 10g with 30GB of temp space . Whenever i run this job TEMP space usage is complete 30Gb and job is fa[More]

Consuming too much temp space

Category:DefaultRelease time:-0001-11-30Views:130

Dear All A technical colleague of mine is executing a procedure which selects data from two databases and inserts it into the third one. The procedure is not new and he has been executing the same since a year now.However in past two weeks the proced[More]

Mapping   Execute Mapping Utilization of All Temp Space

Category:DefaultRelease time:-0001-11-30Views:130

Background: Creating a Master Table in Data Warehouse; Containing 16 tables (3 - outer joins; Remainder are inner; Total Target table size 8.2 Million reocrds) *** I've ran successfully when I create my own Select statement {takes about 60-70 seconds[More]

SQL query using lot of Temp space

Category:DefaultRelease time:-0001-11-30Views:130

I have sql query which is using lot of temp space , please suggest some ways to reduce this SELECT A.POSITION_NBR, TO_CHAR(B.EFFDT,'YYYY-MM-DD'), rtrim( A.SEQNO), A.EMPLID, B.REG_REGION, A.MANAGER_ID, A.REPORTS_TO, case when A.POSITION_NBR = A.REPORT[More]

How to determine what's using data store temp space?

Category:DefaultRelease time:-0001-11-30Views:130

How can one determine what's using data store temp space? We are interested to know what structures are occupying space in temp space and if possible what pid/process connected to TimesTen created them. Also, is there a procedure that will work if te[More]

V$temp_space_header showing temp space fully utilized but not true

Category:DefaultRelease time:-0001-11-30Views:130

hi, any experience regarding temp space headeR? currently we are experiencing this issue: when using this: SELECT tablespace_name, SUM(bytes_used), SUM(bytes_free) FROM v$temp_space_header GROUP BY tablespace_name; TABLESPACE_NAME SUM(BYTES_USED) SUM[More]

Estimating how much temp space a query will take?

Category:DefaultRelease time:-0001-11-30Views:130

I have a query that is "SELECT * FROM some_table ORDER BY field_name DESC". some_table has an avg_row_len of 458 bytes and stats are current. There are just about 6 million rows in some_table. TEMP is set to 500MB and the query fails for lack of[More]

Hot
Hi Experts, My query is about basic understanding of the System Landscape for using BW reports. Basically, There is a requirement to use BW reports on stand-alone SRM 5.5 server. Installation guide of SRM suggests that we can install BI 7.0 "content& [More]
I've been trying to view certain videos and listen to streaming music and sometimes it works (never that well) and other times it doesn't. I'm using QT not WM and when it works the videos don't play in the viewer. They usually download to the desktop [More]
I'm writing a document-based application using a CollectionView in each document. Following the guide http://developer.apple.com/library/mac/#documentation/Cocoa/Conceptual/Collectio nViews/ with the only modification in using the NSDocument subclass [More]
My laptop computer was stolen six months ago. I had over 100 purchases from itunes on that laptop. I recently got a new laptop. Is there any way I can recover my purchases from itunes on to my new laptop?I would ask here https://discussions.apple.com [More]
I get a folder with a "?" on boot up. I booted from the disk tools CD. Hard drive is listed, but no options are available - buttons are grayed out. I replaced the hard drive with the same results. What other options do I have to resolve this pro [More]
HP Pavilion dv7t-4100 Intel Core i7-720QM 1.6GHz 6GB, battery problem for newly purched Laptop, only giving 45 min to 1 h timings, please resolve the problemHi, Be sure that the battery is fully charge then try the following: Hit the ESC key after p [More]
Hi. I'm considering to buy a Mini for replacing my 400Mhz G4. I mainly use Photoshop and Illustrator for drawing/coloring (large files, hi resolution and so). I wanted to know if anyone uses a Mini for similar purposes and how well does the machine d [More]
Dear all, when i make import from user schema , i faced the problem of __arabic__ data corrupted ( ????????????) this warning is appeared in the log file of import can any one help me to solve this problem . import done in AR8MSWIN1256 character set [More]
How do I get my iphone contacts to my ipadI helped a friend sync his newmipad with iPhone contacts using the cloud method. Unfortunately, although he got all of his contacts on iPad, as he wished, he ALSO got all of his wife's contacts!  Each has the [More]
I have this problem of not being able to get rid of the Flash Player box covering my game in Facebook's Bingo Blitz.  I was able to get rid of this box in all other games where it showed up.  It won't let me click on ANYTHING in either the Flash Play [More]