--查所有表的索引SELECT T.TABLE_NAME, --表名T.INDEX_NAME, --索引名I.UNIQUENESS, --是否非空I.INDEX_TYPE, --索引类型C.CONSTRAINT_TYPE, --键类型WM_CONCAT(T.COLUMN_NAME) COLS,(CASEWHEN C.CONSTRAINT_TYPE = 'P' OR ...

 --1.添加测试数据create table tmp asselect 'A1' as a, 'B1' as b from dual union allselect 'A2' as a, 'B2' as b from dual union allselect 'A3' as a, 'B3' as b from dual union allselect 'A4' as a,...

系统查询很慢或索引慢 Enter user-name: conn /as sysdbaEnter password:3、打开数据库SQL> alter database open;alter database open4、查日志SQL> select group#,sequence#,archived,status from v$log;    ...

SYS开启JOB进程数ALTER SYSTEM SET job_queue_processes = 20;commit;启动JOB系统服务/* 查询:select job,broken,what,interval,t.* from user_jobs t; job job的唯一标识，自动生成的   broken 是否处于运行状态，N;运行；Y:停止   what...

切换到$ORACLE_HOME/bin目录下，修改文件oratab[root@ST ~]# vi /etc/oratab # This file is used by ORACLE utilities. It is created by root.sh# and updated by either Database Configuration Assistant while cre...

1. 创建备份文件 vi bak.sh#!/bin/bashexport ORACLE_BASE=/home/server/appexport ORACLE_HOME=/home/server/app/server/product/11.2.0/dbhome_1export ORACLE_SID=orcl export ORACLE_TERM=xtermexport PATH=$O...