Tag Info

Hot answers tagged

1

The session(s) using the temporary table can be queried as: select sid from v$lock where type = 'TO' and id1 = (select object_id from dba_objects where object_name = '&temp_table_name'); Then you can kill these sessions or have them release the locks gracefully.


1

You should not install more than one Oracle Client (per architecture) on one machine. For sure they do not work in parallel. By heart I know several issues: You would have to change PATH settings in order to determine which Client you want to use. TNS_ADMIN environment variable is used by both versions and must be set accordingly. Oracle OleDB provider ...


1

Are you using Enterprise Edition? It looks like this is a EE feature: http://docs.oracle.com/cd/B28359_01/license.111/b28287/editions.htm CTRL + F the docs and search for result cache and supported editions.


1

The procedure is described in the Remote Startup of a Database Instance part of admin guide for BS2000/OSD (I can't find this part in the Linux docs...). Essentially what you do is: Create an Oracle password file for your database if you haven't already done so Add a static registration for your instance in its listener Set the instance parameter ...


1

I don't think that tkprof is the problem. It is a tool that summarizes information from trace file. Tracing is the problem. If you enable tracing of a process, this may slow down the process considerable. Besides that the trace files may fill up your disks. Finally you should be aware that security relevant information is written to trace files.


1

Disclaimer: As @JustinCave wrote, you should contact Oracle support. I give the following information without any warranty. Source of Information: I found the following metalink notes that analyze this problem: ORA-08102: Rebuilding Index does not correct ORA-8102 (Doc ID 96118.1) ORA-8102 CORRUPT INDEX, ORA-1499 EVEN AFTER DROPPING AND RECREATING ...


1

A possible solution based on set operations. From my understanding you have to display all rows that contain a 'ticket' in the status fields and all rows with an 'import' in the status field where there is not a similar row with a 'ticket' in the status field. select id,name,testfield,status from mytable where status='ticket' union select ...



Only top voted, non community-wiki answers of a minimum length are eligible