ITPub博客

You use online segment shrink to reclaim fragmented free space below the high water mark in an Oracle Database segment. The benefits of segment shrink are these:Compaction of data leads to better cache utilization, which in turn leads to better online transaction processing (OLTP) perf...

位置参数可以用shift命令左移。比如shift 3表示原来的$4现在变成$1，原来的$5现在变成$2等等，原来的$1、$2、$3丢弃，$0不移动。不带参数的shift命令相当于shift 1。非常有用的 Unix 命令:shift。我们知道，对于位置变量或命令行参数，其个数必须是确定的，或者当 Shell 程序不知道其个数时，可以把所有参数一起赋值...

一般来说是由于客户端监听的版本比数据库版本高造成的，可以安装一个比数据库服务器版本低的客户端来解决这个问题

两台机器系统时间不一致造成的，使用linuxdate -s 12/31/2015date -s 18:00:00

一、 存储规划 二、 创建 VG、LV [root@aix213 /]$lspv hdisk1          00c6d0ef0395eef2                    rootvg          active hdisk0          00032fb8...

create or replace procedure p_di_crtvwis lvc_sql varchar2(500);cursor cur is SELECT DISTINCT upper(viewsql) viewsql FROM (SELECT 'create or replace force view di_'||DMLX_DM ||' as select * from J1_DI.DI_GY_1JDM where dmlx_dm = ''' || DMLX_DM || '''' viewsql  FROM J1_DI.DI_G...

create or replace procedure get_stat(i_owner in varchar2,                                       i_table in varchar2 default null                    ...

只授予查看存储过程的权限grant debug any procedure to user ;

 VARIABLE jobno number;BEGIN DBMS_JOB.SUBMIT(:jobno,                              'dbms_ddl.analyze_object(''TABLE'', ''DQUON'', ''ACCOUNTS'',  ''ESTIMATE'', NULL, 5...

[root@www.linuxidc.com ~]# fdisk -l Disk /dev/sda: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / ...

Valid for Extract and Replicat            Use the DBOPTIONS parameter to specify database options. This is a global parameter,             applying to all TABLE or MAP statements in the parameter file.      ...

[oracle@kf210 ~]$ cat count.sh echo J1_G3_ZBQls -l /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/04\ procedure/ |grep "^-"| wc -lls -l /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/01\ init/ |grep "^-"| wc -lls -l /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/01\ table/ |grep "^-"| wc -l...

[oracle@kf210 ~]$ cat c.shcd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/01\ init/rm *cd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/01\ table/rm *cd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/02\ view/rm *cd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/04\ procedure/rm *cd /u01...

declare v_text clob; v_owner varchar2(30); v_view_name varchar2(30); v_count number; v_loc number; v_loc_s number; v_len number; v_text_len number; v_count_s number; v_count_t number; cursor c_xv is  select av.owner,av.view_name...

ora-600 [2252]<br /><br />解决方法：更改系统至当前时间，并重启数据库

<p style="color:#333333;font-family:Arial;font-size:14px;line-height:26px;white-space:normal;background-color:#FFFFFF;">NAT模式的具体配置</p><p style="color:#333333;font-family:Arial;font-size:14px;line-height:26px;white-space:normal;background-color:#FFFFFF;">NAT方式：虚拟机可以上外网，可以访...

<div style="color:#666666;font-family:宋体, Arial;font-size:16px;line-height:26px;white-space:normal;background-color:#FFFFFF;"><span style="font-size:small;">环境:</span></div><div style="color:#666666;font-family:宋体, Arial;font-size:16px;line-height:26px;white-space:normal;background-color:#...

alter table tablename<br /><img src="/attachment/201509/17/29802484_1442477881XtEN.png" width="378" height="91" alt="" /><br /><br /><br /><br />eg:<br /><br /><br />alter table J1_DW.DM0_DJ_NSRQC rename PARTITION LIST_2020150401 to LIST_20150401;<br /><br /><br />...

<p class="MsoNormal"><span lang="EN-US">监听1：<br />LISTENER=</span></p><p class="MsoNormal"><span lang="EN-US">&nbsp;(DESCRIPTION=</span></p><p class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp;(ADDRESS_LIST=</span></p><p class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp...

Example 2–41 Configuring Device and Backup OptionsThis example configures channels of device type DISK and sbt and sets the default device type as sbt. The example also enables backup optimization and configures a recovery windows of two weeks.CONFIGURE CHANNEL...