你们都是我的客户，所以，我对你们是透明的
发布时间：2016-03-18 15:06:45
一、创建测试用户sa以及一系列测试表，并插入不同量的数据SQL> create user sa identified by oracle;User created.SQL> grant resource ,connect to sa;Grant succeeded.SQL> conn sa/oracleConnected.SQL> create table a1 (id number,a varchar2(4));Table created.SQL> create table aa1 (id number,a varc.........【阅读全文】
发布时间：2016-03-16 16:06:04
生产备份run{allocate channel ch1 type disk;sql 'alter system archive log current';backup as compressed backupset database format '/oracle/backups/hisdb_%T_%U';sql 'alter system archive log current';backup as compressed backupset archivelog all format '/oracle/backups/hisarc_%T_%U';backup curr.........【阅读全文】
发布时间：2016-03-16 14:30:27
数据库不要关闭SQL> select file#,name from v$datafile; FILE# NAME---------- ---------------------------------------- 1 /oracle/oradata/orcl/system01.dbf 2 /oracle/oradata/orcl/.........【阅读全文】
发布时间：2016-03-09 14:57:07
一、pfile[oracle@10g dbs]$vi inithis.orahis.__db_cache_size=138412032his.__java_pool_size=50331648his.__large_pool_size=4194304his.__shared_pool_size=163577856his.__streams_pool_size=0*.audit_file_dest='/oracle/admin/his/adump'*.compatible='10.2.0.1.0'*.c.........【阅读全文】
