摘要：
/****************************************************/创建一张空表，编写一个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 阅读全文
摘要：
SQL> drop table t;drop table t *ERROR at line 1:ORA-55610: Invalid DDL statement on history-tracked table情况分析置于Flashback data archive中的table的一些限制追踪表(Tracked table)，也就是指定将历史数据保存到某个flashback data archive中的table，不能执行DDL操作(add column除外)。NING@11g>drop table test;drop table test*ERROR at line 1:... 阅读全文
摘要：
C:\Users\MaryHu>exp ARCER/ARCER@DB234 FILE=E:\FGPS_20130528.dmp statistics=noneExport: Release 11.2.0.1.0 - Production on Tue May 28 08:04:54 2013Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 6 阅读全文