Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: what all physical space allocated to my DB's
As you don't provide *any* clue to your configuration you won't get sensible replies back.
A general approach to file placement is described in the Oracle DBA Handbook.
Hth,
Sybrand Bakker, Oracle DBA
"Sunil Dua" <sdua_at_solutionsny.com> wrote in message
news:bc03ebd5.0105211350.4623a2de_at_posting.google.com...
> Thanks for the reply... I appreciate the information provided was
> really helpful.. now I could work out what all space my database files
> are taking..my second query was how do i make sure if the space
> allocated is sufficient or do I need to take any preventive steps to
> avoid DB breakdown.
>
> thanks & Regards
> Sunil
>
>
> "Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3B092137.74F7_at_yahoo.com...
> > Sunil Dua wrote:
> > >
> > > I have my Oracle database 8.1.5 installed on a sun solaris machine
> > > some time ago... I just want to find out what all physical space
> > > allocated to the databases installed on it and wether they have
> > > sufficient space to continue ... I'll appreciate if you could guide me
> > > a bit.
> > >
> > > thanks a lot.
> > >
> > > Regards
> > > Sunil
> >
> > select * from v$datafile;
> > select * from v$controlfile;
> > select * from v$logfile;
> > select * from v$tempfile;
> >
> > hth
> > connor
> > --
> > ===========================================
> > Connor McDonald
> > http://www.oracledba.co.uk (mirrored at
> > http://www.oradba.freeserve.co.uk)
> >
> > "Some days you're the pigeon, some days you're the statue"
> >
> > sdua_at_solutionsny.com (Sunil Dua) wrote in message
> > news:<bc03ebd5.0105210936.70ac71f5_at_posting.google.com>...
> > I have my Oracle database 8.1.5 installed on a sun solaris machine
> > some time ago... I just want to find out what all physical space
> > allocated to the databases installed on it and wether they have
> > sufficient space to continue ... I'll appreciate if you could guide me
> > a bit.
> >
> >
> > thanks a lot.
> >
> > Regards
> > Sunil
Received on Mon May 21 2001 - 17:06:41 CDT