OraFAQ Forum: Server Administration » Test : Running many files simulation(!?)

Home » RDBMS Server » Server Administration » Test : Running many files simulation(!?) (Windows XP, Oracle 10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Test : Running many files simulation(!?) [message #361814]

Fri, 28 November 2008 02:38

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Hi all!

I have about 200 Select scripts will be called in a bat file , my purpose that how to run them simulation in a time to test my performance database. I thinks about dbms_scheduler, but it's not or may be I am a a duck !

Example:

Scripts: - check_arc_newest.sql

 
set pagesize 7000
set linesize 600
col name format a25
col "first_time" format a25
col "next_time" format a25
select name,
   to_char(first_time,'DD-MM-YYYY HH24:MI:SS') "first_time",
   to_char(next_time,'DD-MM-YYYY HH24:MI:SS') "next_time"
   from v$archived_log
    where completion_time=(select max(completion_time)
  from v$archived_log)
/

break on report
col name clear
col "first_time" clear
col "next_time" clear



PROMPT +--Identify the newest archive log file--++

.bat file

sqlplus /"as sysdba" @check_arc_newest

200 scripts running simulation.

May you clarify more?

Report message to a moderator

Previous Topic:	How to backup oracle audit_trail files when instance is online
Next Topic:	ORA-00604: error occurred at recursive SQL level 1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 21:05:46 CST 2024