Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

FW: Why "Separating Data and Indexes improves performance" is a
 myth?

Tim Gorman

2004-04-27

Replies:
Barb Baker: Do you want to tell everyone about the 3rd-party COTS
application that demanded DB_BLOCK_SIZE = 4608? And the rationale behind
that number?

Hopefully it's been migrated to a dumpster by now, right?


------ Forwarded Message
From: "Jonathan Lewis" <jonathan@(protected)>
Reply-To: oracle-l@(protected)
Date: Mon, 26 Apr 2004 21:32:36 +0100
To: <oracle-l@(protected)>
Subject: Re: Why "Separating Data and Indexes improves performance" is a
myth?


I believe Stephan Haisley has built a 9i database
with a 7.5K block size (not for production reasons,
of course).

There is an argument for using a (slightly) unusual size
block if your main purpose is to handles large numbers
of uniformly sized LOBs. Whether it would work or not
is something to be investigated.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

April 2004 Iceland http://www.index.is/oracleday.php
June 2004    UK - Optimising Oracle Seminar
July 2004 USA West Coast, Optimising Oracle Seminar
August 2004 Charlotte NC, Optimising Oracle Seminar
September 2004 USA East Coast, Optimising Oracle Seminar
September2004 UK - Optimising Oracle Seminar

----- Original Message -----
From: "Jacques Kilchoer" <Jacques.Kilchoer@(protected)>
To: <oracle-l@(protected)>
Sent: Monday, April 26, 2004 7:11 PM
Subject: RE: Why "Separating Data and Indexes improves performance" is a
myth?


> -----Original Message-----
> Paul Drake
>=20
> I would think that non-power of 2 block sizes would
> subject the actor with ORA-600s beyond their wildest
> dreams.

I don't think you can even create a tablespace with a blocksize that's =
not a power of 2 with Oracle 9.0 or higher, but I can tell you that an =
8.1 database with a blocksize of 3K and a locally managed autoallocate =
tablespace makes for some amusing ORA-600s.


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

------ End of Forwarded Message

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------