Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Determine if column is never used?

Re: Determine if column is never used?

From: David Scott <dlscott_at_mindspring.com>
Date: Thu, 28 Oct 1999 20:41:09 -0400
Message-ID: <3818ED25.9C55E6FF@mindspring.com>


Chris,

Why not dump the v$sqltext view to a table on a regular basis, and analyze the resulting statements?

chrisoc_at_ans.net wrote:
>
> You've all confirmed my suspicion this would not
> be a picnic.
>
> Sure would be a cool utility for someone with
> knowledge of internals to make some money with.
> A few hundred dollars to save time/storage/backup
> media/maintenance/aggravation/bandwidth? I'd pay!
>
> Meanwhile I
> like the idea of taking an educated guess and creating
> a view, seeing what breaks and adding to the view
> when we have to. Finally, do something about
> the underlying table's unneeded data and structure.
>
> Chris O'Connor
>
> In article <7v7c01$7kp$1_at_nnrp1.deja.com>,
> 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.
> >
> > Chris O'Connor
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 28 1999 - 19:41:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US