Oracle 11G新特性 - 随笔分类(第4页) - ArcerZhang

摘要：plachholder 阅读全文

posted @ 2013-05-30 09:37 ArcerZhang 阅读(114) 评论(0) 推荐(0)

摘要：/*********************************************************************/实验步骤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/*************************** 阅读全文

posted @ 2013-05-29 23:08 ArcerZhang 阅读(162) 评论(0) 推荐(0)

[bbk5170]第59集-第6章 - 用scheduler自动化 07

摘要：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步骤阅读全文

posted @ 2013-05-29 17:33 ArcerZhang 阅读(245) 评论(0) 推荐(0)

[bbk5167]第58集-第6章 - 用scheduler自动化 06

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

posted @ 2013-05-29 11:50 ArcerZhang 阅读(152) 评论(0) 推荐(0)

[bbk5164]第57集-第6章 - 用scheduler自动化 05

摘要：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', 阅读全文

posted @ 2013-05-29 11:49 ArcerZhang 阅读(284) 评论(0) 推荐(0)

[bbk5163]第56集-第6章 - 用scheduler自动化 04

摘要：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( ... 阅读全文

posted @ 2013-05-29 10:13 ArcerZhang 阅读(221) 评论(1) 推荐(0)

[bbk5158]第55集-第6章 - 用scheduler自动化 03

摘要：/****************************************************/创建一张空表，编写一个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 阅读全文

posted @ 2013-05-28 22:49 ArcerZhang 阅读(172) 评论(0) 推荐(0)

[bbk5157]第54集-第6章 - 用scheduler自动化 02

摘要：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 阅读全文

posted @ 2013-05-28 18:03 ArcerZhang 阅读(173) 评论(0) 推荐(0)

[bbk5154]第53集-第6章 - 用scheduler自动化 01

摘要：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 阅读全文

posted @ 2013-05-28 15:09 ArcerZhang 阅读(156) 评论(0) 推荐(0)

[bbk5149]第52集-第6章 - 用scheduler自动化 00

摘要：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 阅读全文

posted @ 2013-05-28 14:32 ArcerZhang 阅读(188) 评论(0) 推荐(0)

[bbk5148] 第51集 - 第五章管理内存 06

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

posted @ 2013-05-28 11:54 ArcerZhang 阅读(193) 评论(0) 推荐(0)

[bbk5145] 第50集 - 第五章管理内存 05

摘要：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------------------------------------ ----------- -----------------------------... 阅读全文

posted @ 2013-05-28 11:03 ArcerZhang 阅读(339) 评论(0) 推荐(0)

Oracle11g新特性：Flashback Data Archive续

摘要：参考文章: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 阅读全文

posted @ 2013-05-28 09:10 ArcerZhang 阅读(264) 评论(0) 推荐(0)

[bbk5139] 第49集 - 第五章管理内存 04

摘要：placeholder 阅读全文

posted @ 2013-05-27 19:18 ArcerZhang 阅读(124) 评论(0) 推荐(0)

[bbk5138] 第48集 - 第五章管理内存 03

摘要：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 阅读全文

posted @ 2013-05-27 18:51 ArcerZhang 阅读(137) 评论(0) 推荐(0)

[bbk5131] 第47集 - 第五章管理内存 02

摘要：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 阅读全文

posted @ 2013-05-27 17:55 ArcerZhang 阅读(198) 评论(0) 推荐(0)

[bbk5130] 第46集 - 第五章管理内存 01

摘要：在一个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... 阅读全文

posted @ 2013-05-27 16:24 ArcerZhang 阅读(164) 评论(0) 推荐(0)

[bbk5125] 第45集 - 第五章管理内存 00

摘要：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 阅读全文

posted @ 2013-05-27 15:42 ArcerZhang 阅读(144) 评论(0) 推荐(0)

[bbk5120] 第44集 - 第四章 Flashback Database 08

摘要：Restoring Tables from the Recycle BinRestore dropped tables and dependent objects.If multiple recyclye bin entries have the same original name:Use qunique,system-generated names to restore a particular version.When using original names,the restored table is last in,first out(LIFO)Rename the original 阅读全文

posted @ 2013-05-27 11:09 ArcerZhang 阅读(286) 评论(0) 推荐(0)

[bbk5116] 第43集 - 第四章 Flashback Database 07

摘要：/********************************/闪回已经删除过的表注意：假如一张表被删除之后，那么它对应的索引以及约束也会一同被删除.被删除的对象(表、索引、约束、触发器)放到回收站之后，oracle都会重新分配一个新的名称.假如通过flashback table技术闪回表的时候，表的名称可以回到之前，但是索引名称、约束的名称将不会回到之前.仍将沿用在回收站分配的名称.如果闪回成功之后，就需要手工将索引、约束、触发器的名称rename到之前的名称./********************************/SQL> drop table t;Table dro 阅读全文

posted @ 2013-05-27 10:09 ArcerZhang 阅读(192) 评论(0) 推荐(0)

ArcerZhang`s Technology Blog

走在技术的道路上，享受这个过程

随笔分类 - Oracle 11G新特性

公告