Re: Missing ext_to_obj

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Fri, 08 Jun 2007 01:29:05 -0000
Message-ID: <1181266145.659824.140780@p77g2000hsh.googlegroups.com>

On Jun 7, 7:47 pm, "jms.n..._at_gmail.com" <jms.n..._at_gmail.com> wrote:

> 1) Why is ext_to_obj_view not created as part of a standard install ?
> 2) Can I run catclust.sql on a non-clustered installation ... will it
> break anything ?

No clue :)

However, you can look at v$system_event, which will you tell the p1 and p2 parameters. IIRC, in 9.x, p1 was the datafile# and p2 was the block in that file.

If that is the case, you can run the following, which may take awhile depending on how big the datafile is...

select segment_type||'.'||owner||'.'||segment_name from dba_extents where file_id=<p1> and <p2> between block_id + blocks;

You could also look for high buffer_gets statements in v$sql, as that is probably the culprit statement.

HTH, Steve Received on Thu Jun 07 2007 - 20:29:05 CDT

Re: Missing ext_to_obj_view