ITPub博客

分享阅读到的两则人生感悟：　　1、《生活总会给你答案》　　一个旅行者，在一条大河旁看到了一个婆婆，正在为渡水而发愁。已经精疲力竭的他，用尽浑身的气力，帮婆婆渡过了河，结果，过河之后，婆婆什么也没说，就匆匆走了。旅行者很懊悔。他觉得，似乎很不值得耗尽气力去帮助婆婆，因为他连“谢谢”两个字都没有得到...

character_set_system：存储标识符的字符集，始终为utf8character_set_server：服务器的 默认字符集collation_server：服务器的默认排序规则character_set_database：数据库的 默认字符集collation_database: 数据库的默认排序规则character_set_client：客户端向服务器发送sql语句时使用的字符集char...

mysql> select * from t2;+------+------+----------------------------+| a    | b    | c                          |+------+------+----------------------------+|    1 | aa   | aa1111111111111111111111...

问题：[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --basedir=/u01/app/mysql --datadir=/u01/app/mysql/dataInstalling MySQL system tables...2016-01-25 15:34:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server opti...

管理会计-ofsaa批处理时，作成本分摊的时候执行时间要很久，查看数据库等待事件为db file sequential read，简单描述一下此等待事件，如下：Wait Event: db file sequential readWait Class: User I/OData blocks are being read one at a time. Excessive time on this wait often signals unselective indexes or po...

drop table test01 purge;create table test01(emp_no number primary key,  --雇员号dep_no number,              --部门号sal number                  --薪水);--初始化四个雇员insert into test01 values(1,10,3000);i...

normal index---------------------SQL> create table t2 (a number,b varchar2(10 char));Table created.SQL> SQL> SQL> SQL> begin  2  for i in 1..100 loop  3  insert into t2 val...

1、主库备份主库controlfile autobackupbackup database;记录dbid将备份出来得文件传送到备库上。2、异地恢复[oracle@rac1 oracle]$ export ORACLE_SID=oradb1[oracle@rac1 oracle]$ rman target /Recovery ...

1、oradb1创建应用create tablespace test_data datafile '/home/oracle/oradata/oradb1/test_data01.dbf' size 500m autoextend off;create user magy identified by magy default tablespace test_data te...

[oracle@rac1 oracle]$ export ORACLE_SID=+ASM1[oracle@rac1 oracle]$ asmcmdASMCMD> help        asmcmd [-p] [command]        ...

[oracle@rac1 oracle]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 22 11:12:11 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to:Oracle Da...

session 1 执行如下脚本：SQL> begin  2  update t1 set a=10 where a=1;  3  dbms_lock.sleep(5);  4  update t2 set a=11 where a=2;  5  dbms_lock.sleep(5);&n...

select * from (select * from (select * from t1 where rownum <= 100 ) order by dbms_random.value) where rownum <=1;

select b.name,a.value/1024 from v$mystat a,v$statname bwhere a.statistic# = b.statistic#and b.name='redo size';begininsert /*+append nologging*/ into t1 select * from t1 where rownum <=10000;e...

--表空间置位只读alter tablespace data1 read only;--导出表空间元数据expdp system/password directory=dumpdir1 dumpfile=ts_trans_data1.dmp transport_tablespaces=data1 tablespace_full_check=Y--传...

--dml trigger-------------------------------------------------------------------------SQL> create or replace trigger tr_magy01   2  before  3  insert on t1  4  be...

--asm存储，删除一个数据文件[oracle@rac1 oracle]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 15 13:19:32 2013Copyright (c) 1982, 2005, Oracle.  All rights rese...

vgscanpvscanlvscanvgcreate vg00 /dev/sde1 /dev/sdf1 /dev/sdg1 lvcreate -n ... -i 8 -I 32 -L 4096 /dev/vgdata1lvcreate -n lvstrp01 -i 8 -I 8 -L 100 vg00pvcreate /dev/sdd1vgextend vg00 /dev/sdd1...

-- 数据缓冲区高速缓存SELECT physical_reads, db_block_gets, consistent_gets, NAME,    100 * ( 1 - ( physical_reads / (consistent_gets + db_block_gets - physical_reads))) "Data Bu...

exec dbms_stats.gather_table_stats('SCOTT','T1');exec dbms_stats.gather_table_stats('SCOTT','T1',stattab=>'STATIC_TABLE');exec dbms_stats.gather_index_stats('SCOTT','IDX_T1');exec dbms_stats.g...