On Thursday, April 4, 2013 11:25:40 PM UTC-6, Lokesh ND wrote: > > Hi All, > > I have got one scenario to work on, I would like to know some > ideas about Collect the Information of most regularly used columns in a > table. > > Awaiting for your valuable suggestions. > > > Regards, > Lokesh > > >
Could this question be any more vague than it is? How do you define 'most used columns in a table'? Oracle does keep track of insets/updates/deletes in DBA_TAB_MODIFICATIONS but that's not column-level data. I suppose you COULD go through all of the sql submitted to the database and count up the times each listed column is used but there is no view that provides that information. You need to be more detailed in what you want and why you want it. David Fitzjarrell -- -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en --- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-plsql+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
