Re: How to tell which Oracle process goes with which instance on a Windows box

"john jaikovski" <skidog8_at_yahoo.com> wrote in message news:73639d60.0204251140.48a60b76_at_posting.google.com...
> Hi
> Wayne
>
> i am in the exact predicament as you. i have been thrown into a
> position of supporting multple oracle databases on one machine. i
> have run out of space and patience with the programmers asking for
> more equipment when wecan add additional database to MSSQL , ORacle
> has to be able to do the same. so i was wondering if you have a
> document that has instructions as how to do this, since the original
> are no longer around here, or point me towards a link that nay have
> this.
>
> thanks
>
> ski!

The spid column in v$process contains the thread id of the associated thread (Oracle is implemented as a multi-threaded service, using taskman, processes tab would show you only 1 single process per instance) Unfortunately when you run perfmon you don't get the thread id's, the thread id associated is an index number only. I will be fighting this one tomorrow. (Some people only acquainted with sqlserver developed a website against Oracle, and of course it provides numerous problems. The top cpu rate seems to be 12% and even in that case customer complains about performance. My firm is only administrating this mess, we didn't develop it) Have you ever tried explaining to your developers a database in mssql equates a schema in Oracle. They *really* need to explain why they run multiple databases, and if they can't explain they should either learn Oracle or quit their job.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address