Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: speed of dba_tables vs all_tables
It may also be that Oracle has to determine what rights you have to the individual tables w/ all_tables.
"Terry Diederich" <terry_at_terrydiederich.com> wrote in message
news:3a17d4ad$1_4_at_news.datacruz.com...
> Hello,
>
> It is taking longer to return a result set from all_tables compared to
> dba_tables.
>
> This query gives me a result set (using sqlplus) in just a second or two:
>
> select * from dba_tables
>
> This query gives me a result set (again using sqlplus with the same
> username/password/server as before) in 15 to 20 seconds.
>
> select * from all_tables
>
> Is this normal? Is something not set up correctly?
>
> Thanks
> Terry Diederich
>
>
>
>
Received on Thu Nov 23 2000 - 17:16:33 CST