dba_extents view in Oracle 10.2.0.2 2006-06-25 - By Connor McDonald
On 6/24/06, genegurevich@(protected) <
genegurevich@(protected)> wrote:
>
> Everybody:
>
> Has anyone experienced performance issues with dba_extents view (bug
> 5029334)? I was told by Oracle that
> the workaround is to create a new view and use it instead of dba_extents.
> When I asked whether I can just recreate
> the dba_extents view I was told that the results can be far reaching and
> should be fully tested. I interpret that as
> Oracle does not really know what the results are. I wanted to see if
> anyone has hit this bug and what did you do.
>
> thank you
>
> Gene Gurevich
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> Is there any particular urge to be querying DBA_EXTENTS with any great
frequency anyway ?
--
Connor McDonald
===========================
email: connor_mcdonald@(protected)
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
<br><br><div><span class="gmail_quote">On 6/24/06, <b class="gmail_sendername">
<a href="mailto:genegurevich@(protected)">genegurevich
@(protected)</a></b> <<a href="mailto:genegurevich
@(protected)">
genegurevich@(protected)</a>> wrote:</span><blockquote class=
"gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt
0pt 0.8ex; padding-left: 1ex;">Everybody:<br><br>Has anyone experienced
performance issues with dba_extents view (bug
<br>5029334)? I was told by Oracle that<br>the workaround is to create a new
view and use it instead of dba_extents.<br>When I asked whether I can just
recreate<br>the dba_extents view I was told that the results can be far
reaching and
<br>should be fully tested. I interpret that as<br>Oracle does not really know
what the results are. I wanted to see if<br>anyone has hit this bug
and what did you do.<br><br>thank you<br><br>Gene Gurevich<br><br><br>--<br>
<a href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org
/webpage/oracle-l</a><br><br><br></blockquote></div>Is there any particular urge
to be querying DBA_EXTENTS with any great frequency anyway ? <br>
<br clear="all"><br>-- <br>Connor McDonald<br>===========================<br
>email: <a href="mailto:connor_mcdonald@(protected)">connor_mcdonald@(protected)</a>
<br>web: <a href="http://www.oracledba.co.uk">http://www.oracledba
.co.uk
</a><br><br>"Semper in excremento, sole profundum qui variat"
|
|
