memory and timing wanted in Oracle version 7.0
From: Mahesh Vallampati <m0v5533_at_tamsun.tamu.edu>
Date: 13 Dec 1993 13:46:12 -0600
Message-ID: <2eigq4$deb_at_tamsun.tamu.edu>
Date: 13 Dec 1993 13:46:12 -0600
Message-ID: <2eigq4$deb_at_tamsun.tamu.edu>
Hie foks,
1 ) I want to time a query in SQL*Plus. But I am not looking for
time before execution and time after execution and finding the difference.
I want a more accurate timing result. Any pointers will be deeply
appreciated.
2 ) I have a table with the following attributes
col1 number(6),col2 number(6),col3 number(25,20).
Now i want the memory occupied by every row i.e. if i have 100 rows
what is the memory occupied and so on for 200 rows etc.
The machine is a 486 66Mhz with Oracle 7.0 if it matters.
Mahesh Vallampati,
Dept.of EE,Texas A & M Univ.
Mahesh Vallampati,(HOME) | Mahesh Vallampati(Office) | 301 Ball St., # 1086, | 642,TAMU Headquarters Bldg., | College Station, Tx - 77840 . |College Station,Tx 77840 | Ph : ( 409 ) 268 1489 . |Ph :(409 ) 862 4375 | ____________________________________________________________________/*I PROMISE TO USE THE KEY ,THE | /* THY SHALL WHOLE KEY AND NOTHING BUT THE KEY | INHERIT AND SO HELP ME CODD */ | DISTRIBUTE */ Received on Mon Dec 13 1993 - 20:46:12 CET