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 Gurus, I need to crate a Sales Order with reference to a Contract. I need to upload Sales Orders with reference to contract via LSMW. So far, I've been able to create the Sales Order with ref to contract. But, the Sales Order Quantity is not getti [More]
Hi, I need to package and sign a hybrid extension (an extension that includes a CSXS-based Flex extension and a native C++ event adapter for Illustrator). Following the instructions given here: http://help.adobe.com/en_US/extensionmanager/cs/using/pa [More]
Please help. itunes worked fine until I tried to download the most recent version.  Now it won't open at all.I am having a similar issue. It keeps asking for Quick Time version 7.5.5 and then shuts down. Are you getting any errors messages or is just [More]
Hi, I have an applet that contains Browse button. When user clicks on that, a File Open popup window should be displayed to enable user to select the input file. This file path should be given back as parameter. How to do this? I have tried using Loa [More]
I am trying to synchronize two different tracks in the same video and still. But I can not reduce the sound in the same way that we did in iMovie06/07 in which you just have to click in the track line up or down and adjust the volume. Can we do that [More]
First of all thanks for looking. CS4 OS10.5.5 mac book pro Sometimes when I path an image I will get the opposite effect. The object will be removed instead of the background. This is shown in the path window panel as the object (a guitar) is dark an [More]
HELP. I have lost my iWeb text tonight. Is there any way to restore? I have regularly Time Machine backupIf you mean that the text has gone missing in the iWeb application you can go into Time Machine and get an earlier version of the Domain.sites2 f [More]
Has anyone ever deployed a Harvest MSI app via Zenworks 3? Thanks!!!Are you having any particular issues? Errors? Have you tried http://www.appdeploy.com. They often deal with MSI related issues for many apps there. They can't help with ZEN, but if n [More]
Its a simple business directory whereby i've set two forms up, an add new record, and an edit record using PHP. To edit a record i choose the record for a drop down list/menu and then amend the data. However, which ever record i select to edit on fro [More]
>moved to Phones http://community.bt.com/t5/Phones/Activation-day-gone-and-no-broadband-or-Line/td-p/883428 If you want to say thanks for a helpful answer,please click on the Ratings star on the left-hand side If the reply answers your question then [More]