随笔分类 - Oracle 10G新特性
摘要：Remote database job是11g的新特性Creating a Job Array--1、Declare variables of types sys.job and sys.job_array:DECLARE newjob sys.job; newjobarr sys.job_array;--2、Initialize the job array:BEGIN newjobarr := SYS.JOB_ARRAY();--3、Size the job array to hold the number of jobs needed:newjob...
阅读全文
摘要：plachholder
阅读全文
摘要：/*********************************************************************/实验步骤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...
阅读全文
摘要：Oracle Database Memory ParametersProgram Global Area(PGA)Automatic PGA memory management is enabled by default.Using the V$PARAMETER ViewSQL> show parameter sga_target;NAME TYPE VALUE------------------------------------ ----------- -----------------------------...
阅读全文
摘要：参考文章:http://www.ningoo.net/html/2007/oracle11g_new_feature_flashback_data_archive2.html一.后台进程Oracle11g为Flashback data archive特性专门引入了一个新的后台进程FBDA，用于将追踪表(traced table，也就是将指定使用flashback data archive的table)的历史变化数据转存到闪回归档区。NING@11g>select name,description from v$bgprocess where name=’FBDA’;NAME DESCRI
阅读全文
摘要：placeholder
阅读全文
摘要：Java Pool and Streams PoolJava pool memory is used in server memory for all session-specific Java code and data in the JVM.Streams pool memory is used exclusively by Oracle Streams to:Store buffered queue messagesProvide memory for Oracle Streams processesRedo Log BufferIs a circular buffer in the S
阅读全文
摘要：shared server模式下，UGA放在SGA的哪个位置？如果配置了LARGE POOL，UGA就会放在LARGE POOL中；否则如果没有配置，那么就存放在SHARED POOL当中.oracle 11g以后，可以将sql，pl/sql的执行结果存放在result pool中.Shared PoolContents:Library cache:Command text,parsed code,and execution planData dictionary cache:Definitions for tables,columns,and privileges from the data
阅读全文
摘要：在一个Data Buffer Cache中，有可能存在一个数据块的多个副本.Dirty是指，被修改过的、还没有被flush到磁盘中去的数据状态.Buffer Cache数据在Buffer Cache中的四种状态值PinnedCleanFree/unusedDirtyUsing Multiple Buffer Poolsstep: =>创建Buffer Pool =>使用Buffer Pool 1、在创建对象时指定Buffer Pool CREATE INDEX cust_idx ... STORAGE(BUFFER_POOL KEEP); 2、修改表所在的BUF...
阅读全文
摘要：ObjectivesAfter completing this lesson,you should be able to :Describe the memory components in the SGAImplement Automatic Memory ManagementManually configure SGA parametersConfigure automatic PGA memory managementMemory Management:OverviewDBAs must consider memory managment to be a crucial part of
阅读全文
摘要：查看包的结构内容[oracle@arcerzhang ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Sun May 19 20:15:32 2013Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn /as sysdbaConnected.SQL> desc dbms_flashback_archive;PROCEDURE DISASSOCIATE_FBA Argument Name Type ...
阅读全文
浙公网安备 33010602011771号