ITPub博客

#!/bin/bashvar1="scp -r /home/oracle/luhp/ " var2=:/home/oracle/ var3=`cat /monitor/dcli/gg_hostlist |grep -v "^$"|grep -v batch| sed -n "n;p"|grep "^#"|wc -l`if [ ! -d "/home/oracle/luhp" ]; thenmkdir /home/oracle/luhpfi/bin/cp -r /samples/ogg/* /home/oracle/luhpfor ((i=1;i<=var...

在下拉框 options --> session options --> terminal --> X/Y/Zmodem --> directories --> downloads

^：开始$：结尾^$：表示空行

*  *  *  *  *  command分、时、日、月、周

rz命令没找到？执行sz，同样也没找到。安装lrzsz：# yum -y install lrzsz现在就可以正常使用rz、sz命令上传、下载数据了。使用方法：上传文件# rz filename下载文件# sz filename

mysql> show databases;  +--------------------+| Database           |+--------------------+| information_schema | | cluster              || mysql              | | test     ...

Logical Storage Hierarchy逻辑存储层级Figure 12-2 shows the relationships among data blocks, extents, and segments within a tablespace. In this example, a segment has two extents stored in different data files.图12-2显示了表空间在数据块，区和段之间的关系，例如，一个段有两个区被存储在不同...

Over time, performing insert, update, and delete operations (also referred to as DML operations) on objects within a tablespace can create pockets of empty space that individually are not big enough to be reused. Collectively, these pockets can waste large amounts of space. The sparsely populated ob...

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...