Re: shared memory identification

There was a pretty big thread on lazydba.com recently on identifying shared memory segments, had something to do with looking at the timestamp on the segment and the startup time of the database. They also mentioned a oracle utility that you can use to get some of this info, search for info on this within the last two weeks for the details at lazydba.com

• Ethan

In article <954j26$d8a$1_at_nnrp1.deja.com>,   ian_goldstein_at_my-deja.com wrote:
> greetings all,
>
> I am running a Solaris 2.7 operating environment. My dba had a
 problem
> in which he had 2 oracle (8.1.6) instances running. One instance died
> but the shared memory segment was never removed. When I view the
> shared memory through ipcs the "CPID" field is that of a non-existant
> process. As it turns out the SVRMGRL forks off a process that starts
> the oracle instance and then exits, so now I have no way to determine
> which shared memory segment belongs to the remaining Oracle Instance.
>
> The only way I thought to procede in the future was to set up a
> separate user id for each oracle instance.
>
> Does anybody have any other suggestions.
>
> Thanks in advance,
> Ian
>
> Sent via Deja.com
> http://www.deja.com/
>

--


Sent via Deja.com
http://www.deja.com/