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

Home -> Community -> Mailing Lists -> Oracle-L -> RE : Finding Indexes that are not being used

RE : Finding Indexes that are not being used

From: <john.j.kanagaraj_at_shell.com.bn>
Date: Thu, 6 Jul 2000 10:36:57 +0800
Message-Id: <10549.111298@fatcity.com>


--openmail-part-09753bce-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

Chris/Stephane,

Gents - nice idea, but before we (others) jump in, this works *only* for the Parallel Server version of Oracle 8.0/8.1 :(

Does anyone have an equivalent for Non-OPS and _any_ version (7.3 and up)?

TIA,
John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

God so loved the world that He didn't send a committee! (See John 3:16 for details)
** Opinions expressed here are solely mine and not necessarily those of my employer **

--openmail-part-09753bce-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+InBXAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEALQAAAFJFIDogRmluZGlu ZyBJbmRleGVzIHRoYXQgYXJlIG5vdCBiZWluZyB1c2VkAFAPAQWAAwAOAAAA0AcHAAYACgAk ADEABABHAQEAgAAAoAAAAAQAoABCAE4ASm9obiBKLiBLYW5hZ2FyYWogL0ZJQzMyMSxPUEVO TUFJTC9vPUJSVU5FSSBTSEVMTCBQRVRST0xFVU0gU0VSSUEAT1BFTk1BSUw6Sm9obiBKLiBL YW5hZ2FyYWogL0ZJQzMyMSxPUEVOTUFJTC9vPUJSVU5FSVwgU0hFTExcIFBFVFJPTEVVTVwg U0VSSUEAAAAAAAAAAAAnKgEggAMADgAAANAHBwAGAAoAIQAsAAQAPwEBCYABACEAAAAzNkY3 QzI2RUNGNTJENDExOTM2RTAwNjA5Nzk5MTFCMwAGBwEEkAYABAIAAAEAAAASAAAAAwAAMAIA AAALAA8OAAAAAAIB/w8BAAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABAG9yYWNsZS1s QGZhdGNpdHkuY29tAFNNVFAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAB4AAjABAAAABQAAAFNN VFAAAAAAHgADMAEAAAAVAAAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAAAAwAVDAEAAAACAfkP AQAAAEcAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAARBvcmFjbGUtbEBmYXRjaXR5LmNvbQBT TVRQAG9yYWNsZS1sQGZhdGNpdHkuY29tAAADAP4PBgAAAB4AATABAAAAFwAAACdvcmFjbGUt bEBmYXRjaXR5LmNvbScAAAIBCzABAAAAGgAAAFNNVFA6T1JBQ0xFLUxARkFUQ0lUWS5DT00A AAADAAA5AAAAAAsAQDoAAAAAAwBxOgAAAAAeAPZfAQAAABUAAABvcmFjbGUtbEBmYXRjaXR5 LmNvbQAAAAACAfdfAQAAAEcAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAQBvcmFjbGUtbEBm YXRjaXR5LmNvbQBTTVRQAG9yYWNsZS1sQGZhdGNpdHkuY29tAAADAP1fAQAAAAMA/18AAAAA AgH2DwEAAAAEAAAAAAAAAsFvAQOQBgAsBAAAIgAAAAsAAgABAAAACwAjAAAAAAADACYAAAAA AAsAKQAAAAAAAwA2AAAAAABAADkAEEN2CfPmvwEeAEIAAQAAAEIAAABKb2huIEouIEthbmFn YXJhaiAvRklDMzIxLE9QRU5NQUlML289QlJVTkVJIFNIRUxMIFBFVFJPTEVVTSBTRVJJQQAA AEAASABwxSIM8+a/AR4AcAABAAAALQAAAFJFIDogRmluZGluZyBJbmRleGVzIHRoYXQgYXJl IG5vdCBiZWluZyB1c2VkAAAAAAIBcQABAAAAFgAAAAG/5vMJQG7C9zdSzxHUk24AYJeZEbMA AB4AGgwBAAAAQgAAAEpvaG4gSi4gS2FuYWdhcmFqIC9GSUMzMjEsT1BFTk1BSUwvbz1CUlVO RUkgU0hFTEwgUEVUUk9MRVVNIFNFUklBAAAAAgEdDAEAAABOAAAAT1BFTk1BSUw6Sk9ITiBK LiBLQU5BR0FSQUogL0ZJQzMyMSxPUEVOTUFJTC9PPUJSVU5FSVwgU0hFTExcIFBFVFJPTEVV TVwgU0VSSUEAAAAeAB4MAQAAAAkAAABPUEVOTUFJTAAAAAAeAB8MAQAAAEUAAABKb2huIEou IEthbmFnYXJhaiAvRklDMzIxLE9QRU5NQUlML289QlJVTkVJXCBTSEVMTFwgUEVUUk9MRVVN XCBTRVJJQQAAAAADAIAQ/////0AABzCwRh6b8ua/AUAACDCwRh6b8ua/AQMA3j+vbwAACwAA gAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQ hQAAAAAAAAMACIAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAAAwAWgAggBgAAAAAAwAAA AAAAAEYAAAAAEYUAAAAAAAADACeACCAGAAAAAADAAAAAAAAARgAAAABShQAA4xUAAB4AKIAI IAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADguNQALACmACCAGAAAAAADAAAAAAAAA RgAAAAAGhQAAAAAAAAsALYAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAvgAggBgAA AAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAD2ACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAA AAEAAAAAAAAAHgA+gAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4AP4AI IAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAALAEqACyAGAAAAAADAAAAAAAAA RgAAAAAAiAAAAAAAAAsATIALIAYAAAAAAMAAAAAAAABGAAAAAAWIAAAAAAAAHgA9AAEAAAAB AAAAAAAAAAMADTT9NwAAyq4= Received on Wed Jul 05 2000 - 21:36:57 CDT

Original text of this message

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