Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: speed of dba_tables vs all_tables
Well if you run the query against all_tables first, and then run it against dba_tables the second time, it is going to run faster because the information is in the cache and doesn't require an I/O. Try clearing the cache first and then flipping the order around and see if you get the opposite result.
"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:15:11 CST