"Patrick Mackeown" <patrick_nospam__at_patmac.demon.co.uk> wrote in message news:<1020321629.6363.0.nnrp-10.c2def390_at_news.demon.co.uk>...
> Hi Folks,
>
> We use oracle 8.0.5 on HPUX 11 and run peoplesoft financials. Anyway, on
> rare occasions
> two things happen. The temporary files on oracle partitions fill the disks
> up and on even rarer
> occasions all semephores which could be created have been created and new
> applications
> fail. I believe we use ipcs to view the semephores and shared memory
> allocation and ipcsrm
> to remove undesired semephores, but I've been told that there's no surefire
> way to tell which
> semephores to ipcsrm, "You just dig around, guess which ones to delete" I've
> been told. I'm
> not to happy with this explanation! What should I do next? And is there a
> method of scripting
> the removal of these damned temporary files, which are such a pain in the
> neck?
>
> Thanks for any tips and tricks!
>
> Patrick.
I think you are symptom fighting if you start to remove semaphores.
You must have more serious problems, like you are running dedicated
server with more than 50 users, where you should run MTS, or you don't
have dead connection detection enabled.
--
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Thu May 02 2002 - 05:46:31 CDT
