sql - Get and store execution time in Oracle -

-

is there way , store execution time of select?

select * table1

thank you, radu.

oracle provides timing command check execution time taken query.

http://infolab.stanford.edu/~ullman/fcdb/oracle/or-nonstandard.html#timing%20sql%20commands


Comments

Post a Comment

Popular posts from this blog

c# - Outlook Add-in,group emails based on color category -

-
i need set sub folder group property through c# outlook add-in code basically, got mails in folder different color categories.i need sort them through code initially thought of sorting: microsoft.office.interop.outlook.items oitems =m_outlook.inbox.items; oitems.sort("[categories]"); dosnt work... :( pretty lost here also trying bubble sorting : but cant assign mail item next index object objmessage = subfolder.items[counter]; object objnextmessage = subfolder.items[counter + 1]; subfolder.items[counter] = objnextmessage; subfolder.items[counter + 1] = objnextmessage; error: property or indexer 'microsoft.office.interop.outlook._items.this[object]' cannot assigned -- read sorting seemed difficult option thought of grouping . how go ? cheers! rajat sort re-order items in collection won't update view: http://msdn.microsoft.com/en-us/library/microsoft.office.interop.outlook._items.sort.aspx you'd need set collection di...
Read more

javascript - Checkbox in firefox extension -

-
i want place menu item extension has check. <menupopup id="menu_toolspopup"> <menuitem type="checkbox" label="convert" id="menu_toolspopupitem"/> </menupopup> overlay.js window.addeventlistener("load", function() {myextension.init()}, false); init: function() { window.addeventlistener("copy", function() {myextension.test()}, false); }, test: function (win) { var x= document.getelementbyid("menu_toolspopupitem"); //not null!!! alert(x)=> [object xulelement] alert(x.checked);//-> undefined } i don't state of menu item. and how save selection after restart browser? looks have access attribute -- there's no convenient property wrapper in case: [attribute] checked type: boolean indicates whether element checked or not. use hasattribute() determine whether attribute set instead of getattribute(). https://...
Read more

reflection - How to use FxCop CustomDictionary.xml from the project localization? -

-
i create custom fxcop rule, need the path customdictionary.xml, not in program files, used in fxcop project file. has tryed use reflection assembly.getentryassembly() , diagnostic process.getcurrentprocess() no result. should search such information? do want access particular file, or take advantage of cumulative dictionary contents (as microsoft-provided fxcop rules)? if latter, can use public microsoft.fxcop.sdk.namingservice class, takes care of messy dictionary file reading details you.
Read more