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

Re: max number of handles 9.2, win32, partitioning

Tanel Poder

2004-07-29

Replies:
Hi!

> What is the largest number of user sessions *
> datafiles = filesystem handles that you've encountered
> in win32 land?

Hm, strange, I always thought that due the single-process architecture in
Win32, Oracle shares the file handles, but now when I started thinking a bit
about OS IO architecture and checked with process explorer, I see that yes,
there are separate handles for some objects (btw, handles in Windows may
mean file handles, registry handles and a great deal of other types of
handles which I don't know..)

>
> I had the bright idea of partitioning several large
> tables at a client site that are frequently hit, that
> typically supports 250 simultaneous sessions.

That's dedicated server config?

> I'm currently seeing around 6000 handles for 225
> threads in a non-partitioned setup for a single
> oracle.exe process.

I never checked the handle count, but the largest handle count could have
been on a 8.0 database with 600-700 datafiles and about 800 concurrent users
with dedicated sessions on WinNT 4.0 SP5. This was about 4 years ago, so I
guess Oracle9.2 on W2k should cope with more novadays..

> I'm aware of the parameter session_max_open_files and
> will have to bump it up.

This relates to BFILES only...

> To sum it up, If I partition 42 tables into 42
> partitions (months) that each have 42 indexes and 42
> users simultaneously access the application, will it
> throw an ora-00942 error? :)

The handle usage isn't dependant on structure inside the Oracle datafiles,
it depends on how many datafiles you have and how many processes (!) you
have accessing those datafiles (as you asked in your first question).

>
> thanks in advance.

my 2 cents :)

Tanel.


----------------------------------------------------------------
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
-----------------------------------------------------------------