=============== script:  servicemetric.sql =========================== 

-- TTITLE 'Current Service-Level Metrics|(From GV$SERVICEMETRIC)'

set verify off
BREAK ON service_name NODUPLICATES
COL service_name    FORMAT A08          HEADING 'Service|Name' WRAP
COL inst_id         FORMAT 9999         HEADING 'Inst|ID'
COL beg_hist        FORMAT A10          HEADING 'Start Time' WRAP
COL end_hist        FORMAT A10          HEADING 'End Time' WRAP
COL intsize_csec    FORMAT 9999         HEADING 'Intvl|Size|(cs)'
COL goodness        FORMAT 999999       HEADING 'Good|ness'
COL delta           FORMAT 999999
COL cpupercall      FORMAT 99999999     HEADING 'CPU|Time|Per|Call|(mus)'
COL dbtimepercall   FORMAT 999999999999     HEADING 'Elpsd|Time|Per|Call|(mus)'
COL callspersec     FORMAT 99999999     HEADING '# 0f|User|Calls|Per|Second'
COL dbtimepersec    FORMAT 99999999     HEADING 'DBTime|Per|Second'
COL flags           FORMAT 999999       HEADING 'Flags'
SELECT
     service_name
    ,TO_CHAR(begin_time,'hh24:mi:ss') beg_hist
    ,TO_CHAR(end_time,'hh24:mi:ss') end_hist
    ,inst_id
    ,goodness
    ,delta
--    ,flags
--    ,cpupercall
--    ,dbtimepercall
--   ,callspersec
--    ,dbtimepersec
  FROM gv$servicemetric
 WHERE service_name = upper('&1')
 ORDER BY service_name, begin_time DESC, inst_id
;
CLEAR BREAKS
TTITLE OFF


=============== script:  ct.sql       =============================== 

pro count # of session by username DENIS
select sysdate, inst_id,count(*)  from gv$session
where username='DENIS'
group by  inst_id
order by inst_id
;

=============== script:  startSLBAload.sh ===========================

for i in {1..10}
do
  fan_SLBA.sh $1 &
done



=============== script:  fan_SLBA.sh  ================================

#!/bin/bash
#
# fan_SLBA.sh
#   -- run a job that logins to the db, doing an insert and a delete, and
#      then logout for the specified minutes
#
# Usage:  fan_SLBA.sh <interval_in_min>
#

UNPW="denis/oracle@SLBA"

INTERVAL=$1
CURT=$(date +%s)
ENDT=$(( $INTERVAL * 60 + $CURT ))

while [ $CURT -le $ENDT ]; do
  sqlplus -s $UNPW @fan.sql
  CURT=$(date +%s)
#  echo "now is $CURT"
done

echo " $0 job done ... "



=============== script:  fan.sql  ===================================

begin
 for i in 1..1000 loop
   insert into fan select sid from v$mystat where rownum < 2;
   commit;
   delete fan where c in (select sid from v$mystat where rownum< 2);
   commit;
 end loop;
end;
/
exit



=============== script:  cpu_load ===================================
while [ 1 ]; do
 gzip video1.mpg &
 gzip video2.mpg &
 wait
 gunzip video1.mpg.gz &
 gunzip video2.mpg.gz &
 wait
done


=============== end of all scripts =====================================