No, and correct me if I'm wrong, but it means that most (99%) of what you
are ASKING for is in the buffer cache. BIG Difference. If he never queried
the objects in the tablespace which is comprised of the datafile in
question, then NONE of that file is in the buffer cache. (you could still
have 99% cache hit ratio by querying other objects which are located
elsewhere.
In this case, you are SOL trying to do physical reads on that datafile...
> -----Original Message-----
> From: Christopher Spence [mailto:cspence_at_FuelSpot.com]
> Sent: Friday, January 12, 2001 12:26 PM
> To: 'Glenn Travis'; oracledba_at_QuickDoc.co.uk
> Subject: RE: delete tablespace file
>
>
> Because it means most of the file is loaded in the buffer cache, hense NO
> PHYSICAL READS.
>
> "Please pay MS now to complete rebooting your PC."
>
> Christopher R. Spence
> OCP Raptor MCSE MCP A+ CNA
> Database Administrator
> Fuel Spot
>
> 73 Princeton Road
> North Chelmsford, MA 01863
> (978)-322-5744
>
>
> -----Original Message-----
> From: Glenn Travis [mailto:Glenn.Travis_at_wcom.com]
> Sent: Friday, January 12, 2001 11:02 AM
> To: oracledba_at_QuickDoc.co.uk
> Subject: RE: delete tablespace file
>
>
> What does that have to do with buffer cache? Isn't he still accessing the
> datafile?
>
> > -----Original Message-----
> > From: Christopher Spence [mailto:cspence_at_FuelSpot.com]
> > Sent: Wednesday, January 10, 2001 4:54 PM
> > To: 'Page, Bruce'; oracledba_at_QuickDoc.co.uk
> > Subject: RE: delete tablespace file
> >
> >
> > wouldn't be the first time that was done :)
> > buffer cache hit ratio of 99% is a great thing.
> >
> > "Please pay MS now to complete rebooting your PC."
> >
> > Christopher R. Spence
> > OCP Raptor MCSE MCP A+ CNA
> > Database Administrator
> > Fuel Spot
> >
> > 73 Princeton Road
> > North Chelmsford, MA 01863
> > (978)-322-5744
> >
> >
> > -----Original Message-----
> > From: Page, Bruce [mailto:Bruce.Page_at_BellSouth.com]
> > Sent: Wednesday, January 10, 2001 4:08 PM
> > To: oracledba_at_QuickDoc.co.uk
> > Subject: RE: delete tablespace file
> >
> >
> > The space is not really freed up until all the processes using it
> > are down.
> >
> > I know a guy that deleted one of his production data files. When he
> > realized what he had done, he closed the system to the users,
> exported the
> > whole database, and recovered from the export.
> >
> > > -----Original Message-----
> > > From: mike gerry [mailto:scuffdba_at_hotmail.com]
> > > Sent: Wednesday, January 10, 2001 12:58 PM
> > > To: oracledba_at_QuickDoc.co.uk
> > > Subject: delete tablespace file
> > >
> > >
> > > I have a question about something I ran across while testing.
> > >
> > > I've created a tablespace and file, created table within that
> > > tablespace.
> > > Now I perform maint on that table and commit.
> > > If I delete the file for that tablespace, I can continue to
Received on Tue Jan 16 2001 - 09:28:43 CST
