Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance of data dictionary views
On Fri, 29 May 1998 12:53:30 -0500, "Steven Patenaude"
<stevenp_at_coop.com> wrote:
>I'd like to know what kind of performance people are getting when selecting
>from data dictionary views. Doing a simple count from ALL_TABLES is taking
>about 7 to 8 seconds (without tracing set on and with it being run before so
>it should be cached). This is without anyone else using the database.
>Anyone have ideas?
>
>Description of client:
>SQL*Plus 3.3 on Win95, 10Mbit network, currently light traffic
>
>Description of server:
>Oracle Workgroup 7.3.2 on Novell Netware 4.11, 128 Megs, P133, 5 disks
>
Given the server processor, this sounds normal. If you regularly want
to access some information in all_tables, you should create another
view optimised for your purposes.
Received on Sat May 30 1998 - 05:54:45 CDT