Home » RDBMS Server » Server Administration » Test : Running many files simulation(!?) (Windows XP, Oracle 10.2.0.4)
Test : Running many files simulation(!?) [message #361814] Fri, 28 November 2008 02:38
trantuananh24hg
Messages: 668
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?
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:
  


Current Time: Fri Dec 09 21:15:11 CST 2016

Total time taken to generate the page: 0.06730 seconds