Useful Stuff and Scripts

Below are a number of articles I have written partly to help my understanding and partly to help any other DBAs who find themselves in a similar position. The articles have been written as "Problem" and "Solution" style but feedback and questions are welcome. I can be contacted at neil@grobycomputers.co.uk

• Tuning - SQL with multi-column indexes
• Histograms - Index Selectivity and How To Calculate ix_sel
• A word about Unicode and Byte Order Marks
• WE8MSWIN1252, WE8ISO8859, euro and NLS_LANG
• ORA-01555 Snapshot too old
• ORA-04031 unable to allocate space X in large pool
• Proxy-Login - become a user without knowing their password