December 2012

I think I’m going to reply to all of Debra Lilley‘s emails with my own disclaimer that says,

Unless otherwise stated, this email has got nothing to do with Debra Lilley or the massive disclaimer that gets added to every email she sends… Even the iddy-biddy 3 word emails…

That Fujitsu email disclaimer is one serious piece of text!

Heaven forbid you get an out of office reply…

Cheers

Tim…

set null ~ pagesize 40 linesize 132;
column id format 90;
column datetrunc format a30;
column dateuntrunc format a30;
column timetrunc format a30;
column timeuntrunc format a30;
create table time_size2
(
id number,
datetrunc date,
dateuntrunc date,
timetrunc timestamp,
timeuntrunc timestamp
);
insert into time_size2
select rownum, trunc(sysdate), sysdate,trunc(sysdate),sysdate
from dual;
insert into time_size2 values (2,null,null,null,null);
commit;
select * from time_size2;
select
to_char(datetrunc, 'YYYY MM DD HH24:MI:SS') "datetrunc",
to_char(dateuntrunc,'YYYY MM DD HH24:MI:SS') "dateuntrunc",
to_char(timetrunc, 'YYYY MM DD HH24:MI:SS.FF9') "timetrunc",
to_char(timeuntrunc,'YYYY MM DD HH24:MI:SS.FF9') "timeuntrunc"
from
time_size2;

Here’s the latest version of my Oracle session level performance Snapper tool:
https://github.com/tanelpoder/tpt-oracle/blob/master/snapper.sql I’m going to add more stuff to Snapper in coming days, but thought to release something for testing already :)
There are some cosmetic changes, like printing empty lines and header lines for better readability (still controllable by the pagesize parameter, look into the scripts).
I’ve made some changes in the visual “graph” column just for easier readability when glancing at a snapper report: the @-character is used for CPU time (@ looks like a letter C a bit, doesn’t it :)

Here’s the latest version of my Oracle session level performance Snapper tool:
https://github.com/tanelpoder/tpt-oracle/blob/master/snapper.sql I’m going to add more stuff to Snapper in coming days, but thought to release something for testing already :)
There are some cosmetic changes, like printing empty lines and header lines for better readability (still controllable by the pagesize parameter, look into the scripts).
I’ve made some changes in the visual “graph” column just for easier readability when glancing at a snapper report: the @-character is used for CPU time (@ looks like a letter C a bit, doesn’t it :)