ITPub博客

1. Logon sqlplus as sys2. drop user sysman cascade;3. drop role MGMT_USER;4. drop user MGMT_VIEW cascade;5. drop public synonym MGMT_TARGET_BLACKOUTS;6. drop public synonym SETEMVIEWUSERCONTEXT;7. exit sqlplus8.emca -config dbcontrol db -repos recreate[@more@]

[oracle@localhost ~]$ EMDROOT=$ORACLE_HOME[oracle@localhost ~]$ EMSTATE=$ORACLE_HOME[oracle@localhost ~]$ export EMDROOT EMSTATE[oracle@localhost ~]$ emdctl validateTZ agent US/EasterntzOffset for US/Eastern is -300(min), but agent is runnning with tzOffset -240(min)trying again after waiting for 1 sec to account for daylight transitiontzOffset for US/Eastern is -300(min), but agent is runnning with tzOffset -240(min)......after u see the above statements...run the following statements....make s

delete from mao.aALTER TABLE mao.A SHRINK SPACEalter table mao.a enable row movementanalyze table a compute statisticsselect * from DBA_TABLES s where S.TABLE_NAME='A'SELECT * FROM DBA_EXTENTS T WHERE T.segment_name='A'[@more@]

Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 st1:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.

1. 先建立所需要的群组 ( vi /etc/group )； 2. 将 /etc/group 与 /etc/gshadow 同步化 ( grpconv )； 3. 建立帐号的各个属性 ( vi /etc/passwd )； 4. 将 /etc/passwd 与 /etc/shadow 同步化 ( pwconv )； 5. 建立该帐号的密码 ( passwd accountname )； 6. 建立使用者家目录 ( cp -a /etc/skel /home/accountname )； 7. 更改使用者家目录的属性 ( chown -R accountname.group /home/accountname )。 [@more@]

create or replace procedure show_space( p_segname in varchar2,p_owner in varchar2 default user,p_type in varchar2 default 'TABLE',p_partition in varchar2 default NULL )-- this procedure uses authid current user so it can query DBA_*-- views using privileges from a ROLE and so it can be installed-- once per database, instead of once per user that wanted to use it authid current_useras l_free_blks number; l_total_blocks number; l_total_bytes

　　alter table move跟shrink space的区别 　　主要从两点说他们的区别： 　　1. 碎片的整理 　　2.空间的收缩 　　SQL> select * from v$version; 　　BANNER 　　-------------------------------------------------- -------------- 　　Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi 　　PL/SQL Release 10.2.0.1.0 - Production 　　CORE 10.2.0.1.0 Production 　　TNS for Linux: Version 10.2.0.1.0 - Production 　　NLSRTL Version 10.2.0.1.0 - Production 　　SQL> 　　创建测试表 　　SQL> c

http://psoug.org/reference/library.html[@more@]

Step 1: Prepare the MS-Access environment If you do not have a MS-Access environment, start by installing the required software and create a test table. Step 2: Define ODBC connectivity Use the ODBC Administrator Utility to define a local System DSN that can be used to connect to the Access database (same machine). Ensure that the correct *.MDB database file is selected. Step 3: Prepare the Oracle Environment Install the Oracle Database Server software on the same machine where MS-Access is inst

1. /*+ALL_ROWS*/ 表明对语句块选择基于开销的优化方法,并获得最佳吞吐量,使资源消耗最小化. 例如: SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN FROM BSEMPMS WHERE EMP_NO='SCOTT'; 2. /*+FIRST_ROWS*/ 表明对语句块选择基于开销的优化方法,并获得最佳响应时间,使资源消耗最小化. 例如: SELECT /*+FIRST_ROWS*/ EMP_NO,EMP_NAM,DAT_IN FROM BSEMPMS WHERE EMP_NO='SCOTT'; 3. /*+CHOOSE*/ 表明如果数据字典中有访问表的统计信息,将基于开销的优化方法,并获得最佳的吞吐量;如果数据字典中没有访问表的统计信息,将基于规则开销的优化方法

You cannot do 'alter database datafile ... offline' if you are in noarchivelog (but tablespace offline works) You cannot do 'alter tablespace ... offline' if database is read-only (but datafile offline works)[@more@]

redo--> undo-->datafile insert一条记录时，表跟undo的信息都会放进 redo 中，在commit 或之前， redo 的信息会放进硬盘上。 故障时， redo 便可恢复那些已经commit 了的数据。 redo-> 每次操作都先记录到redo日志中，当出现实例故障（像断电），导致数据未能更新到数据文件，则数据库重启时须redo，重新把数据更新到数据文件。 undo-> 记录更改前的一份copy，但你系统rollback时，把这份copy重新覆盖到原来的数据 redo->记录所有操作，用于恢复（redo records all the database transaction used for recovery） undo-&g

alter system set events相关知识：格式：alter system|session set events ‘[eventnumber|immediate] trace name eventname [forever] [, level levelnumber] : …….’通过:符号，可以连续设置多个事件，也可以通过连续使用alter session set events来设置多个事件。格式说明：eventnumber指触发dump的事件号，事件号可以是Oracle错误号（出现相应错误时跟踪指定的事件）或oralce内部事件号，内部事件号在10000到10999之间，不能与immediate关键字同用。immediate关键字表示命令发出后，立即将指定的结构dump到跟踪文件中，这个关键字只

UNDOselect dbms_flashback.get_system_change_number from dual;update a set name='kerry' where id=1select * from a as of scn 784613 where id=1alter table a enable row movementflashback table a to scn 784613 select versions_starttime, versions_endtime, versions_xid, versions_operation, c1from flashback_test versions between timestamp minvalue and maxvalueorder by VERSIONS_STARTTIME ;SELECT UNDO_SQL FROM FLASHBACK_TRANSACTION_QUERY WHERE XID = hextoraw('03002300C7040000') ;[@more@]

LogMiner提供了一个处理重做日志文件并将其内容翻译成代表对数据库的逻辑操作的SQL语句的过程。LogMiner运行在Oracle版本8.1或者更高版本中。 一，如何使用Logminer: 先要安装logminer的两个包；以SYS用户运行下面两个脚本,其中第一个脚本dbmslm.sql用来创建DBMS_LOGMNR包，该包用来分析日志文件。第二个脚本dbmslmd.sql用来创建DBMS_LOGMNR_D包，该包用来创建数据字典文件。 D:oracleproduct10.2.0db_1RDBMSADMIN>sqlplus /nologSQL*Plus: Release 10.2.0.4.0 - Production on星期五4月10 17:49:02 2009Copyright (c) 1982, 2007,

nls参数、环境变量以及函数起作用的顺序如下(由低到高) instance级参数--->nls_lang--->session级参数--->函数 alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss'; alter session set nls_language[@more@]

alter system set statistics_level=typical (ALL, basic) scope=both(memory, spfile);--注意，当 sga_target不等于0，即SGA不自动管理时，不能用以上命令，否则会报错。这时要运行METALINK提供的脚本dbmsnoawr.plb创建package: dbms_awr,接着exec dbms_awr.disable_awr;select snap_id,dbid,instance_number from dba_hist_snapshot;select dbms_workload_repository.awr_report_text('2027229153',1,7,10,0) from dual;[@more@]

用oracle trace 来跟踪session =========================================================== 作者: tolywang(http://tolywang.itpub.net)发表于:2007.11.21 08:57分类: Oracle数据库管理 出处：http://tolywang.itpub.net/post/48/414520--------------------------------------------------------------- 1.在数据库安装的电脑上,使用SQL plus 用 SYSDBA 身份连接到数据库.2.找到要进行跟踪的会话.select sid,serial#,username from v$session ;3.启用相关会话的SQL trace .exec dbms_system.set_sql_trace_in_session(7,284,true)4.从

EVENT: 10046 "enable SQL statement tracing (including binds/waits)" [ID 21154.1] Modified 11-NOV-2007 Type REFERENCE Status PUBLISHED Event:10046 Text: enable SQL statement timing ------------------------------------------------------------------------------- For details of interpreting 10046 output see: Note:39817.1 Explanation: This is a special EVENT code. It can be used to signal Oracle to perform SQL_TRACE type actions. The 10046 tr

select t.sql_text from v$process s, v$session n,v$sqltext t where s.spid=18740 and n.PADDR = n.PADDR and n.SQL_ADDRESS=t.ADDRESS order by t.ADDRESS[@more@]