Re: Segments by Logical Reads-AWR

It is a temporary tablespace (they are very using a clean naming standard with *_T* to signal that it is a temporary tablespace)

Best regards

Mohamed Houri

2014-09-18 15:39 GMT+02:00 Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>:

>
>
> Is the tablespace whose name you've obfuscated a temporary tablespace or
> a permanent tablespace ?
>
>
>
>
> Regards
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
> _at_jloracle
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on
> behalf of Mohamed Houri [mohamed.houri_at_gmail.com]
> *Sent:* 18 September 2014 14:21
> *To:* ORACLE-L
> *Subject:* Segments by Logical Reads-AWR
>
> Dear List,
>
>
> Can someone tell me what could be this TRANSIENT object name that
> appears in the *Segments by Logical Reads* and *Segments by DB Blocks
> Changes* parts of a 60 minutes AWR report?
>
>
> *Segments by Logical Reads*
>
> - Total Logical Reads: 212,371,958
> - Captured Segments account for 76.3% of Total
>
> *Owner*
>
> *Tablespace Name*
>
> *Object Name*
>
> *Subobject Name*
>
> *Obj. Type*
>
> *Logical Reads*
>
> *%Total*
>
> ** MISSING **
>
> XXX_T
>
> ** TRANSIENT: 4228608
>
> ** MISSING **
>
> UNDEFINED
>
> 19,557,632
>
> 9.21
>
>
>
> *Segments by DB Blocks Changes*
>
> - % of Capture shows % of DB Block Changes for each top segment
> compared
> - with total DB Block Changes for all segments captured by the Snapshot
>
> *Owner*
>
> *Tablespace Name*
>
> *Object Name*
>
> *Subobject Name*
>
> *Obj. Type*
>
> *DB Block Changes*
>
> *% of Capture*
>
> ** MISSING **
>
> XXX_T
>
> ** TRANSIENT: 4228608
>
> ** MISSING **
>
> UNDEFINED
>
> 5,966,256
>
> 13.63
>
>
>
> There is a note in MyOracle support which seems close to this subject but
> does not fit exactly with what I have been told by the developers about
> their application.
>
>
> Bug 8811401 <https://support.oracle.com/rs?type=bug&id=8811401> (Note
> 8811401.8 <https://support.oracle.com/rs?type=doc&id=8811401.8>)
>
>
> Thanks in advance
>
> --
>
> Houri Mohamed
>
> Oracle DBA-Developer-Performance & Tuning
>
> Member of Oraworld-team <http://www.oraworld-team.com/>
>
> Visit My - Blog <http://www.hourim.wordpress.com/>
>
> Let's Connect - <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
> Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*
>
> My Twitter <https://twitter.com/MohamedHouri> - MohamedHouri
> <https://twitter.com/MohamedHouri>
>
>

-- 

Houri Mohamed

Oracle DBA-Developer-Performance & Tuning

Member of Oraworld-team <http://www.oraworld-team.com/>

Visit My         - Blog <http://www.hourim.wordpress.com/>

Let's Connect -
<http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*

My Twitter <https://twitter.com/MohamedHouri>      - MohamedHouri
<https://twitter.com/MohamedHouri>

--
http://www.freelists.org/webpage/oracle-l