>Oracle – iostat, vmstat , filestat ve çift kayıt silme

>http://adminschoice.com/iostat-vmstat-netstat
http://vsbabu.org/oracle/sect02.html
http://www.dba-oracle.com/art_disk_iostat.htm
https://netfiles.uiuc.edu/jstrode/www/oraview/V$FILESTAT.html
http://download-uk.oracle.com/docs/cd/F49540_01/DOC/server.815/a67775/ch20_io.htm#2688
——————————
create table SAPSR3.zTPALOG as select * from SAPSR3.TPALOG

SAPSR3.CSMCLSMAP

WHERE ROWID IN (
SELECT t.ROWID AS targetrowid
FROM TEST t,
(SELECT tst_id, tst_name, MAX (ROWID) AS maxrowid
FROM SAPSR3.TPALOG
GROUP BY tst_id, tst_name
HAVING COUNT (*) > 1) m
WHERE t.ROWID != m.maxrowid AND t.tst_id = m.tst_id)

SELECT MAX (ROWID) AS maxrowid
FROM SAPSR3.TPALOG

SELECT TRTIME, TRKORR, TARSYSTEM,TRCLI,TRSTEP,ALLCLI,PROJECT,TRUSER,RETCODE,HOST,ADMIN,TPSTAT_KEY,LINESeQUENCE
FROM SAPSR3.TPALOG
GROUP BY TRTIME, TRKORR, TARSYSTEM,TRCLI,TRSTEP,ALLCLI,PROJECT,TRUSER,RETCODE,HOST,ADMIN,TPSTAT_KEY,LINESeQUENCE
HAVING count(‘x’) > 1;

create table SAPSR3.TPALOG as

create table SAPSR3.TPALOG2 as select distinct * from SAPSR3.TPALOG
create table SAPSR3.TPALOG tablespace PSAPSR3 as select distinct * from SAPSR3.TPALOG2

drop table SAPSR3.TPALOG

rename SAPSR3.TPALOG2 to SAPSR3.TPALOG;

select * from sapsr3.CSMCLSMAP

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s