average.eangenerator.com | ||
ASP.NET PDF Viewer using C#, VB/NETTo run this test harness, you must have access to V$STATNAME, V$MYSTAT, and V$LATCH. You must be granted direct select privileges (not via a role) on SYS.V_$STATNAME, SYS.V_$MYSTAT, and SYS.V_$LATCH. You can then create the following view: SQL> create or replace view stats 2 as select 'STAT...' || a.name name, b.value 3 from v$statname a, v$mystat b 4 where a.statistic# = b.statistic# 5 union all 6 select 'LATCH.' || name, gets 7 from v$latch; View created. All you need then is a small table to store the statistics: create global temporary table run_stats ( runid varchar2(15), name varchar2(80), value int ) on commit preserve rows; The code for the test harness package is as follows: create or replace package runstats_pkg as procedure rs_start; procedure rs_middle; procedure rs_stop( p_difference_threshold in number default 0 ); end; / create or replace package body runstats_pkg as g_start number; g_run1 number; g_run2 number; procedure rs_start is begin delete from run_stats; how to print barcode in excel, barcode macro excel free, barcode activex control for excel 2010 free download, barcode excel 2003 free download, excel 2010 barcode font, barcode add in for excel 2003, excel barcode add in, create barcode labels in excel 2010, barcode add in for microsoft excel 2007, how to convert number to barcode in excel 2010,do if not ok then failwithf "the type %s is not a basic blittable type" ((type 'a).ToString()) let hFile = CreateFile (fileName, GENERIC_READ, FILE_SHARE_READ_WRITE, IntPtr.Zero, OPEN_EXISTING, 0, IntPtr.Zero ) do if ( hFile.Equals(INVALID_HANDLE) ) then Marshal.ThrowExceptionForHR(Marshal.GetHRForLastWin32Error()); let hMap = CreateFileMapping (hFile, IntPtr.Zero, READONLY, 0,0, null ) do CloseHandle(hFile) |> ignore do if hMap.Equals(NULL_HANDLE) then Marshal.ThrowExceptionForHR(Marshal.GetHRForLastWin32Error()); let start = MapViewOfFile (hMap, MAP_READ,0,0,0) do if ( start.Equals(IntPtr.Zero) ) then Marshal.ThrowExceptionForHR( Marshal.GetHRForLastWin32Error()) insert into run_stats select 'before', stats.* from stats; g_start := dbms_utility.get_time; end; procedure rs_middle is begin g_run1 := (dbms_utility.get_time-g_start); insert into run_stats select 'after 1', stats.* from stats; g_start := dbms_utility.get_time; end; procedure rs_stop(p_difference_threshold in number default 0) is begin g_run2 := (dbms_utility.get_time-g_start); dbms_output.put_line ( 'Run1 ran in ' || g_run1 || ' hsecs' ); dbms_output.put_line ( 'Run2 ran in ' || g_run2 || ' hsecs' ); dbms_output.put_line ( 'run 1 ran in ' || round(g_run1/g_run2*100,2) || '% of the time' ); dbms_output.put_line( chr(9) ); insert into run_stats select 'after 2', stats.* from stats; dbms_output.put_line ( rpad( 'Name', 30 ) || lpad( 'Run1', 10 ) || lpad( 'Run2', 10 ) || lpad( 'Diff', 10 ) ); for x in ( select rpad( a.name, 30 ) || to_char( b.value-a.value, '9,999,999' ) || to_char( c.value-b.value, '9,999,999' ) || to_char( ( (c.value-b.value)-(b.value-a.value)), '9,999,999' ) data from run_stats a, run_stats b, run_stats c where a.name = b.name and b.name = c.name and a.runid = 'before' <asp:TextBox Runat=server ID=txtDemo EnableViewState=false /> </form> </body> </html> And here are the contents of the code-behind: public partial class ViewStateIE_aspx : System.Web.UI.Page { void Page_Load(object sender, EventArgs e) { if (this.IsPostBack) { lblOutput.Text = "Postback"; } else { lblOutput.Text = "First Request"; } } } When you request the page, type something into the input and hit return. A postback occurs and you can see that the TextBox has maintained its value (see Figure 4-2). member m.AddressOf(i: int) : 'a nativeptr = NativePtr.of_nativeint(start + Int32.to_nativeint i) b.runid = 'after 1' c.runid = 'after 2' (c.value-a.value) > 0 abs( (c.value-b.value) - (b.value-a.value) ) > p_difference_threshold order by abs( (c.value-b.value)-(b.value-a.value)) ) loop dbms_output.put_line( x.data ); end loop; dbms_output.put_line( chr(9) ); dbms_output.put_line ( 'Run1 latches total versus runs -- difference and pct' ); dbms_output.put_line ( lpad( 'Run1', 10 ) || lpad( 'Run2', 10 ) || lpad( 'Diff', 10 ) || lpad( 'Pct', 8 ) ); for x in ( select to_char( to_char( to_char( to_char( from ( select from where and and and and and )
|