| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Determine if column is never used?
On Wed, 27 Oct 1999 17:15:50 GMT, chrisoc_at_ans.net wrote:
>
>
>Is there a way to see the stats on column access within a table?
>The goal would be to either drop columns entirely or to build
>new tables that could be joined if the need exists but the
>frequency is rare.
>
>I am dealing with a legacy database that is highly unnormalized and
>a few tables in it have literally hundreds of columns.
>
>Going through megs of app source (ughhh) would still miss the adhoc
>queries so I want evidence that some data is indeed "dead weight",
>if I can get at the numbers.
I don't know of any efficient way to determine this. The most simple
method I could think of would be to turn SQL tracing on and after a
sufficient period of time analyze the result of a tkprof output.
However I don't know what should you do with the selects of form
"SELECT * FROM...." - you can't possibly know if particular column was
really needed in this select, especially if it is issued from the
PL/SQL.
>Chris O'Connor
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)
 |
 |