RE: ** can two processes use the same rollback extent

on Amazon.com! -Original Message-From: A Joshi [mailto:[EMAIL PROTECTED]Sent: Sunday, December 28, 2003 12:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: ** can two processes use the same rollback extent Hi, A simple rollback segment question. If I do not set a optimal

RE: ** can two processes use the same rollback extent

the size or number of rollback segments is inadequate. Systems can be constructed where ORA-1555 is inevitable. (For example processes doing lots of DML concurrent with processes that execute long running queries.) There's been a *LOT* written on ORA-1555 over the years. If you have specific

Re: ** can two processes use the same rollback extent

segment can be used by multiple transactions/processes but what about the extents? Is it safe to assume that only one transaction/process can use one extent? What is a good way to size the extent for warehousing tasks? Or guess the rollback generated and size needed. Thank You Do you Yahoo!?Protect

Re: ** can two processes use the same rollback extent

A single block can only be 'owned' by one transaction at a time, but when a transaction commits, it may put its last undo block into that segment's 'free pool' list if there is a lot of free space left in the block so that it can be made available for new transactions . (Gaja Vaidyanatha quoted

Re: ** can two processes use the same rollback extent

Yes Jonathan: I think that 400 byte concept came from one of the TPC benchmarks during Oracle 7 (or ORacle 6) days where the average undo size for a transcation was around 380+ bytes. So they had rounded that to 400 bytes and a maximum of 5 blocks will be linked to the freelist in the undo

Re: ** can two processes use the same rollback extent

IIRC, a segment will not wrap into an extent that has an active transaction in it, but rather allocate a new extent. So the answer is...it depends. Daniel Fink A Joshi wrote: Hi, One rollback segment can be used by multiple transactions/processes but what about the extents? Is it safe

Re: ** can two processes use the same rollback extent

: ** can two processes use the same rollback extent [EMAIL PROTECTED] ity.com

** can two processes use the same rollback extent

Hi, One rollback segment can be used by multiple transactions/processes but what about the extents? Is it safe to assume that only one transaction/process can use one extent? What is a good way to size the extent for warehousing tasks? Or guess the rollback generated and size needed. Thank You

Re: ** can two processes use the same rollback extent

of list ORACLE-L Sent: Wednesday, December 03, 2003 9:09 AM Subject: ** can two processes use the same rollback extent Hi, One rollback segment can be used by multiple transactions/processes but what about the extents? Is it safe to assume that only one

Re: Set processes at init.ora

DBAs Our database running on NT 2000 is over 200 processes today and I had to reset to a hight No. As I know, if I set highter for this parameter, the will be impact on Unix system, I wonder there is any impact on windows. thanks in advance Mitchell -- Please see the official ORACLE-L FAQ

Re: Set processes at init.ora

connection detection on win32 is non-existent, hence improperly terminated sessions can hang around for quite awhile. You do not have to explicitly set any OS parameters in hiking up the number of processes in the init.ora. Depending upon your oracle server version (which again, is unknown here) you

Re: Set processes at init.ora

Thanks Pd for your answered. The Os is window 2000 and Oracle 8.1.6.0.0. I run the query v$resource_limit after I reset processes No to 250. andsaw the No. is up and stable to 110 process. I will keep monitor it and make sure all session disconnected. I wonder if processes is set to higher

Re: Set processes at init.ora

$resource_limit after I reset processes No to 250. andsaw the No. is up and stable to 110 process. I will keep monitor it and make sure all session disconnected. I wonder if processes is set to higher, any impact to memory or resource usage? Mitchell - Original Message - From: Paul Drake

Re: HP-UX 11/9iR2/Processes

Hi! In addition to docs, you can select name, description from v$bgprocess to see names and max numbers of all background processes. For example DBW% prorcesses go from DBW0 up to DBWj Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday

HP-UX 11/9iR2/Processes

Hi Everyone: I've noticed a new type of background process in my 9iR2 databases. It's name is ora_j00n_SID. Does anyone know what this process is? Any links to Docs? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL

Re: HP-UX 11/9iR2/Processes

It is the snp equivalent ...in 9i rel2 there is a job coordinator process and based on the job_queue_processes parameter ...that many jnnn processes. Murali

using dbms_alert to manage multiple processes

I have a coordinator package that is going to run alot of long running batch processes through dbms_job. Could be as many as 300 of them. I know to set my job_queue_processes = 36. however, I want to 'wait' until all of these are done. My concern is with concurrency. here is pseudo code

RE: using dbms_alert to manage multiple processes

Title: RE: using dbms_alert to manage multiple processes Will all processes signal one named alert or a process specific alert? If it is one alert then keep counting as you receive, if they are individually named alerts, keep a local pl/sql table and mark as you receive them. When you have

Re: RE: using dbms_alert to manage multiple processes

PROTECTED] Date: 2003/08/15 Fri PM 02:24:23 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: using dbms_alert to manage multiple processes Will all processes signal one named alert or a process specific alert? If it is one alert then keep counting as you receive

RE: Finding dedicated server processes associated with a specified us

= '_addr' and hash_value = _hash order by piece; undef sid spool off exit Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, August 13, 2003 3:59 PM To: Multiple recipients of list ORACLE-L us How do you determine which dedicated server processes

Finding dedicated server processes associated with a specified us

How do you determine which dedicated server processes are associated with a given user session? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Finding dedicated server processes associated with a specifie

If you are on Unix here is a simple query that shows them all. Edit as needed to show a particular user. I think the user process ID is for whatever box the user is on -- not necessarily the local box. set pagesize 1000 col username format a15 col osuser format a15 select s.username,

Re: parallel processes

while rebuilding indexes i gave parrallel 2 . But I see there are four ora_p00 processes . ??? -ak but you have probably 2 CPU-us mac -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mac INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

parallel processes

while rebuilding indexes i gave parrallel 2 . But I see there are four ora_p00 processes . ??? -ak

RE: parallel processes

: Wednesday, July 23, 2003 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: parallel processes while rebuilding indexes i gave parrallel 2 . But I see there are four ora_p00 processes . ??? -ak

RE: parallel processes

2 producers 2 consumers -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 8:44 PMTo: Multiple recipients of list ORACLE-LSubject: parallel processes while rebuilding indexes i gave parrallel 2 . But I see there are four ora_p00

Re: parallel processes

]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: parallel processes

Re: beq processes preventing shutdown

environment. The shutdown hangs up, and he can see processes like the following: oraclePROD (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) From searching around, I've been able to ascertain that these beq processes are probably created by the listener in response to connect requests

32-bit AIX 5.1 Oracle 8.1.7.4 - Tons of aioserver processes?

max processes = 3000 (now, started at 800) min aioservers = 10 max aioservers = 400 When attempting to do anything in Oracle, particularly attempting to run a script to create a database or any object creation, hundreds of aioserver processes owned by oracle are started. If you issue ps -aux

RE: 32-bit AIX 5.1 Oracle 8.1.7.4 - Tons of aioserver processes?

After we raised the max processes to 3000 we quit getting the fork function failed error which was our original problem. Right now, things are working ok but since I've never seen this behavior before on 5 other similar installs, I don't know how to predict where the limit is. In other words

Difference between processes and sessions

We got a error on one of our production systems that the maximum number of processes were exceeded. I've been trying to track this down but it makes no sense. There are 15 sessions in v$session and 49 processes in v$process (just 1 under the limit of 50, for now). I checked our other systems

RE: Difference between processes and sessions - SOLVED!

]' We got a error on one of our production systems that the maximum number of processes were exceeded. I've been trying to track this down but it makes no sense. There are 15 sessions in v$session and 49 processes in v$process (just 1 under the limit of 50, for now). I checked our other systems

Re: Difference between processes and sessions - SOLVED!

it self until it ran out of processes. In OCI8 the attach and connect function are seperate calls and can cause these problems . Anjo. DENNIS WILLIAMS wrote: FYI - we found the culprit. A Tomcat app server had an old Oracle password, so was apparently retrying an unsuccessful login

Re: First version with multiple archiver processes?

Kirti From version 7.x you can manually start multiple archive processes by using the archieve log start to destnation and the added processes wil die when there is no more redofiles to archive, but for permanent having multiple processes the answer is 8.1.3 :-) Deshpande, Kirti wrote: I can

Re: First version with multiple archiver processes?

Kirti In v.7 the archiver is called ARCH. If 'archive log start to xxx' starts another, what is it called? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 5 Feb 2003, Peter Gram wrote: Kirti From version 7.x you can manually start multiple archive processes by using

Re: First version with multiple archiver processes?

://www.speakeasy.net/~jwilton On Wed, 5 Feb 2003, Peter Gram wrote: Kirti From version 7.x you can manually start multiple archive processes by using the archieve log start to destnation and the added processes wil die when there is no more redofiles to archive, but for permanent having multiple

RE: First version with multiple archiver processes?

ARCH. If 'archive log start to xxx' starts another, what is it called? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 5 Feb 2003, Peter Gram wrote: Kirti From version 7.x you can manually start multiple archive processes by using the archieve log start to destnation

First version with multiple archiver processes?

What was the first version of Oracle with the ability to start multiple archiver processes? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services

RE: First version with multiple archiver processes?

I can think of 8.1.3. - Kirti -Original Message- Sent: Wednesday, February 05, 2003 6:04 PM To: Multiple recipients of list ORACLE-L What was the first version of Oracle with the ability to start multiple archiver processes? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton

Strange Problem: ORA-00020 Max Processes

lace the bad driver with the recommended one. Restarted NT and all was well. On Monday, I came into work and saw that we were getting max processes (ORA-00020). It has never happened before. Since I couldn't get in, other than internal and you can't select from the V$ views,I did a shutdown immediate an

Strange processes showing up

I just notice these ora_ixxx_sid processes on my server. Does anyone have an idea what they are? They didn't used to be there. oracle 18249 1 0 16:07:35 ?0:00 ora_i106_cdwprd oracle 10664 1 0 15:36:38 ?0:00 ora_snp3_cdwprd oracle 10650 1 0 15:36:37

Re: Strange processes showing up

Hi, These are dbwr_io_slaves processes. Search in 'Metalink' (or Manuals) to learn more about these processes.Regards, Quamrul From: "Smith, Ron L." <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Strang

Re: Strange processes showing up

processes on my server. Does anyone have an idea what they are? They didn't used to be there. oracle 18249 1 0 16:07:35 ?0:00 ora_i106_cdwprd oracle 10664 1 0 15:36:38 ?0:00 ora_snp3_cdwprd oracle 10650 1 0 15:36:37 ?0:00 ora_ckpt_cdwprd oracle 10786

Re: Strange processes showing up

a BSTAT/ESTAT or STATSPACK report and run it through the full-fledged YAPP processor on www.oraperf.com; it'll say for sure... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 27, 2003 3:33 PM I just notice these ora_ixxx_sid processes

PMON seems to not close sessions in a timely manner eg Max processes(50) reached

I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner, leaving what look to be ghost process. If a few users hit the same app the processes go to = 50 then I

Re: PMON seems to not close sessions in a timely manner eg Max processes(50) reached

Why not just increase max processes? Jared On Tuesday 24 December 2002 05:53, Bob Metelsky wrote: I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner

Re: Oracle shadow processes run amok after system clock changed

No, this was the middle of the afternoon. Each of those runaway processes were at one time associated with various users in the database doing various tasks, mostly selects. No user complained, so I assume they got detached from their shadow and maybe thought they were logged out? I

Oracle shadow processes run amok after system clock changed

could log in again. We then noticed 72 (of ~500) oracle processes in the run state, all evenly collecting CPU time, although database performance was good. Some of these 72 processes were orphans and had no database process. Most had been doing simple selects, but not a single one was actually

Re: Oracle shadow processes run amok after system clock changed

not change even though users could log in again. We then noticed 72 (of ~500) oracle processes in the run state, all evenly collecting CPU time, although database performance was good. Some of these 72 processes were orphans and had no database process. Most had been doing simple selects

RE: Do user processes apply against shmmax limit?

want to set shmmax as high as you realistically can -- to reduce the NUMBER of segments you need to allocate for shared memory. Your sysadmin also mentions turning on priority paging to give the user processes access to the memory before the file cache (aka buffer cache). Again I'm not sure about

RE: Do user processes apply against shmmax limit?

processes access to the memory before the file cache (aka buffer cache). Again I'm not sure about Solaris, but AIX and HP-UX both ship with their buffer cache set to something like 10% - 20% of total memory by default, which is a pretty good guess for a generic system when the vendor has

Re: Do user processes apply against shmmax limit?

also mentions turning on priority paging to give the user processes access to the memory before the file cache (aka buffer cache). Again I'm not sure about Solaris, but AIX and HP-UX both ship with their buffer cache set to something like 10% - 20% of total memory by default, which is a pretty

Re: Do user processes apply against shmmax limit?

... and we butt headlong into another fine myth, that is that the SGA must fit into one segment. On Sunday 24 November 2002 15:53, Richard Ji wrote: if that SGA + user processes shmmax the system will start swapping. That's not true. If your SGA is bigger than shmmax, it just means

RE: Do user processes apply against shmmax limit?

To: Multiple recipients of list ORACLE-L Subject: Do user processes apply against shmmax limit? Hi everyone, I was always under the impression that the only concern with shmmax was that it be large enough for the SGA to fit into it. One of my System Administrators has just told me that the individual

RE: Do user processes apply against shmmax limit?

if that SGA + user processes shmmax the system will start swapping. That's not true. If your SGA is bigger than shmmax, it just means the SGA will be fit into multiple shared memory segments. Doesn't necessary mean the system will start swapping. Is the scan rate going up? Richard

Do user processes apply against shmmax limit?

Hi everyone, I was always under the impression that the only concern with shmmax was that it be large enough for the SGA to fit into it. One of my System Administrators has just told me that the individual user processes (i.e., the PGA since we're not using multi-threaded server) get added

Re: Do user processes apply against shmmax limit?

PROTECTED] Sent: Saturday, November 23, 2002 11:48 AM Hi everyone, I was always under the impression that the only concern with shmmax was that it be large enough for the SGA to fit into it. One of my System Administrators has just told me that the individual user processes (i.e., the PGA

Re: Do user processes apply against shmmax limit?

was that it be large enough for the SGA to fit into it. One of my System Administrators has just told me that the individual user processes (i.e., the PGA since we're not using multi-threaded server) get added to the SGA and if that SGA + user processes shmmax the system will start swapping

Re: Do user processes apply against shmmax limit?

that the individual user processes (i.e., the PGA since we're not using multi-threaded server) get added to the SGA and if that SGA + user processes shmmax the system will start swapping. I haven't found anything to specifically address this issue on Metalink so I though I'd throw it open. We've

RE: Do user processes apply against shmmax limit?

** -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Subject: Do user processes apply against shmmax limit? Hi everyone, I was always under the impression that the only concern with shmmax

FW: kproc processes owned by Oracle on AIX

All, I have shutdown my database(but not the listener). I notice that I have a number of kproc processes owned by oracle. Why? John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn

RE: kproc processes owned by Oracle on AIX

Are you using AIO? Then these may be AIX processes that are started by the kernel (kproc - kernel procs) on behalf of 'oracle'. Are you sure that they are owned by oracle. If so, can you shut the server down? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see

Unkillable Background process SHUTDOWN ABORT LEAVES UNKILLABLE PROCESSES

Hi all, When I do shutdown abort my LGWR and CKPT still around and also kill -9 cannot get rid of them anyone know why ? because of this my cluster fail to failover Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED]

how many async_io processes to invoke? - AIX ora 7.3

list, to give async_io a boost, i increased the minimum server parameter in AIX to 15 (from 2) .. now while doing a ps -Al i see only 4 kproc which are busy !! rest has ZERO excution time infront of them.. !! how do i determine the optimum number of minimum async_io servers for a db which

Re: Shutdown and startup processes

Hello Willie We are using startup trigger that calls a Java function that sends an MQSeries message to the mainframe. Maybe you could use a Java function that will close and open the scheduler. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

killing nohup processes

Hello all, solaris: 2.8 there is a strange problem with nohup compress in unix. I am trying to compress all my export dmp files with nohup compress *.dmp But later I realized and not to do that and grep the process and killed it. But the system is skipping compression of the current file

Shutdown and startup processes

Gurus, I need to implement a process to startup/shutdown a PeopleSoft Unix batch scheduler job whenever the Oracle instance is shutdown or started back up. Does anyone know of a way to tie this process to an Oracle Instance to get invoked at shutdown/startup time? Willie Townsend Alverno

RE: Shutdown and startup processes

Willie - At our site we have a Unix startup and shutdown script tied into the system startup/shutdown scripts. You could use the same mechanism.   Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, September 12, 2002 1:13

Re: Shutdown and startup processes

Townsend Willie wrote: Gurus, I need to implement a process to startup/shutdown a PeopleSoft Unix batch scheduler job whenever the Oracle instance is shutdown or started back up. Does anyone know of a way to tie this process to an Oracle Instance to get invoked at shutdown/startup time?

RE: Shutdown and startup processes

Thanks Dennis! I may have to do it as you suggested. I was hoping there was a way to automatically shutdown/startup Unix script if I shutdown Oracle via srvmgrl command line prompt. For instance, if I executed 'shutdown immediate', this would invoke command behind the scene to stop the

RE: Shutdown and startup processes

Thanks Stephane! As you alluded to, ideally, I want it to work automatically even when I do manual shutdown/startup via svrmgrl etc. I will explore your suggestion of triggers/external function etc. Willie -Original Message- Sent: Thursday, September 12, 2002 2:44 PM To: Multiple

Re: init.ora processes ??

Another thing to consider is this: From OraPerf: The LGWR needs to scan all processes to find each process that is waiting for the commit to be written. So when you have an excess of process LGWR works harder. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list

init.ora processes ??

All, What is the impact of processes init.ora parameter other than restricting number of user sessions ? I know it needs more memory (like stack size + sort area size + etc. ) whenever it gets new connection. My question is: Is there any additional resource (does it take more memory? ) usage

RE: init.ora processes ??

For each process 'reserved' by oracle, there is a small amount of space allocated in the SGA and a semaphore is reserved at the O/S level (assuming UNIX). A lesser number of processes will allocate a slightly smaller amount of SGA and fewer semaphores. Until a session is started, no other memory

Re: init.ora processes ??

the larger the number of processes in the init.ora, the larger the number of semaphores you need on most Unix systems. Not all, I *think* from reading the list that AIX doesn't use semaphores (I've only worked on HP-UX and SUN, both of which use semaphores) If the processes parameter is set so

RE: init.ora processes ??

How about with Microsoft Windows NT ? --- Fink, Dan [EMAIL PROTECTED] wrote: For each process 'reserved' by oracle, there is a small amount of space allocated in the SGA and a semaphore is reserved at the O/S level (assuming UNIX). A lesser number of processes will allocate a slightly

Re: ORA-20 - Maximum Processes Exceeded

I found the solution, and it's a bit obscure. The problem is detailed in MetaLink Note 152868.1 Problem Description --- You have seen in the v$process view that the number of processes without a session are growing up one every 5 minutes, until the processes limit

ORA-20 - Maximum Processes Exceeded

of processes by logging in with one of it's utilities until there were no processes left. This morning something a little different happened. The ORA-20 popped up again, but this time, there were not corresponding entries in v$session. Joining v$session and v$process returned only 31 rows, while

Re: Size of Oracle server processes

? Hope this helps... -Tim - Original Message - From: Jos Someone To: Multiple recipients of list ORACLE-L Sent: Monday, July 15, 2002 1:18 PM Subject: Size of Oracle server processes I have a question to ask regarding Oracle server process (oracleSID) size. We have

Re: Size of Oracle server processes

for the increased size? Hope this helps... -Tim - Original Message - From: Jos Someone To: Multiple recipients of list ORACLE-L Sent: Monday, July 15, 2002 1:18 PM Subject: Size of Oracle server processes I have a question to ask regarding Oracle server

Size of Oracle server processes

I have a question to ask regarding Oracle server process (oracleSID) size. We have just installed Oracle Apps 11i, while monitoring the system using glance, I notice something strange, the oracle server processes - process which has a name oracleSID has a very big RSS size in glance

Re: Size of Oracle server processes

al Message - From: Jos Someone To: Multiple recipients of list ORACLE-L Sent: Monday, July 15, 2002 1:18 PM Subject: Size of Oracle server processes I have a question to ask regarding Oracle server process (oracleSID) size. We have just installed Oracle Apps

RE: Unidentified sessions brought us to maximum processes - more

of processes (had never happened before). When I checked in Enterprise Manager and v$sessions I saw dozens of sessions with no username or osusername attached. I was able to resolve the issue with a shutdown abort and restart (after spending 15 minutes to get the requisite approvals). There were

RE: Database Hung with all processes waiting on locks

ORACLE-L Subject: Database Hung with all processes waiting on locks We were running 11i Autoupgrade (from 10.7) on HP-UX 8.1.7.3 64-bit Oracle. Yesterday the database hung with every session having a WAITING status in v$session_wait. The MTS processes were 'rdbms ipc message', several

RE: Database Hung with all processes waiting on locks

Mary, We don't plan to use MTS for 11i just during the AUTOUPGRADE process from 10.7 to 11i. We found that it runs 20% faster with MTS because the workers logon/off thousands of times. And yes MTS is configured with with large pool. Thanks for the feedback. Did Oracle Support

Database Hung with all processes waiting on locks

We were running 11i Autoupgrade (from 10.7) on HP-UX 8.1.7.3 64-bit Oracle. Yesterday the database hung with every session having a WAITING status in v$session_wait. The MTS processes were 'rdbms ipc message', several workers were waiting on 'row cache lock' and 'library cache pin

RE: ORA-00020: maximum number of processes (100) exceeded

Hi Ron, what o/s are you on? -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 9:28 AM To: Multiple recipients of list ORACLE-L Subject: ORA-00020: maximum number of processes (100) exceeded I need to increase max processes but I

ORA-00020: maximum number of processes (100) exceeded

I need to increase max processes but I can't log in. Can anyone tell me how to get into the database when I get ORA-00020 errors? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: ORA-00020: maximum number of processes (100) exceeded

even with max processes, you should be able to log in via svrmgrl and connect internal that will let you do the shutdown immediate or shutdown abort you need to to restart with more processes Edit the init.ora first, then do shutdown and restart or you can do a startup force, which will do

Processes hang from remote calls

I am running batch scripts that access remote database through database links. I am getting a lot of processes that don't get cleared up. This is probably due to failed connections or a database down, etc... I have exits in the SQL scripts and in the batch scripts. How can I control this so

RE: ORA-00020: maximum number of processes (100) exceeded

-L Subject: ORA-00020: maximum number of processes (100) exceeded I need to increase max processes but I can't log in. Can anyone tell me how to get into the database when I get ORA-00020 errors? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron

RE: ORA-00020: maximum number of processes (100) exceeded

Well, I believe changing the number of processes involves bouncing the db anyway. IF you can't get in via svrmgrl, I've just killed client processes (if your appserver isn't spinning out of control) until I could get in. Otherwise I've had to take the drastic measure of killing smon or pmon

RE: ORA-00020: maximum number of processes (100) exceeded

Reboot. The answer to all questions regarding Windows :-) -Original Message- Sent: Monday, April 01, 2002 9:20 AM To: Multiple recipients of list ORACLE-L Well, I believe changing the number of processes involves bouncing the db anyway. IF you can't get in via svrmgrl, I've just

RE: Difference b/w SESSIONS and PROCESSES

Title: Difference b/w SESSIONS and PROCESSES Search Metalink for Note:165659.1 Subject:DIFFERENCES BETWEEN PROCESSES,SESSIONS AND CONNECTIONS - Kirti -Original Message-From: Arslan Dar [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 13, 2002 11:48 PMTo: Multiple

RE: Difference b/w SESSIONS and PROCESSES

Title: Difference b/w SESSIONS and PROCESSES I believe that the best answers are given on technet.oracle.com-documentation. They formulated the answer to your questions much better then I ever could. -Original Message-From: Arslan Dar [mailto:[EMAIL PROTECTED]]Sent: Thursday

Difference b/w SESSIONS and PROCESSES

Title: Difference b/w SESSIONS and PROCESSES What is the main difference in SESSIONS and PROCESSES initialization parameters in Init File. Detailed explanation needed. If I increase the value of any of those two, while my actual users are same, does that affect the memory taken by oracle

Question on runaway server processes

I do not have any idea what this mean can we all please let me know how to answer this question How to prevent runaway server processes appearing when user kills his processes? Thanks in advance Praveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praveen

How Many Processes are Performing Simultaneous DML on A Table?

Is there any way to tell this after the fact; i.e., what was the maximum number of processes performing DML on a specific table on such and such a date? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: background processes

Title: RE: background processes ora_s000_ora8 ora_s001_ora8 ora_s002_ora8 ORacle MTS (multithreaded server) server processes ora_p000_ora8 ora_p001_ora8 Oracle parallel query processes Matt Adams - GE Appliances - [EMAIL PROTECTED] Contrary to popular opinion, Unix is user

background processes

Hi lists, Can anybody guess the following background processes? ora_s000_ora8 ora_s001_ora8 ora_s002_ora8 ora_p000_ora8 ora_p001_ora8 ora8 is instance. Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane

  1   2   >