SELECT COUNT(*) FROM v$active_session_history ;

SELECT BBB.USERNAME,AAA.* FROM v$active_session_history AAA
INNER JOIN ALL_USERS BBB ON AAA.USER_ID=BBB.USER_ID ;

 

SELECT * FROM v$active_session_history WHERE PROGRAM=’Toad.exe’;

SELECT USERNAME,LOGON_TIME,PROGRAM FROM v$session; —login olma zamanlarını gösteren bir sorgu

 

SELECT * FROM v$active_session_history WHERE PROGRAM=’Toad.exe’;

SELECT * FROM v$active_session_history;

 

SELECT BBB.USERNAME,AAA.* FROM v$active_session_history AAA
INNER JOIN ALL_USERS BBB ON AAA.USER_ID=BBB.USER_ID
WHERE SAMPLE_TIME>TRUNC(SYSDATE)
;

SELECT BBB.USERNAME,COUNT(*) FROM v$active_session_history AAA
INNER JOIN ALL_USERS BBB ON AAA.USER_ID=BBB.USER_ID
WHERE SAMPLE_TIME>TRUNC(SYSDATE)
GROUP BY BBB.USERNAME
;

 

SELECT NVL(a.event, ‘ON CPU’) AS event,
COUNT(*) AS total_wait_time
FROM v$active_session_history a
WHERE a.sample_time > SYSDATE – 5/(24*60) — 5 mins
GROUP BY a.event
ORDER BY total_wait_time DESC;

 

SELECT * FROM ALL_USERS;

SELECT * FROM dba_hist_active_sess_history;

SELECT * FROM YAA00;
SELECT * FROM MMA03;
SELECT * FROM MMM15;
SELECT * FROM CMB00 WHERE LOWER(CMB00_NAME) LIKE ‘%mma03%’;

SELECT YAA00_CODE,MMA00_ID FROM MMA00 GROUP BY YAA00_CODE,MMA00_ID HAVING COUNT(*)>1;

SELECT YAA00_CODE,MMA00_ID,MMA03_ID FROM MMA03;

SELECT MMA03_ID,MMM00_TITLE,MMM00_BARCODE,LST_PRICE,UNIT_PRICE,ST_AMOUNT,VAT_AMOUNT,DISC_CALC_TYPE,QTY,AMOUNT_NET FROM MMA03;

SELECT * FROM MMA00;