Yeah, so I have discovered when looking on metalink :-)
Nice of you to answer anyway, appreciate it.
Denham
-Original Message-
Sent: Monday, June 30, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L
ORA-3113 error is not very easy to track down. It's like ORA-600, but
relates to is
ORA-3113 error is not very easy to track down. It's like ORA-600, but relates to
issues in N/W
communication with Oracle datbases. There are a number of notes/articles on Metalink
discussing
this error. Hopefully some of that information helps you.
- Kirti
--- Denham Eva <[EMAIL PROTECTED]>
That is the whole problem, there is no logged errors, or trace files.
Everyone can connect via the MTS servers, no problem, however no one can
connect via dedicated server. Go figure.
Regards
Denham
-Original Message-
Sent: Saturday, June 28, 2003 6:54 PM
To: Multiple recipients of list O
Hi!
What does your alert log say? Or event log then?
Maybe, for some reason, Oracle is unable to start new processes on your
system. For MTS connection, no new processes are needed, but for dedicated,
there are.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMA
<[EMAIL PROTECTED]>
cc:
Subject:Re: Dedicated Server versus Shared Server
multiplexing architecture like this: long-running SQL operations tying up
a
shared server, DBMS_LOCK.SLEEP calls tying up a shared server, various
types
of locks or slowly-serviced operations tyi
or 10 minutes causing other sessions
> connected to it
> to hang for 10 minutes?
>
> Jared
>
>
>
>
>
> "Tim Gorman" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/15/2002 09:58 PM
> Please respond to ORACLE-L
>
>
> To:
15/2002 09:58 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Dedicated Server versus Shared Server
multiplexing architecture like this: long-running SQL operations tying up
a
shared server, DBMS_
Sergey,
I think we'll need to clarify what is meant by "system overhead is
reduced"...
The "code path" for a SQL statement certainly increases dramatically with
MTS, in comparison to the default "dedicated server" mechanism. After all,
the command from the client hits the dispatcher process, wh
Hello Eriovaldo,
I think you mean shared mode is multithreaded configuration.
The multithreaded server configuration (MTS) allows many user processes to
share very few server processes. The user processes connect to a
dispatcher background process, which routes client requests to the
next avail
Hamid,
What they mean by that is - assuming Unix here - set your ORACLE_SID,
ORACLE_HOME, and ORACLE_BASE to the database you want to connect to. Then
just issue svrmgrl or sqlplus. When you connect, you are connecting to the
database specified in your ORACLE_SID variable. The same goes for N
10 matches
Mail list logo