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
"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.
>
Er.... so, how much free space have you got then? 2K, 2Mb, 200Mb, 2Gb, 200Tb???? And are you inserting 1 row a day, or 1 million????It's a bit difficult to advise given the paucity of information you provide.
If you are not entirely sure what you are doing, investigate the 'autoextend' option for your data files. That will allow all data files to grow in size whenever needed. Of course, performance on the database suffers as the autoextension takes place, but at least your database won't keel over entirely. You can allow autoextensible files to take over the whole hard disk, or you can artificially restrict them with a 'maxsize' clause.
Naturally, good DBA technique rather suggests that you proactively monitor your file growth, and respond appropriately, and autoextend is thus not a technique I'd normally recommend. But as quick fixes go, it will do the job.
Regards
HJR
> 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:33:10 CDT