Re: Problems with dba_segments view

Problems with dba_segments view
"Kent Sauder" <DKSauder_at_sauder.com> wrote in message news:D577E02F49A4A8498167BA5E41424D4701C844F7_at_expf1.sauder.com... We are having a problem using the dba_segments view. When we attempt to query the view, it locks with "buffer busy waits". If we query v$waitstat, this session is the only one attempting to access the specified file and block. Since dba_segments is based on the view sys_dba_segs, I attempted to query that view. It works normally. Everything else in the database appears to be functioning normally and we aren't receiving any alert.log messages.
So far, I've tracked the problem down to two clauses within the dba_segments view with both making calls to dbms_space_admin.segment_number_blocks. Naturally, this procedure is not documented. Any ideas as to what might be causing this and more importantly, how to fix it?

1 Please don't post in HTML
2 Call Oracle Support. They don't bite.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Fri Aug 03 2001 - 12:35:21 CDT