Re: Accessed Columns and Tables

From: tmgn <tmgn_at_excite.com>
Date: Tue, 29 Jun 1999 15:04:36 -0400
Message-ID: <377918C4.B5AC7B@excite.com>

There are lots of ORacle Tuning & Sql Analyze tools available. Some of them are

1.Oracle Tuning & Diagnostic Packs with OEM
2.Quest Software's Sql Tuner , Instance Monitor
3. Tools from Platinum Technologies
4.Toad   etc etc...

You can try issuing adhoc queries against V$access , V$db_object_cache ,V$SQL , V$sQLTEXT etc but these may long long time depending upon the Transaction load, Query itself...

-Thiru

anthonywmhui_at_hotmail.com wrote:

> A had thousands of SQL that access hundreds of tables in my data
> warehouse. How can I know which column or table is being accessed. Any
> tool available to analyze the SQL and produre this kind of
> information? Or does ORACLE provide any tool/way to collect this kind
> of information? Any other Suggestions?
>
> I am in need of your help!
>
> Thanks a lot
>
> Anthony Hui
> Database Design Analyst
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Jun 29 1999 - 14:04:36 CDT