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
I am trying to sync voice memos from my iphone (ios8) to itunes (12.something) on my mac. The voice memos are on the phone. iTunes doesn't show them. Thus, 2 questions about syncing - 1 (obviously) - how can I get itunes to recognize that they're the [More]
Hello, I have very strange problem! 2 users complain that the outlook hangs every day, approximately at the same time. But other 200 users work fine. I can't see any error on the mail servers ( two servers exchange 2010 sp 3 with dag) Outlook can han [More]
I don't know what to do. It was working fine yesterday but now it won't recognize it anywhere and only shows the screen "connect to itunes" which it won't let me do.Try:                                                - iOS: Not responding or doe [More]
Hi, I am doing a simple file pass through using PI (File-PI-SFTP) and not using ESR. I have two requirements - 1. The target file name should be in the format xyz_yyyymmdd.dat The standard function with the receiver SFTP channel is to get the timesta [More]
Hi All, I need to generate a report that gives GL expense Acs with corresponding supplier invoice number and payment docu number. I am new to FI and not aware of the tables invloved Can anyone tell me the tables involved and the link? Regards, Anu> A [More]
Hi. I've been trying to use javax.xml.xpath.XPath to get a Node from a DOMSource. But with event the absolute simplest XPath expression //StaticComponent I get the following exception. Here's the code I'm using: XPath path = XPathFactory.newInstance( [More]
Hello all. I have a jtextpane in a jscrollpane and I'm using the following code to append a line in jtextpane and set the vertical scrollbar of jscrollpane at the bottom...   htmlDoc = (HTMLDocument) output.getDocument();   htmlKit.insertHTML(htmlDoc [More]
Hi All, When I create a document in CV01n and mention some description for that document, the description of the document is stored only in the log in language. e.g. I logged in with EN, then the description of the document will only be stored in EN [More]
Can I make payment of 250 dollars on the 27th of Feb. without any interruptions ?How much is due on your bill? This is a question which can olny be answered by calling into Verizon financial services. 800-528-7594Read other 2 answers [More]
ANYONE?You can usually enter anything you want for the user name, but the password will need to be the device password for the AirPort Extreme....(not the wireless network password).Read other 2 answers [More]