NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS
165 取消限额



103 建立临时表空间

REVOKE UNLIMITED TABLESPACE FROM "hmtong"
14 显示SGA的信息
imp userid=system/oracle fromuser=gary touser=gary file=full.dmp log=imp.log
76 显示PGA的统计数
grant create session,create table,create view to edpthw;
ALTER TABLE A MOVE TABLESPACE USERS;
total PGA used for auto workareas 0 bytes

hash_area_size integer 1048576
54 显示当有用户可以访问表



9i查看文件$ORACLE_HOME/Apache/Apache/ports.ini显示端口
UPDATE_COMMENT
自动存档 禁用
shared pool MTTR advisory 21164
244 配置自动备份控制文件
SELECT OWNER,SEGMENT_NAME,BYTES FROM DBA_SEGMENTS WHERE SEGMENT_NAME='A';
ALTER DATABASE OPEN RESETLOGS;
ISADJUSTED
ALTER DATABASE MOUNT;
30 关闭Oracle Web Server
101 表空间改文件的自动扩展
java_max_sessionspace_size integer 0
pga_aggregate_target big integer 16777216
24 设定字符列格式
276 建立对象,允许可以用这个目录来导入导出

GRANT UNLIMITED TABLESPACE,CONNECT,RESOURCE TO "GARY";

db_keep_cache_size big integer 0
netca
drop tablespace mytbs1 including contents and datafiles;
69 显示日志文件
report schema;
26 10G查看文件$ORACLE_HOME/install/protlist显示端口
143 重命名列

select * from dba_data_files;
203 查看归档的路径的
106 创建临时表空间组
create pfile='c:init.ora' from spfile;
66 显示当前的选项
alter tablespace users begin backup;
select * from v$recover_file;
SELECT * FROM V$CONTROLFILE;
57 建立用户并指定密码

show parameter db_recovery_file_dest
select name,value/1024/1024 from v$sga;

connect / as sysdba
ALTER DATABASE DATAFILE 'D:ORADATAMYDBMYTBS_01.DBF' RESIZE 200M
sum(bytes)/1024/1024 m
261 2级备份累积备份
alter system set remote_login_passwordfile=shared scope=spfile; 只能sysdba登录,不能授权
5 在命令提示符以OS身份连接

alter tablespace temp add tempfile 'd:oradatamydbtemp01.dbf' size 10m reuse;
STARTUP NOMOUNT
alter table a allocate extent (datafile 'D:ORADATAMYDBusers01.dbf' size 1m);
java_pool_size big integer 33554432
51 显示当前实例 nomount状态下就可以查看实例
RECOVER TABLESPACE USERS;
248 备份数据文件

total PGA inuse 8293376 bytes


4 直接进入SQLPLUS命令提示符

ISDEFAULT
insert into a select * from a;

160 建立一个新用户
168 分别授权

shared pool message pool freequeue 834752

show parameter shared_pool_size

SELECT * FROM V$PARAMETER;
前面两个下划线的是动态调整的参数

tnsnames.ora: $ORACLE_HOME/network/admin/
211 查看最少路径归档数目的参数
ALTER DATABASE DATAFILE 6 OFFLINE;
show parameter background_dump_dest
cd $ORACLE_HOME/Apache/Apache/bin/
backup current controlfile;

create table b (a int,b varchar2(10)) tablespace users INITRANS 2 PCTFREE 5;


shared pool KQR M PO 586792

77 显示有哪些控制文件
select * from dba_rollback_segs;
shared pool PL/SQL MPCODE 135692
CREATE TABLE "SYS"."D" ( "A" VARCHAR2(10)) TABLESPACE "SYSTEM" PCTFREE 5 PCTUSED 60 INITRANS 2 MAXTRANS 100 STORAGE ( FREELISTS 2)
ALTER TABLE A SHRINK SPACE;
exp userid=system/oracle file=gary_a1.dmp tables=gary.a query='where owner=''GARY''' log=gary.LOG


10G CREATE BIGFILE TABLESPACE "MYTBS1" DATAFILE 'D:ORADATAMYDBmytbs_01.dbf' SIZE 100M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
SQL> show parameter log_archive_dest_x

alter user edpthw account lock;
167 授权用户
maximum PGA used for auto workareas 4096 bytes
116 查询段和表空间的对应关系
run {
db_16k_cache_size big integer 0
273 授权用户GARY
shared pool VIRTUAL CIRCUITS 265160
SELECT * FROM V$SGASTAT;

267 导出指定用户的表
SELECT * FROM V$DATAPUMP_JOB;
'D:ORADATAMYDBCONTROL03.CTL' SCOPE=SPFILE
105 设置成默认的表空间
266 导出数据到一个文件中

CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

create table a11 tablespace mytbs3 as select * from dba_objects;

/database/oracle/product/9i/Apache/Apache/bin/apachectl start: httpd started
drop user gary cascade;
connect target /
59 建立一个表
73 显示当前后台进程
ALTER TABLE A DROP UNUSED COLUMNS CHECKPOINT 10000;

CREATE INDEX A_NAME_IND ON A(OWNER,OBJECT_NAME);

select * from tab;
select * from user_tab_privs;

------------------------------------ ----------- ------------------------------
shared pool PL/SQL DIANA 420816
70 显示控制文件
130 重建表索引



268 查询任务
shared pool KGLS heap 901756
startup mount
'D:ORADATAMYDBCONTROL03.CTL',
48 显示PGA的状态
create_bitmap_area_size integer 8388608
CREATE SMALLFILE TABLESPACE "MYTBS1" DATAFILE 'D:ORADATAMYDBmytbs_01.dbf' SIZE 100M , 'D:ORADATAMYDBmytbs02.dbf' SIZE 100M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
total freeable PGA memory 0 bytes
18 将当前命令随加到文件中
SELECT 'ALTER INDEX '||INDEX_NAME||' REBUILD ONLINE;' FROM DBA_INDEXES WHERE TABLE_NAME='A' AND OWNER='SYS'

29 启动Oracle Web Server

select * from v$archived_log;
21 将输入保存到指定文件中

91 删除日志组成员
137 恢复已删除的表
save c:a.sql append
ARCHIVE LOG LIST;
181 查看系统特权

WINDOWS将生成在$ORACLE_HOME/DATABASE目录下
TRUNCATE TABLE A;
147 增加表的主索引
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "MYTEMP"

maximum PGA allocated 22090752 bytes
archive log list
252 列出所有的备份集
23 设定页大小
shared pool Checkpoint queue 282304

------------------------------------ ----------- -------------
NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)

SQLNET.AUTHENTICATION_SERVICES= (NTS,NONE)
194 追加设置一个服务名,服务名可以多个对应一个实例

POOL NAME BYTES
72 显示当前有哪些进程

SELECT 'ALTER INDEX '||INDEX_NAME||' COALESCE;' FROM DBA_INDEXES WHERE TABLE_NAME='A' AND OWNER='SYS'


backup database;

shared_pool_size big integer 50331648
$ lsnrctl stop



205 切换系统的下一个日志文件


GRANT CREATE TABLE TO "hmtong"
142 删除表的列


89 增加日志组
176 修改系统的授权的属性
SELECT * FROM V$SGA;
104 更改用户的临时表空间
select empno,ename from emp;

47 设置shared_pool_size的大小保存在SPFILE中
45 当前正在使用的SGA的大小

shared pool sql area 2144664

82 显示当前使用的日志
9I CREATE TABLESPACE "MYTBS1" DATAFILE 'D:oracleORADATAthwerpmytbs_01.dbf' SIZE 100M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

64 显示当前数据库信息
206 定义自动归档
121 高水位前移.速度快
large_pool_size big integer 8388608
shared pool type object de 69120
172 取消进入系统直接用默认密码,而一定要自己输入密码才可以进入
111 建立一个表

exp userid=system/oracle file=full1.dmp,full2.dmp,full3.dmp filesize=2g full=y direct=y log=full.log feedback=10000


49 带PFILE来启动资料库,?代表ORACLE的主目录
PGA memory freed back to OS 0 bytes
236 追加临时表空间
SELECT * FROM V$PROCESS;
22 设定行大小
shared pool fixed allocation callback 180
CREATE BITMAP INDEX A_NAME_BT ON A(OWNER);
select * from tab;
RESTORE CONTROLFILE FROM AUTOBACKUP;
:7778/isqlplus
239 在RMAN的指定位置来备份文件
object_cache_optimal_size integer 102400
204 动态的配置归档路径在两个不同的目录下同时归档
79 数据重新启动

CREATE TABLESPACE "MYTBS3" DATAFILE 'D:oracleORADATAthwerpmytbs3.dbf' SIZE 100M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO BLOCKSIZE 16384;
197 将SQLNET.ORA配置好就可以connect system/[email protected]:1521/testdb1方式连接

DESCRIPTION
数据库日志模式 存档模式



107 创建重做表空间
最早的概要日志序列 64


drop user hmtong cascade;
202 打开数据库


183 查看被授予的角色
232 恢复指字的数据文件
db_cache_size big integer 33554432
alter database backup controlfile to 'e:backupcontrol01.ctl';
lsnrctl start

132 在原地进行行的移动

174 授权sysdba给指定用户
alter system set log_archive_dest_state_2=defer;
95 显示表空间的已被使用多少

alter system set remote_login_passwordfile=NONE; 取消
41 显示动态性能视图的结构
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-1/24';

alter system set db_cache_size=128m scope=spfile;
@ c:a.sql



　　将原有的：SQLNET.AUTHENTICATION_SERVICES= (NTS)

shared pool event statistics per sess 1718360

ORACLE_SID%.ORA

alter table a deallocate unused;
222 查看曾经归档过的记录




208 查看曾经做过哪些归档及路径
select DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID),DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID),DBMS_ROWID.ROWID_ROW_NUMBER(ROWID) FROM A
select * from user_role_privs;
GRANT "CONNECT" TO "hmtong";

7 显示当然用户有哪些表
EXEC UTL_RECOMP.RECOMP_PARALLEL
169 折消授权
53 显示当有用户的表
156 显示当前数据库的用户
SELECT * FROM V$OPTION;


VALUE

over allocation count 0
148 删除表的主索引

TNSPING MYDB
SELECT * FROM V$LOGFILE
alter system set log_archive_dest_1='location=use_db_recovery_file_dest';

228 将指定的表文件设置成在线
207 查看数据库的归档的信息
revoke sysdba from hmtong;
----------- -------------------------- ----------
shared pool trigger source 448
名称
shared pool dictionary cache 1610880
shared pool kgl simulator 563260

28 关闭Oracle 9i监听程序
126 用包的命令查看表行的物理地址
90 增加日志组成员
spfile: $ORACLE_HOME/dbs
New password: *****
RECOVER DATABASE ;
131 设置行可以内部移动属性
40 显示正在使用的参数和文本参数值
SHOW PARAMETER CONTROL_FILES;

264 在RMAN的恢复控制文件




232 在注册表里的设置日期格式
cache hit percentage 100 percent
shared pool sessions 410720
19 将指定文件的命读出缓冲区
SELECT * FROM V$INSTANCE;
46 设置db_cache_size的大小保存在SPFILE
253 列出所有的汇总备份集
alter system set sga_max_size=256m scope=spfile; &&写入SPFILE,重启生效
select * from dba_extents where file_id=6;

SELECT * FROM V$DATABASE;

3 显示当前用户名


grant read,write on directory mydir to gary;
230 插入当前系统日期
184 查看角色的有什么权限
27 启动Oracle 9i监听程序
shared pool sim memory hea 44184
RECOVER DATABASE UNTIL TIME '2006-11-26 10:49:43';
255 删除备份集13
INSERT INTO TEST VALUES(SYSDATE);

define _editor=vi

NAME VALUE UNIT
186 查看当前会话的权限
:7778/isqlplusdba
150 建立一个普通索引
182 查看对象特权
shared pool KSXR receive buffers 1033000


98 在指字表空间里建表
140 清除垃圾桶
select * from v$datafile where file#=6;
NAME VALUE UNIT
155 显示所有用户的信息


shared pool parameters 8352
153 查询数据库的信息


151 建立一个函数索引


create table a tablespace users as select * from dba_objects;
ALTER SYSTEM SWITCH LOGFILE;

backup datafile 6;
SELECT * FROM V$DATAFILE;
270 查看导出的帮助信息
8 显示有用户名和帐户的状态
247 备份表空间
alter system set remote_login_passwordfile=exclusive; 能sysdba登录,能授权
grant sysdba to hmtong;
80 显示当前控制文件
workarea_size_policy string AUTO

监听器配置文件:listener.ora: $ORACLE_HOME/network/admin/

select * from user_tables;
58 给用户授权

224 查询指定表空间的文件路径
---------------------------------------------------------------- ---------- ---------

unix

233 恢复到指定的时间点

shared pool KQR S PO 180232
NAME TYPE VALUE
buffer_cache 33554432
report obsolete ;
NAME TYPE VALUE

show parameter local_listener
shared pool miscellaneous 4889396
imp userid=system/oracle fromuser=gary touser=wei file=gary.dmp log=imp.log
get c:a.sql
select * from v$archive;

CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
object_cache_max_size_percent integer 10
75 显示SGA的统计数
NAME
desc emp
228 生成创建控制文件的脚本

　　或者直接注释：#SQLNET.AUTHENTICATION_SERVICES= (NTS)
31 启动Oracle Web Server后默认的端口号是7777


default tablespace users
expdp userid=gary/gary dumpfile=gary directory=mydir PARALLEL=2 schemas=gary job_name=gary_job
show parameter block_size;
144 标记不可使用的列
select value/1024/1024 from v$parameter where name ='shared_pool_size';
$ ./startJServ.sh
total PGA allocated 13106176 bytes
SELECT /*+ INDEX(A A_NAME2_IND) */ * FROM A WHERE UPPER(OBJECT_NAME)='A';

71 显示当有有哪些会话
exp userid=system/oracle file=full.dmp full=y
log_buffer 656384
Adding password for user admin
Oracle的监听程序主要是为客户端的连接提供接口

NAME TYPE VALUE

select * from v$recovery_log;
ALTER DATABASE DROP LOGFILE GROUP 4 ;
create table a(a int);
225 将一个表空间设置成不可用
149 索引表的主索引并指定索引所使用的表空间

parallel_execution_message_size integer 2148
alter system set log_archive_format='mydb_%s_%r_%t.log' scope=spfile;
select * from dba_tablespaces;
219 查看数据库的归档模式
262 删除指定日期的归档日志
exp userid=system/oracle file=gary.dmp owner=gary,wei direct=y log=gary


shared pool FileOpenBlock 695504
/ as sysdba

SELECT /*+ INDEX(A A_NAME_BT) */ * FROM A WHERE OWNER='SYS' OR OWNER='SYSTEM';
STARTUP FORCE

SELECT DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME='用户名'
shutdown immediate

bytes processed 8783872 bytes
show parameter size
SELECT * FROM V$SESSION;

84 显示重做日志文件
133 查看表所存储的信息

118 指字参数建立表
246 配置可以恢复到7天内的保留窗口
select * from v$log_history;
extra bytes read/written 0 bytes
expdp userid=gary/gary attach=gary_job

$ORACLE_HOME/network/admin/listener.ora
存档终点 D:oracleora92RDBMS
connect system/xxxxxxx@服务名
67 显示当前实例的初始化参数

114 有条件查询段名放在哪个表空间
161 查询限额信息
　　改为:SQLNET.AUTHENTICATION_SERVICES= (NONE)

128 查看表的索引

129 移动重组表空间
226 结束生成备份表空间
192 动态注册监听器
java pool free memory 33554432
ALTER TABLE A ADD PRIMARY KEY (OBJECT_ID);

180 创建表
ALTER DATABASE DATAFILE 'D:ORADATAMYDBMYTBS03.DBF' AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED

archive log list
shared pool XDB Schema Cac 4966300
10 以SCOTT的身份连接并且查看所属表

select * from user_sys_privs;


170 对象授权
RESTORE DATABASE VALIDATE;
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
226 恢复指定表空间
SELECT USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE FROM DBA_USERS;
alter database backup controlfile to trace as 'e:backupcontrol01.sql';
263 在RMAN恢复指定表空间
SELECT * FROM V$CONTROLFILE;
show parameter remote_listener

desc v$parameter;
create table t1 (a int) tablespace mytbs1;

162 用户改密码
create table a tablespace users as select * from dba_objects;
GRANT CREATE ANY TABLE TO "hmtong"

SQL 'ALTER TABLESPACE USERS ONLINE';




alter system set control_files='D:oracleoradatathwerpCONTROL01.CTL',
shared pool subheap 46884
backup incremental level 0 tablespace users;
109 回滚段的使用情况
278 导出数据
oracle_trace_collection_size integer 5242880
235 恢复控制文件
backup tablespace users;

238 显示要备份的数据库文件

113 有条件查询表名放在哪个表空间
shared pool trigger inform 1140
truncate table a;
$ cd $ORACLE_HOME/Apache/Apache/bin

187 监听器的状态
260 增量备份时的0级备份一个表空间


list backupset 16
select distinct segment_type from dba_segments;
aggregate PGA target parameter 16777216 bytes


99 在指字表空间里建索引
select * from v$archived_log;
$ORACLE_HOME/network/admin/tnsname.ora

create user edpthw identified by "123456"
show parameter cache

141 删除表并清除垃圾桶(10G)
quota 10m on mytbs2;
97 创建表空间
recover datafile 6;

create table t1(a int);
GRANT SELECT ON "hmtong"."A" TO "edpthw"
ALTER TABLESPACE "MYTBS1" ADD DATAFILE 'D:ORADATAMYDBmytbs03.dbf' SIZE 100M
POOL NAME BYTES
DROP TABLE A CASCADE CONSTRAINTS;
272 重建用户GARY
245 配置有益度

db_2k_cache_size big integer 0


create table t2(a int);

124 生成一个测试表
221 查看归档文件

SELECT DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME=(select user from dual);

217 查看快速恢复区的使用情况
32 pfile: $ORACLE_BASE/admin/实例名/Pfile
show recyclebin
SELECT BYTES FORM DBA_SEGMENTS WHERE SEGMENT_NAME='A';


delete backup of tablespace users;
213 查改归档文件名的格式
230 查询指定文件号的详细信息
REVOKE SELECT ON "hmtong"."A" FROM "edpthw"
sort_area_retained_size integer 0
227 将指定的表文件设置成不可用
startup pfile=?databaseinitmydb.ora
190 配置监听器的工具

allocate channel ch1 type disk format 'e:rman%U.bak' maxpiecesize=2g;
select open_mode from v$database;

274 导入用户GARY的数据
257 凡是USERS的备份都删除

88 更改会语的日期格式
ALTER DATABASE ADD LOGFILE GROUP 4 ( 'D:ORADATAMYDBredo4.log') SIZE 10240K;
12 以OS的身份登看SGA,共享池,CACHE的信息
195 客户连接配置文件
global_context_pool_size string

$ cd $ORACLE_HOME/Apache/Apache/bin
POOL NAME BYTES
6 以SYSTEM的身份连接
shared pool trigger defini 1896
shared pool FileIdentificatonBlock 323292

38 用SPfile转Pfile
select * from database_properties where property_name like 'NLS_CHA%';


from dba_data_files group by tablespace_name;
alter database archivelog; 归档
lsnrctl start [名字]
shared pool joxs heap init 4220
81 删除一个控制文件
col sal format 999,999.999
total PGA used for manual workareas 0 bytes
ALTER TABLE A DROP COLUMN COMMENTS CASCAGE CONSTRAINTES CHECKPOINT 1000;
233 查询有没有指定的文件
CONFIGURE CHANNEL DEVICE type DISK clear;
138 恢复较早已前的已删除的表
78 增加一个控制文件一定要在NOMOUNT状态下进行.语句如下.
CREATE TEMPORARY TABLESPACE "MYTEMP" TEMPFILE 'D:oracleORADATAthwerpmytemp01.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M


123 指定参数建立表
171 折消对象授权
256 不提示删除所有的备份集
select * from dba_users;



139 查询指定表的索引
:5560/isqlplus
110 更改重做表空间
271 删除gary的用户
delete noprompt backupset;
------------------------------------ ----------- ------------------------------
119 显示当前所使用的块大小
122 分配空间给表
select * from dba_extents where segment_name='A' and owner='SYS';


select * from role_tab_privs;
ALTER TABLE A SET UNUSED COLUMN COMMENTS CASCADE CONSTRAINTS;
select * from v$recovery_file_dest;
background_dump_dest string D:oracleadminthwerpbdump
select * from v$pgastat;

alter user edpthw identified by edpthw;
list backupset summary;
231 查询TEST的值
SELECT * FROM DBA_RECYCLEBIN;
DROP TABLE A PURGE;


33 指定用户的表空间
92 删除日志组


下一个存档日志序列 69

}


windows
127 建立表索引
show parameter log_archive_format
ALTER DATABASE DROP LOGFILE MEMBER 'D:ORADATAMYDBredo14.log' ;
set linesize 2000
259 边备份边压缩数据库
exp userid=system/oracle file=gary.dmp owner=gary direct=y log=gary.log
209 查看有哪还没有做归档的信息


alter database noarchivelog; 非归档
188 监听器的启动和关闭
col ename format a30
NAME TYPE VALUE
SELECT * FROM DBA_USERS;
cd D:oracleora92ApacheApachebin
sga_max_size big integer 143727516
135 删除表
ALTER TABLESPACE USERS OFFLINE IMMEDIATE
'D:ORADATAMYDBCONTROL02.CTL',
'D:ORADATAMYDBCONTROL02.CTL',

GRANT SELECT ANY TABLE TO "hmtong"




select * from user_ts_quotas;
alter user scott account unlock(lock);

bitmap_merge_area_size integer 1048576

'E:CONTROL04.CTL' SCOPE=SPFILE;
show all;

from dba_free_space group by tablespace_name;

select tablespace_name,sum(bytes)/1024/1024 m
251 备份当前的控制文件

select object_name,object_type,owner from dba_objects where status='INVALID';
show sga

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'E:RMAN%U.BAK' MAXPIECESIZE 2G;
select user from dual;show user


alter system set control_files='D:ORADATAMYDBCONTROL01.CTL',

193 配置监听器的两个参数

269 导出指定表
alter system set large_pool_size=16M;
backup archivelog until time 'sysdate-1';
216 更改快速恢复区的路径

select * from v$pwfile_users;
htpasswd $ORACLE_HOME/sqlplus/admin/iplusdba.pw admin




1 运行SQLPLUS工具
163 锁用户
220 查看归档文件的归档路径
select username,account_status from dba_users;

CREATE USER "GARY" PROFILE "DEFAULT" IDENTIFIED BY "GARY" ACCOUNT UNLOCK


shared pool free memory 38687204
RECOVER TABLESPACE USERS;
212 查看归档路径的文件名格式参数

35 当前用户的缺省表空间
SELECT * FROM USER_RECYCLEBIN;



$ ./stopJServ.sh
NAME TYPE VALUE
233 创建一个例子表

SHOW PARAMETER CONTROL
CREATE TABLE TEST (A DATE);
delete backupset 13;

96 显示表空间还有多少没有使用
show parameter log_archive_dest
210 设置归档路径2暂时不归档和启用归档
42 有条件的显示动态参数
recover AUTOMATIC datafile 6;
db_8k_cache_size big integer 0
185 查看角色的有哪些表
alter system set shared_pool_size=80m scope=spfile;
shared pool character set object 323724
SELECT * FROM V$VERSION;
RESTORE TABLESPACE USERS;
shared pool library cache 2985576
exp -help
ISMODIFIED
alter system set db_recovery_file_dest_size=10g;
145 删除不再使用的的列

PURGE DBA_RECYCLEBIN;
229 创建一个测试表
154 生成一个脚本来建立索引重整

show parameter db_recovery_file_dest_size
alter system set sga_max_size=256m scope=memory; &&写入内存区,立即生效
select * from v$pgastat;
198 快速重启资料库

86 发出检查点
show parameter log_archive_min_succeed_dest

shared pool KSXR pending messages que 841036
100 修改表空间的大小
25 设定数字列格式
55 显示用户为SCOTT的表
234 打开资料库并重置重做日志
224 自动找到归档日志恢复相应数据文件
102 删除表空间和表空间所属文件
177 重建口令文件
249 备份前一天的重做日志
select * from session_privs;


shared_pool_reserved_size big integer 2516582
ALTER TABLESPACE MYTEMP TABLESPACE GROUP MYTEMP_GROUP
277 授权用户的权限
SELECT * FROM TEST;
flashback table "BIN$hWrBq1irS0COp10n22NZJg==$0" to before drop rename to a1;
214 显示出快速恢复区的大小和路径
shared pool KGK heap 3756

shared pool 1M buffer 2098176
SELECT * FROM V$BGPROCESS;


231 查询有哪些需要归档
select * from dba_tables where table_name='A' and owner='SYS';
sqlplus
select log_mode from v$database;
50 显示当前数据库的状态,mount的状态下就可以查看数据库的状态
196 检查指定的监听器是否存在
15 显示PGA的信息
146 继续列的删除操作
243 配置并行数
unix $ORACLE_HOMENETWORKADMINSQLNET.ORA
quota unlimited on users
create user edpthw identified by edpthw;
create user hmtong identified by abcdefg;
125 查看表行的物理地址
178 创建一个用户
223 启动在线备份表空间

237 Rman的连接
44 动态调整large_pool_size的语句
SELECT * FROM DBA_SEGMENTS WHERE SEGMENT_NAME='A_IND';

connect scott/tiger
39 显示cache的值

ALTER SYSTEM CHECKPOINT;


215 更改归档路径到到快速恢复区
225 在SQL状态上暂时离开返回到SHELL

SELECT * FROM V$LOG;
show parameter undo
htpasswd D:oracleora92/sqlplus/admin/iplusdba.pw admin

show user
115 查询有哪些段类型
select rowid form a;
227 备份数据库的控制文件
alter system set log_archive_dest_1='location=e:archive';
netmgr

POOL NAME BYTES
93 显示系统表空间所拥有的文件
------------------------------------ ----------- ------------------------------

}
aggregate PGA auto target 7640064 bytes
269 导入数据
select * from v$archive_dest;
TYPE
RECOVER DATABASE using backup controlfile UNTIL cancel;

select * from dba_temp_files;
ALTER INDEX A_IND REBUILD;


select * from v$archive;
ALTER DATABASE DATAFILE 6 ONLINE;
shared pool table definiti 1728
CONFIGURE CONTROLFILE AUTOBACKUP on;
85 手工切换重做日志文件

112 插入一些记录
SELECt * FROM DBA_INDEXES WHERE TABLE_NAME='A';



258 列出哪些不需要的备份集

GRANT UNLIMITED TABLESPACE,CONNECT,RESOURCE TO HMTONG;
56 显示所有用户信息

ISSES_MODIFIABLE
254 列出具体的备份信息
select * from v$sga;
134 截取表
alter system set log_archive_dest_state_2=enable;
lsnrctl stat
173 查询Pwfile中存放的用户信息
maximum PGA used for manual workareas 4096 bytes
CONFIGURE RETENTION POLICY TO recovery window of 7;
152 建立一个位图索引
136 显示垃圾桶(10G才有)
ALTER TABLE A ENABLE ROW MOVEMENT;
ALTER TABLE A ADD PRIMARY KEY (OBJECT_ID) USING INDEX TABLESPACE USERS;
create table C (a int) tablespace system pctfree 10 pctused 60 storage(freelists 2);


120 释放表的高水位的空间
ALTER TABLE A DROP COLUMNS CONTINUE CHECKPOINT 10000;
94 显示系统临时表空间

241 配置缺省的路径
alter system set log_archive_dest_2='location=d:archive';
229 查询哪个文件需要恢复

select * from v$instance;
189 监听器的状态和服务信息

166 删除用户
create index t1_ind on t1(a) tablespace mytbs1;
alter system set sga_max_size=256m scope=both; &&即写入内存区,又写入SPFILE,默认为BOTH.

flashback table a to before drop;
----------- -------------------------- ----------

199 将资料库开启到mount的状态
SQLNET.AUTHENTICATION_SERVICES= (NTS,NONE)

------------------------------------ ----------- -------------
100 在指定表空间里增加数据文件
large pool free memory 8388608
sqlplus /nolog
select value/1024/1024 from v$parameter where name ='db_cache_size';



db_recycle_cache_size big integer 0
grant connect,resource to edpthw;
backup spfile;
select * from dba_indexs where table_name='A';
alter database open resetlogs;
当前日志序列 69

select * from dba_segments where segment_name='A' and owner='SYS';
backup incremental level 2 cumulative tablespace users;
240 在RMAN的显示威者默认设置
impdp userid=system/oracle dumpfile=gary directory=mydir job_name=gary_job
olap_page_pool_size integer 33554432
select * from all_tables;
alter system set log_archive_start=true scope=spfile; (9i)(10G不用设)
spool c:O.LOG
db_4k_cache_size big integer 0
select * from role_sys_privs;
60 显示数据字典中表名为USER开头的表名
select * from v$spparameter;


host ocopy user*.dbf e:backup
max_dump_file_size string UNLIMITED
92 显示系统表空间
37 显示正在使用的初始化参数文件
已选择16行。
11 查看EMP的表结构及记录内容

select tablespace_name,
backup as compressed backupset database;
'D:oracleoradatathwerpCONTROL03.CTL',
179 授权连接给指定用户


show parameter db_cache_size
GRANT DROP ANY TABLE TO "hmtong"
---------------------------------------------------------------- ---------- ---------

265 查询数据库的字符集
spool off
spfile string %ORACLE_HOME%DATABASESPFILE%
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
218 更改快速恢复区的大小
43 修改参数语句

alter database open;

2 以OS的默认身份连接
shared pool PLS non-lib hp 2068
61 在UNIX下oerr ora 错误号查看错误的帮助信息.
windows D:oracleproduct10.1.0Db_1NETWORKADMINSQLNET.ORA
lsnrctl service
imp userid=system/oracle fromuser=gary touser=gary show=y
alter tablespace users end backup;
268 导出指定表
83 显示实例的归档模式
alter user edpthw quota unlimited on mytbs2;
alter system register;
alter system set control_files='D:ORADATAMYDBCONTROL01.CTL',

63 显示当前实例
20 执行脚本语句


shared pool KQR S SO 5128
select * from v$sgastat;
select file_name from dba_data_files where tablespace_name='USERS';
backup database;
修改$ORACLE_HOME/network/admin/sqlnet.ora文件
create directory mydir as 'e:expdata';

242 清除缺省配置
68 显示数据文件
db_block_size integer 4096
alter system set undo_tablespace=myundo;

orapwd file=PWDmydb.ora password=itpub

select sum(bytes)/1024/1024 from v$sgastat;


select * from v$log;
grep ORA alert_PROD.log|tail -10
UNIX将生成在$ORACLE_HOME/dbs目录下
/database/oracle/product/9i/Apache/Apache/bin/apachectl stop: httpd stopped
select * from dba_ts_quotas;



show parameter spfile

set line 2000
----------- -------------------------- ----------
SELECT /*+ FULL(A) */ * FROM A WHERE OWNER='SYS' OR OWNER='SYSTEM';
52 显示 background_dump_dest的路径 ,
275 查询状态
SELECT * FROM V$PGASTAT;

alter user edpthw password expire;
lsnrctl stop [名字]
9 将SCOTT帐号解锁(加锁)
前面一个下划线的是内部参数


62 在unix 查看日志中有哪些错误
fixed_sga 453532
alter system switch logfile; (10G就会产生归档文件)
'D:oracleoradatathwerpCONTROL04.CTL' scope=spfile;
alter system set service_names=mydb,appdb
CREATE SMALLFILE TEMPORARY TABLESPACE "MYTEMP" TEMPFILE 'D:oracleORADATAthwerpmytemp01.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
RUN {

ALTER TABLE A DROP PRIMARY KEY;
175 取消指定用户的sysdba权限
create pfile from spfile;
select * from v$parameter;
34 当前用户
201 在数据库mount的状态下更改数据库的归档模式

select * from v$parameter where name like '%db_cache%';
17 在$ORACLE_HOME/sqlplus/admin/glogin.sql中加入环境变量,以后每次启动生效
'D:oracleoradatathwerpCONTROL02.CTL',

list backupset ;
NUM
alter system set db_recovery_file_dest='e:recover';
CREATE UNDO TABLESPACE "MYUNDO" DATAFILE 'D:ORADATAMYDBmyundo01.dbf' SIZE 200M
164 使密码过期,迫使改下一次进入改密码
ALTER TABLESPACE TEMP TABLESPACE GROUP MYTEMP_GROUP
87 显示重做日期的历史记录
show parameter pga





65 显示当前ORACLR资料的版本
select table_name from dict where table_name like 'USER%';
SELECT * FROM V$LOGFILE;


select * from dba_tables where owner='SCOTT';
$ lsnrctl start
74 显示SGA的大小
ALTER USER "GARY" TEMPORARY TABLESPACE "MYTEMP"
108 显示重做参数

SQL 'ALTER TABLESPACE USERS OFFLINE IMMEDIATE';
temporary tablespace temp
ALTER TABLE A RENAME COLUMN HIRE_DATE TO START_DATE;
ALTER DATABASE ADD LOGFILE MEMBER 'D:ORADATAMYDBredo11.log' TO GROUP 1;
Re-type new password: *****
已选择42行。
db_32k_cache_size big integer 0



sort_area_size integer 524288

200 显示数据库的归档还是非归档模式
117 建立一个16K表空间
250 备份SP文件
ISSYS_MODIFIABLE
exp userid=system/oracle file=gary_a.dmp tables=gary.a direct=y log=gary
13 查看所有含有SIZE的信息
set pagesize 10
PURGE RECYCLEBIN;
connect / as sysdba

----------- -------------------------- ----------
global memory bound 838656 bytes
CREATE INDEX A_IND ON A(OBJECT_NAME) TABLESPACE MYTBS2;