Oracle which query is causing ORA-01652

2012-03-21  Source: Original Site  Category:Oracle  Views:0 

Advertisement

I am frequently getting ORA-01652 (unable to extend temp segment by 128 in temporary tablespace TEMP) in the alert log.
How to determine which statement is causing this, because the alert log does not show the SQL statement which results this error.

Related articles
  • Oracle which query is causing ORA-01652 2012-03-21

    I am frequently getting ORA-01652 (unable to extend temp segment by 128 in temporary tablespace TEMP) in the alert log. How to determine which statement is causing this, because the alert log does not show the SQL statement which results this error.

  • Oracle hash plan with very large inner table causes ORA-01652 2015-03-22

    we have a select with questionable plan: SELECT * FROM T1 where T1.F1 in (select T2.F1 from T2) Plan: Id Operation Name Rows Bytes TempSpc Cost 0 SELECT STATEMENT 59M 12G 1401K 1 HASH JOIN SEMI 59M 12G 55G 1401K 2 TABLE ACCESS FULL T1 260M 52G 489K 3

  • Oracle Update Query - Question - Error Ora-01427: Single-row Subquery returns than 2013-01-13

    Update Query - Question - Error Ora-01427: Single-row Subquery returns than one row Oracle Version: 9.2.0.8.0 What am I missing on my Update query to correct the problem? Query: { UPDATE ep SET ep.var1 = ( SELECT ep.varH FROM ep WHERE ep.code IN ('AB

  • Oracle Partition Split fails with Ora-01652 2012-05-02

    I am on Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production I have a Very Large Database and I am have a partition that has grown to 100Gb. I am trying to split this partition into smaller manageable partition. However I am getting the e

  • Oracle Which events would cause the controlfile to be backed up automatically? 2012-07-14

    In Recovery Manager, you have set controlfile autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which events would cause the controlfile to be backed up automatically?----No.97

  • Oracle Does RULE hint cause ORA-01555 errors ? 2013-09-21

    DB Version:9.2.0.5.0 OS:SunOS 5.9 Our DBA is saying that the RULE hint in the below SQL might be causing ORA-01555 error. Is it true? Does RULE hint cause ORA-01555 errors SELECT /*+ RULE */ COUNT(*) FROM ( SELECT /*+ RULE */ DISTINCT CAR_HDR.CAR_NBR

  • Oracle Which query is the job running ? 2014-01-26

    Normally when you want to see the currently running query by a session, you can just query the V$Session table and get the SQL_ID of a particular session. Then use SQL_ID to query V$SQL. However when a PL/SQL procedure is submitted via a job. You can

  • Oracle which query is best 2015-01-19

    Which query is best interms of performance. SELECT NAME COUNT(ID) AS CNT, RANK() OVER (ORDER BY COUNT(ID) DESC) AS RANK FROM TABLE_1 GROUP BY NAME SELECT NAME --- COUNT(ID) AS CNT, RANK() OVER (ORDER BY COUNT(ID) DESC) AS RANK FROM TABLE_1 GROUP BY N

  • Oracle SQL Query and Exception ORA-01722 2013-11-07

    I have a table called t_lookup which has three columns Lookup_Value, Description and Lookup_Type all of them are varchar2 type. If I execute the below query, its working fine SELECT * FROM (SELECT Lookup_Value ,To_Number(Description) Dd FROM t_Lookup

  • Oracle ASP.NET Impersonation causes ORA error 2012-11-19

    I have an ASP.NET Web application that executes queries on an Oracle Database. The queries work fine until we turned impersonation on in ASP.NET and now anytime it tries running the queries it fires an ORA-12638: Credential Retrieval Failed error. Wh

  • Oracle Merge with subquery causes ORA-38101 Invalid column in the INSERT VALUES C 2012-12-21

    The following is a somewhat shortened version of an SQL statement that is causing the error. MERGE INTO applicant_matches m_table USING ( SELECT DISTINCT s.student_id, a.term_scope_id, a.first_name, a.last_name, a.ssn_visa, a.birth_date, ... ) m_list

  • Oracle Run Query without TNSNAMES.ora information?? 2013-01-17

    I have created a simple tool in Microsoft Excel which basically runs macro to create a reports. Macro contains queries which executes on oracle database server. I can run this tool because I do have the TNSNAMES.ORA file on my desktop but I want to d

  • Oracle Distributed query failing with ORA-02019 2013-08-07

    We have a scenario involving 3 databases. (Say A, B, C) In databaase B, a proc runs selecting a table from database A and inserting into database C. We get a ORA-02019 error during this query. Here are some more details: Database B: The proc resides

  • Oracle OCI threaded sample causes ORA-00022 or ORA-01001 2012-05-18

    I have created a sample program which initializes environment in OCI_THREADED mode and then starts multiple threads. Usually it completes successfully, but sometimes it terminates with error ORA-00022 (invalid session ID; access denied) or ORA-01001

  • Oracle Which query is correct to check the allocated tbs,used tbs and free tbs? 2013-01-15

    Friends, First of all ..... I am newbie..... I want to how much space is allocated to all the tablespaces and how much is used now and how much is free now? I tried with the following 2 queries, i want to know which one will give a correct result. if

  • Oracle Spatial Stored Proc Causing ORA-29902 2013-08-11

    Good afternoon, I am getting an Oracle exception thrown when I try to run a spatial stored procedure. ORA-29902: error in executing ODCIIndexStart() routine ORA-13203: failed to read USER_SDO_GEOM_METADATA table ORA-13203: failed to read USER_SDO_GEO

  • Oracle Single SERIALIZABLE transaction causes 'ORA-08177' 2014-02-24

    Oracle version 10.2.0.3.0 I am building some tables in Oracle following the temporal data model, whereby each value in the table has a period of validity associated with it. When a value is updated, rather than directly update the row, I invalidate t

  • Oracle Which query will run faster 2012-05-29

    I have following two tables: SQL> desc customers Name Null? Type -------- ID NOT NULL NUMBER NAME VARCHAR2(20) SQL> desc orders Name Null? Type -------- CUST_ID NUMBER ARTICLE_NR VARCHAR2(20) PRICE NUMBER(5,2) I want to find each customer's ord

  • Oracle DataBase-link + SDO_geometry causes ORA-00600 internal error code 2013-04-20

    At KMS I recently ran into touble, when attempting to fetch a somewhat large geometry accross a DataBase-link. The geometry is a linestring consisting of 1476 points (x,y,z,o). I wish to select it from a production server onto our DataWarehouse serve

  • Oracle LEFT OUTER JOIN causes ORA-03113: end-of-file on communication channel 2013-07-13

    I encounter this error on a very simple LEFT JOIN. Here's the test: -- drop user mdb2 cascade; create user mdb2 identified by mdb2; grant resource, create session to mdb2; -- connect mdb2/mdb2; --create 2 tables: create table x1 (n number primary key