Oracle

Strange SQL
My VB application accesses the database via ADO and it seems that ADO (or is it the trace utility??) performs some weird SQL statements, which slows down the overall performance of the database. All these statements look like select * from (select null TABLE_CATALOG, ac.owner TABLE_SCHEMA, ac.table_name TABLE_... 12 Nov 2005 20:12

RAC internals - GLOBAL ENQUEUE SERVICES DEADLOCK DETECTED
We're encountering many of "Global Enqueue Services Deadlock detected" messages in the alert log of one of our database instances (two node RAC database) together with quite big global cache cr request waits in STATSPACK report. The problem is that the only other available information is trace file that looks like:... 11 Nov 2005 08:16

SP2-0332: Cannot create spool file
I am trying to run the following script CreateMovies.sql from sql plus. SP2-0332: Cannot create spool file. DROP USER MOVIES CASCADE * I am getting the above error and no clues what it means. any has clue? SK. CREATEMOVIES.SQL***************** SET ECHO OFF UNDEF DBNAME PROMPT WHAT IS THE DATABAS... 31 Oct 2005 00:38

Adjust AWE_WINDOW_MEMORY value
Hi, Context: OS Windows 2003, 8GB RAM, 4CPU Ref: Metalink note 225349.1 I'm trying to adjust the AWE_WINDOW_MEMORY value (set as key into the registry). I have set the AWE_WINDOW_MEMORY to 1GB (=1,048,576 Bytes) As describ into the Metalink note 225349.1: "If the # of Map misses is relatively high, or par... 9 Nov 2005 21:42

Error ORA-12547: TNS: lost contact
Hi all, I' ve patched Oracle 9.2.0.1.0 on Tru64 with patchset for Oracle 9.2.0.6. After I have installed it launching the runInstaller in tha Patch directory, i try to connect to sqlplus for the post installation tasks. But appears the error: ORA-12547: TNS:lost contact Here is my tnsnames.ora: OR... 24 Oct 2005 07:04

ORA-12518 Listener could not hand off connection
Background: Fresh install of oracle 10g on WindowsXP for a development enviroment. This computer is a laptop that moves between domains/ips. I used DBCA to create the database while I was attached to my work IP. This instance is setup in a dedicated server mode. Everything worked just fine at work but when I got h... 10 Oct 2005 04:58

CBO influences
Platform: 8.1.7 and 9.2.0.1 on various Win2k or Win2003 Last week a developer brought me a query that was running satisfactorily in prod (8.1.7), but took 45 minutes in test (9.2.0). As it happens, we are in the middle of transitioning a group of databases from 8i to 9i, and so have several copies of this data... 15 Sep 2005 09:12

TIMEOUT ON CONTROL FILE ENQUEUE
Oracle version 7.3.4.5.0 on HP-UX 10.20 (yes I know it's ancient :-) Last night (perhaps during a hot backup, I'm not certain yet), our Oracle instance came to a halt. The trace file has this, and: ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], [] ORA-00447: fatal error in bac... 13 Sep 2005 06:35

Exec statement
I am trying to use an exec statement to run a script on Dbvisualizer. However, I get this error exec test1.sql 11:27:53 [EXEC - 0 row(s), 0.000 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement .... 1 statement(s) executed, 0 row(s) affected, execution time 0.000 sec I'm sure t... 7 Sep 2005 18:06

iSQL*Plus Problem - ORA-12162: TNS:net service name is incorrectly specified
I seem to be able to connect locally using `sqlplus lee/$password(a)lee3` using SQL*Plus, but I get the following error when I use iSQL*Plus: ORA-12162: TNS:net service name is incorrectly specified I've seen plenty of similar posts on Google, but none of them have shed any light on the matter. My TNSNAME and ... 31 Aug 2005 19:51