ArcerZhang`s Technology Blog

摘要： /*********************************************************************/实验步骤create chain---my_chain1create chain step1---my_prog1--my_porc1create chain step2---prog1--proc1--logcreate chain rule1---chain step1---my_prog1create chain rule2---chain step2---step1 successcheck/*************************** 阅读全文

摘要： Creating Job ChainsCreate a chain object.Define chain steps.Define chain rules.Starting the chain:Enable the chainCreate a job that points to the chain.chain执行步骤，如果chain A 执行成功了，就执行chain B，执行完B之后，还可以根据条件进行switch，执行chain C或者chain D.chain执行的各个步骤，可以嵌套.一个chain中的子步骤也可以是一个chain.Example of a Chain创建chain步骤 阅读全文

摘要： Creating Complex Schedules/* ================================================================================== Creating Complex Schedules ==================================================================================*/BEGIN DBMS_SCHEDULER.CREATE_SCHEDULE( ... 阅读全文

摘要： 1、在创建scheduler时，设置start_date =>systimestamp要比start_date => sysdate要好一些,systimestamp可以自动调整时区.2、job创建参数中，job_type的参数值类型 STORED_PROCEDURE------->job执行存储过程 PLSQL_BLOCK------------>pl/sql匿名块 EXECUTABLE------------->可执行操作系统命令 The type of this job.Valid values are: 'PLSQL_BLOCK',  阅读全文

摘要： Persistent Lightweight JobsPersistent lightweight jobs:Reduce the overhead and time required to start a jobHave a small footprint on disk for the job metadata and for storing run-time data.Are created from a job template(in the commad line)创建lightweight job的语法BEGIN DBMS_SCHEDULER.CREATE_JOB( ... 阅读全文

摘要： /****************************************************/创建一张空表，编写一个Job.每隔1分钟向表中插入一条数据实验步骤1、create tablecreate table log（user_name varchar2(10),user_date date）;2、create procedure --- pl/sql3、grant (grant create job or create any job)4、create program5、create scheduler6、create job7、monitor job8、enable jo 阅读全文

摘要： Your Basic Work FlowTo simplify management tasks with the Scheduler:Create a program (enabled or disabled)---optionalTo reuse this action within multiple jobsTo change the schedule for a job without having to re-create the PL/SQL blockCreate and use a schedule.Create and submit a job.Calendaring Exp 阅读全文

摘要： Simplifying Management TasksPerforming a series of month-end tasks on the last day of each monthRunning a dequeue procedure as soon as a message is enqueuedReplicating table data via materialized view refreshesRunning a daily job to back up databaseComputing table and index statistics twice a daySta 阅读全文

摘要： ObjectivesAfter completing this lesson,you should be able to :Simplify management tasks by using the schedulerCreate a job,program,and schedulerUse a time-based or event-based scheduler for executing scheduler jobsdescribe the use of windows,window groups,job classes,and consumer groupsUse email not 阅读全文

摘要： 查看Oracle Database系统内存参数情况(as sysdba)其他参数情况查看(as sysdba)SQL> show parameter shared_pool_sizeNAME TYPE VALUE------------------------------------ ----------- ------------------------------shared_pool_size big integer 0SQL> show parameter db_cac... 阅读全文