So sorry. Nice naming conventions. I imagined you inherited this from someone who had know idea what they were doing and created the databases out-of-the-box. Oh yeah - because you don't need a DBA. I inherited databases setup by a developer. I found out that on the windows environment he was not bringing down the databases before schedule a cold backup. It took me about an hour of being on the job. He stopped calling himself a developer/DBA soon after that.=20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Oracle Sent: Tuesday, May 10, 2005 5:25 AM To: mcdonald.connor@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: Re: Does this happen to you at work? and most of database name under my care is either orcl or prod ----- Original Message ----- From: "Connor McDonald" <mcdonald.connor@xxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, May 10, 2005 5:02 PM Subject: Re: Does this happen to you at work? > $ ps -ef | grep pmon | wc -l > 130 > > Part of this organisation's policy of one application per database... > > Sigh... > > On 5/10/05, mhthomas <qnxodba@xxxxxxxxx> wrote: > > Quote: > > "We just don't know why the server with 25 databases is slow. But, I'm > > a firm believer in the silver bullet methodology. If we just start > > shutting down production databases one-by-one we'll eventually find > > the one that's causing the problem". > >=3D20 > > --=3D20 > Connor McDonald > =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D =3D3D=3D > =3D3D=3D3D > email: connor_mcdonald@xxxxxxxxx > web: http://www.oracledba.co.uk > > "Semper in excremento, sole profundum qui variat" > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l BEGIN-ANTISPAM-VOTING-LINKS ------------------------------------------------------ Teach CanIt if this mail (ID 31923706) is spam: Spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D31923706&m=3Decfc= d9cae 4e2 Not spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D31923706&m=3Decfc= d9cae 4e2 Forget vote: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D31923706&m=3Decfc= d9cae 4e2 ------------------------------------------------------ END-ANTISPAM-VOTING-LINKS -- //www.freelists.org/webpage/oracle-l