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
Hello,      I want to delete fields form standard view which are appended by me accidentally . I have written a delete statement to delete the fields from the standard view . but i got an error at declaration part . I have declared it as shown below [More]
Hi all, Here is my situation: I have a client who wants Oracle 10GR2 RAC with OCFS2 on RHEL5 using FCP and Netapp storage.Till here I am ok, now he has nine different existing oracle 9i database single instance running on various RHEL3 servers, each [More]
Hello, I have Photoshop Elements 7.0 & with it I would like to try using the Adobe Photoshop.com Inspiration Browser tutorials.  However, every time I try to open a PDF tutorial on the Inspiration Browser I get an error message stating, "A suffic [More]
my homepage is correctly set in firefox, but i can't seem to do anything to keep chrome://ntsd-c/content/newtab/newtab.html from opening first, then i must open the yahoo tab second Thankshello, please try to [[Reset Firefox – easily fix most problem [More]
Hi All, In SAP R/3 PM, during the Work Oder creation in T-Code: IW31, we are getting the Message "IW 703 - Work Centre -- Locked in Plant -- " as WARNING. This happens whenever we use a locked Work Centre. But further it allows us to create the [More]
Would like to add a 2gb stick any suggestions on thirdparty sellers with reliable/guaranteed compatability besides owc?Since Micron's website shows their 2GB's at the "sampling" stage [expect the website isn't necessarily up to date on that page [More]
The Adobe InContext Editing service will undergo scheduled maintenance for approximately 1.5 hours starting at 10:00PM PST on Jan 14th, 2009. The service will be unavailable during this time. We appreciate your patience and apologize for any inconven [More]
Curious if it's possible to give away certain paid apps for free for specific promotions by use of gift cards or another means... has anyone done anything like this before?You would need to contact Apple. Apple, Inc. 1 Infinite Loop Cupertino, Ca  95 [More]
I have to program a game in Java for a university course. Therefore I need to display a quite big image (the game field). I tried to display the image with an own Panel Class ImagePanel: public class ImagePanel extends JPanel {     private BufferedIm [More]
Hi friends,, i recently updated my Standard N73 Firmware to V 4.0726.2.0.1 Thanks to Nokia, for i thinks it's faster than previous versions, same music player as ME with an exit button..picture quality improved,better Ram management,new versions of R [More]