ITPub博客

环境：OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production1、查看临时表空间信息：select tablespace_name,file_name,bytes/1024/1024 file_size,autoextensible from dba_temp_files;TABLESPACE FILE_NA...

SELECT TO_CHAR(s.sid)||','||TO_CHAR(s.serial#) sid_serial,NVL(s.username, 'None') orauser,s.program, r.name undoseg,t.used_ublk * TO_NUMBER(x.value)/1024/1024||'M' "Undo"FROM sys.v_$rollname r,sys.v_$session s,sys.v_$transaction t,sys.v_$parameter xWHERE s.taddr = t.addr AND r.usn = t.xidusn...

OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production首先创建yoon数据库SQL> create tablespace yoon datafile '/u01/oracle/oradata/yoon/yoon01.dbf' size 50m;Tablespace created.SQL> create user...

RMAN> restore validate controlfile;Starting restore at 21-NOV-13using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=71 device type=DISKchannel ORA_DISK_1: starting validation of datafile backup setchannel ORA_DISK_1: readin...

OS:ORACLE-LINUX 5.71、下载"install_flash_player_11_linux.i386.tar.gz" 包2、自己创建个目录，解压[root@b28-122 flash]# tar -xvf install_flash_player_11_linux.i386.tar.gz3、查找插件目录[root@b28-122 mozilla]# find / -name mozilla/usr/lib64/mozilla/usr/share/mozil...

OS:ORACLE-LINUX 5.7DB：11.2.0.3[oracle@b28-122 ~]$ emctl status dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.3.0Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.https://b28-122.jd.com:1158/em/console/aboutApplicationOracle E...

约束是表中列的属性，用来维护数据结构完整性的一种手段约束的种类：NOT NULLUNIQUEPARIAMRY KEYFOREIGN KEYCHECKenble validate 检查现有数据和新数据是否符合约束enable novlidate 检查新数据是否符合约束disable validate 给表加锁disable novalidate 创建表的时候带有约束信息:create table e...

Oracle数据库表空间使用量查询：select b.file_name 物理文件名,b.tablespace_name 表空间,b.bytes/1024/1024 大小M,(b.bytes-sum(nvl(a.bytes,0)))/1024/1024 已使用M,substr((b.bytes-sum(nvl(a.bytes,0)))/(b.bytes)*100,1,5) 利用率from dba_free_space a,dba_data_files bwhere a.file_id=b.file_idg...

查看所有用户分区表及分区策略(1、2级分区表均包括)：SELECT p.table_name AS 表名, decode(p.partitioning_key_count, 1, '主分区') AS 分区类型,p.partitioning_type AS 分区类型, p.column_name AS 分区键,decode(nvl(q.subpartitioning_key_count, 0), 0, '无子分区', 1, '子分区') AS 有无子分区,q.subpartit...

OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production添加控制文件：1.修改参数文件alter system set control_files = '/u01/oracle/oradata/yoon/control01.ctl','/u01/oracle/oradata/yoon/control03.ctl' scope=spfile;...

1、查看oralce是归档模式还是非归档模式SQL> select name,log_mode from v$database;NAME LOG_MODE---------------------------------------- ------------------------------------YOON ARCHIVELOGSQL> select name,log_mode from v$database;NAME LOG_MODE------------------------------------...

OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production1、查看监听状态：SQL> !lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 12-NOV-2013 01:36:29Copyright (c) 1991, 2011, Oracle. All ...

jdbc 连接 oracle rac 的连接串如下：jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.210.100)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = devdb)))

OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production一、在rman下启动和关闭数据库RMAN> shutdown immediateRMAN> startup二、现实rman默认配置信息RMAN> show all;RMAN configuration parameters for...

set linesize 132　　column name format a30　　column value format a25　　select　　x.ksppinm　name,　　y.ksppstvl　value,　　y.ksppstdf　isdefault,　　decode(bitand(y.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE')　ismod,　　decode(bitand(y.ksppstvf,2),2,'TRUE','FALSE')　isadj　　from　...

OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 -64bit Production查看rman是否开启自动备份控制文件RMAN> show all;RMAN configuration parameters for database with db_unique_name YOON are:CONFIGURE RETENTION POLICY TO REDUNDA...

在itpub中看到下面的问题：oracle 10g备份脚本如下run{allocate channel d1 device type disk MAXPIECESIZE=100M;crosscheck archivelog all;delete noprompt expired archivelog all;backup full tag '3Gfull' database include current controlfile format '/vm_svn/rmanback/fullback_%d_%T_s%s_p%p' plusa...

1、进去指定schema 数据库（存放了其他的数据库的信息）mysql> use information_schema;2、查询所有数据的大小mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES;3、查看指定数据库实例的大小，比如说数据库 yoon mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB')...

一、用户查看当前用户的缺省表空间SQL> select username,default_tablespace from user_users;USERNAME DEFAULT_TABLESPACE------------------------------ ------------------------------SCOTT USERS查看当前用户的角色SQL> select * from user_role_privs;USERNAME GRANTED_ROLE ADMIN_OP...

OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production数据库打开模式，非归档模式，非当前日志损坏SQL> archive log list;Database log mode No Archive ModeAutomatic archival DisabledArchive destination USE_DB_RECOVER...