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

Home -> Community -> Mailing Lists -> Oracle-L -> delay in commit statements

delay in commit statements

From: <aheda_at_cdotd.ernet.in>
Date: Mon, 17 Jul 2000 14:54:58 +0500 (GMT+0500)
Message-Id: <10562.112356@fatcity.com>


hi
I am facing a problem that whenever commiting a change in the database the
time taken by the update statement is negligible but that of the commit statement is very significant.
i.e. each commit statement in the application takes around 20-30 ms which is not bearable in real time app.
In the current setup the datafiles redofiles and indexs are all stored on
different physical disc.
what could be the possible reasons of this delay

Arvind

--openmail-part-09881615-00000001

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

eJ8+Im4+AQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEAHwAAAFJFOiBkZWxheSBp biBjb21taXQgc3RhdGVtZW50cwAICwEFgAMADgAAANAHBwATAAgAEgAhAAMALwEBAIAAAKAA AAAEAKAAQgBOAEpvaG4gSi4gS2FuYWdhcmFqIC9GSUMzMjEsT1BFTk1BSUwvbz1CUlVORUkg U0hFTEwgUEVUUk9MRVVNIFNFUklBAE9QRU5NQUlMOkpvaG4gSi4gS2FuYWdhcmFqIC9GSUMz MjEsT1BFTk1BSUwvbz1CUlVORUlcIFNIRUxMXCBQRVRST0xFVU1cIFNFUklBAAAAAAAAAAAA JyoBIIADAA4AAADQBwcAEwAIABEAGgADACcBAQmAAQAhAAAANURBRDJEMDUwNDVERDQxMTkz NzcwMDYwOTc5OTExQjMA6QYBBJAGAAQEAAACAAAAEgAAAAMAADADAAAACwAPDgAAAAACAf8P AQAAAEcAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAQBvcmFjbGUtbEBmYXRjaXR5LmNvbQBT TVRQAG9yYWNsZS1sQGZhdGNpdHkuY29tAAAeAAIwAQAAAAUAAABTTVRQAAAAAB4AAzABAAAA FQAAAG9yYWNsZS1sQGZhdGNpdHkuY29tAAAAAAMAFQwBAAAAAgH5DwEAAABHAAAAAAAAAIEr H6S+oxAZnW4A3QEPVAIAAAEQb3JhY2xlLWxAZmF0Y2l0eS5jb20AU01UUABvcmFjbGUtbEBm YXRjaXR5LmNvbQAAAwD+DwYAAAAeAAEwAQAAABcAAAAnb3JhY2xlLWxAZmF0Y2l0eS5jb20n AAACAQswAQAAABoAAABTTVRQOk9SQUNMRS1MQEZBVENJVFkuQ09NAAAAAwAAOQAAAAALAEA6 AAAAAAMAcToAAAAAHgD2XwEAAAAVAAAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAAAAgH3XwEA AABHAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAEAb3JhY2xlLWxAZmF0Y2l0eS5jb20AU01U UABvcmFjbGUtbEBmYXRjaXR5LmNvbQAAAwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAA AAMSAAAAAwAAMAQAAAALAA8OAAAAAAIB/w8BAAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QC AAABAGFoZWRhQGNkb3RkLmVybmV0LmluAFNNVFAAYWhlZGFAY2RvdGQuZXJuZXQuaW4AAB4A AjABAAAABQAAAFNNVFAAAAAAHgADMAEAAAAVAAAAYWhlZGFAY2RvdGQuZXJuZXQuaW4AAAAA AwAVDAIAAAACAfkPAQAAAEcAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAARBhaGVkYUBjZG90 ZC5lcm5ldC5pbgBTTVRQAGFoZWRhQGNkb3RkLmVybmV0LmluAAADAP4PBgAAAB4AATABAAAA FwAAACdhaGVkYUBjZG90ZC5lcm5ldC5pbicAAAIBCzABAAAAGgAAAFNNVFA6QUhFREFAQ0RP VEQuRVJORVQuSU4AAAADAAA5AAAAAAsAQDoAAAAAAwBxOgAAAAAeAPZfAQAAABUAAABhaGVk YUBjZG90ZC5lcm5ldC5pbgAAAAACAfdfAQAAAEcAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAA AQBhaGVkYUBjZG90ZC5lcm5ldC5pbgBTTVRQAGFoZWRhQGNkb3RkLmVybmV0LmluAAADAP1f AQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAABF3eAQOQBgAcBAAAIgAAAAsAAgABAAAACwAj AAAAAAADACYAAAAAAAsAKQAAAAAAAwA2AAAAAABAADkAEKG+3xbxvwEeAEIAAQAAAEIAAABK b2huIEouIEthbmFnYXJhaiAvRklDMzIxLE9QRU5NQUlML289QlJVTkVJIFNIRUxMIFBFVFJP TEVVTSBTRVJJQQAAAEAASAAw22LhFvG/AR4AcAABAAAAHwAAAFJFOiBkZWxheSBpbiBjb21t aXQgc3RhdGVtZW50cwAAAgFxAAEAAAAWAAAAAb/xFt+2BS2tYV0EEdSTdwBgl5kRswAAHgAa DAEAAABCAAAASm9obiBKLiBLYW5hZ2FyYWogL0ZJQzMyMSxPUEVOTUFJTC9vPUJSVU5FSSBT SEVMTCBQRVRST0xFVU0gU0VSSUEAAAACAR0MAQAAAE4AAABPUEVOTUFJTDpKT0hOIEouIEtB TkFHQVJBSiAvRklDMzIxLE9QRU5NQUlML089QlJVTkVJXCBTSEVMTFwgUEVUUk9MRVVNXCBT RVJJQQAAAB4AHgwBAAAACQAAAE9QRU5NQUlMAAAAAB4AHwwBAAAARQAAAEpvaG4gSi4gS2Fu YWdhcmFqIC9GSUMzMjEsT1BFTk1BSUwvbz1CUlVORUlcIFNIRUxMXCBQRVRST0xFVU1cIFNF UklBAAAAAAMAgBD/////QAAHMECcEbAT8b8BQAAIMBATorcW8b8BAwDeP69vAAALAACACCAG AAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAAoAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAA AAAAAwAIgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAADABaACCAGAAAAAADAAAAAAAAA RgAAAAARhQAAAAAAAAMAJ4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAADjFQAAHgAogAggBgAA AAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC41AAsAKYAIIAYAAAAAAMAAAAAAAABGAAAA AAaFAAAAAAAACwAtgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAC+ACCAGAAAAAADA AAAAAAAARgAAAAAYhQAAAAAAAB4APYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAA AAAAAAAeAD6ACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgA/gAggBgAA AAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAsASoALIAYAAAAAAMAAAAAAAABGAAAA AACIAAAAAAAACwBMgAsgBgAAAAAAwAAAAAAAAEYAAAAABYgAAAAAAAAeAD0AAQAAAAEAAAAA Received on Mon Jul 17 2000 - 04:54:58 CDT

Original text of this message

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