How do you monitor if the indexes are being used in 8i? Individually the tkprof and explain plans do the trick. However from a running system, how can the index usage be determined?
If the index is being used? How many times did the index get used during a specific time frame etc.
Regards
MenonDo
Any recommendations on a good UNIX o/s more specifically focusing on tuning scenarios and examples.
Thanks
Menon
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Hi Madhavan
Thanks to you and Jonathan for the input.
Another question on the same subject. How are policies defined for child tables. For example if you have anparent tablewhich has say company id so you define a policy on this column. now a parent child related table, the child tableis related
Hi Guys,
I am trying to setup FGCA for our customers on their reporting system. I have got this working for a single table, however, when a policy needs to be added for multiple tables. It fails returning no rows from the second table.
Oracle documentation is not very helpful this arena. Can
this function and then applies thepredicate based on the text returned from the functionPlease let me know if you need more detailed informationThanksMadhavanhttp://www.dpapps.comOn Wed, 05 Mar 2003 07:05:37 -0800, "Murali Menon" <[EMAIL PROTECTED]>said: Hi Guys, I am trying t!
o se
Uniqueness indicates that there are less skewed values correct! Under what circumstances would a skewed column value for a unique column exist.
Another question, what about histograms on indexes itself? If histograms are generated on columns with skewed values, does it matter when the indexes are
So faronly had to use RBO, now we are moving towards using CBO. However none of the documents really talk in detail about Histograms, the goods, bads where and where not to use.
I have read that HISTOGRAMS are good for columns that are non unique and that have many duplicate values. While DSS