Re: Ghost Data
Date: Tue, 30 Jun 2009 17:12:05 -0600
Message-ID: <4A4A9BC5.5050304_at_lanl.gov>
Brandon,
Please explain "it had a bunch of data from other database tables in it". Is this other data actual "application" data, not just data dictionary data?
Julio.
Allen, Brandon wrote:
>
> I'm starting a new thread on this specific topic to avoid high jacking
> the other one. Reading about this "ghost data" reminds me of a
> surprising discovery I made a few months ago but had forgotten about
> until today.
>
>
>
> I created a brand new tablespace with a new datafile, created one
> table in the new tablespace and inserted one row. When I ran
> "strings" on the datafile, I only saw the instance name and tablespace
> name -- so far, so good. Then I forced a checkpoint to write the data
> out to the file and was surprised to find that when I looked at the
> datafile with "strings" again, it had a bunch of data from other
> database tables in it.
>
>
>
> Is this normal, known behavior? Does Oracle just copy data from other
> blocks of the database into the new file as buffer space to fill it
> up? I duplicated this on 8.1.7.3 and 10.2.0.4.
>
>
>
> Thanks,
>
> Brandon
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Michael Wehrle
> *Sent:* Tuesday, June 30, 2009 1:45 PM
> *To:* Mathias Magnusson; oracle-l
> *Subject:* Re: Quickest Way To Recreate a Database
>
>
>
> Mathias, Oracle explains what this ghost data is here...
>
> http://www.oracle.com/technology/deploy/security/database-security/transparent-data-encryption/tde_faq.html#A15032
>
>
>
> ------------------------------------------------------------------------
> Privileged/Confidential Information may be contained in this message
> or attachments hereto. Please advise immediately if you or your
> employer do not consent to Internet email for messages of this kind.
> Opinions, conclusions and other information in this message that do
> not relate to the official business of this company shall be
> understood as neither given nor endorsed by it.
-- ***************************************** Julio Aguilar-Chang Geophysics Group, EES-17 Los Alamos National Laboratory jachang_at_lanl.gov (505) 667-1004 - work (505) 665-3687 - fax ***************************************** -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 30 2009 - 18:12:05 CDT