Learning by doing

Reading Time: < 1 minute

Speed test b/w Samsung and Patriot 128GB:

System 1 : Patriot 128GB:

[root@hws03 SSD1]# hdparm -Tt /dev/sdd

/dev/sdd:
Timing cached reads: 14160 MB in 2.00 seconds = 7083.45 MB/sec
Timing buffered disk reads: 844 MB in 3.00 seconds = 281.25 MB/sec
[root@hws03 SSD1]#

[root@hws03 SSD1]# dd if=/dev/zero of=/SSD1/ssdtest bs=512k count=1k
1024+0 records in
1024+0 records out
536870912 bytes (537 MB) copied, 0.517184 seconds, 1.0 GB/s
[root@hws03 SSD1]#

System 2 : Samsung 128GB:

[root@hws04 SSD1]# hdparm -Tt /dev/sda

/dev/sda:
Timing cached reads: 13644 MB in 2.00 seconds = 6826.51 MB/sec
Timing buffered disk reads: 476 MB in 3.00 seconds = 158.63 MB/sec

[root@hws04 SSD1]# dd if=/dev/zero of=/SSD1/ssdtest bs=512k count=1k
1024+0 records in
1024+0 records out
536870912 bytes (537 MB) copied, 0.592914 seconds, 905 MB/s
[root@hws04 SSD1]#

Reading Time: < 1 minute

Here are few SQL statemnets that can be used to lookup data using Oracle table version by timestap:

–select for table with version

select
* from PSOPRDEFN as of timestamp TO_TIMESTAMP(‘2009-05-19 21:24:02’, ‘YYYY-MM-DD HH24:MI:SS’)

SELECT versions_startscn, versions_starttime,
versions_endscn, versions_endtime,
versions_xid, versions_operation,
oprid ,VERSION,OPRDEFNDESC
from PSOPRDEFN
VERSIONS BETWEEN TIMESTAMP TO_TIMESTAMP(‘2009-05-19 20:00:08’, ‘YYYY-MM-DD HH24:MI:SS’)
AND TO_TIMESTAMP(‘2009-05-19 21:30:00’, ‘YYYY-MM-DD HH24:MI:SS’)
where oprid=’XXXX’;

select *
from dba_audit_trail
where timestamp between
TO_DATE(’05/19/2009:20:50:00′, ‘MM/DD/YYYY:HH24:MI:ss’) AND
TO_DATE(’05/19/2009:21:25:00′, ‘MM/DD/YYYY:HH24:MI:ss’)
and os_username not in (‘psoft’, ‘root’)
and username ‘xxxx’ –Users that you don’t want to show on report.
and action_name ‘LOGOFF’ — same here where ACTION is != to ‘LOGOFF’.
order by timestamp

Extented Audit Trails:

select * From DBA_COMMON_AUDIT_TRAIL where extended_timestamp between
TO_DATE(’07/29/2009:16:35:00′, ‘MM/DD/YYYY:HH24:MI:ss’) AND
TO_DATE(’07/29/2009:16:35:49′, ‘MM/DD/YYYY:HH24:MI:ss’)
order by extended_timestamp desc

for your refrence pleasure: http://www.petefinnigan.com/papers/audit.sql

Month: May 2012

SSD test b/w Samsung and Patriot 128GB

Using Oracle Flash back to find data