• 博客访问: 4851054
  • 博文数量: 857
  • 用 户 组: 普通用户
  • 注册时间: 2007-12-07 15:08
  • 认证徽章:

了解并联系warehouse: http://blog.itpub.net/19602/viewspace-1059211/



















发布时间:2009-06-25 14:47:23


阅读(3191) | 评论(0) | 转发(0)

发布时间:2009-06-24 23:51:40

困扰了很久的一个问题![@more@]SQL> create table tt(id int , name varchar2(20)) tablespace users;表已创建。SQL> insert into tt values(1,'a');已创建 1 行。SQL> insert into tt values(2,'aa');已创建 1 行。SQL> insert into tt values(2,'aaa');已创建 1 行。SQL> insert into tt values(2,'aaaa');已创建 1 行。SQL> insert into tt values(2,'aaaaa');已创建 1 行。SQL> insert into tt values(2,'aaaaaa');已创建 1 行。SQL> insert into tt values(2,'aaaaaaa');已创建 1 行。SQL> insert into ......【阅读全文】

阅读(3487) | 评论(0) | 转发(0)

发布时间:2009-06-24 22:56:14

我们知道mts下存在多个process为一个session服务的情况,这样如果想开启该session的trace功能,那么产生的trace文件势必就有多个文件,如何把这个多个文件中的session信息提取出来就显的尤为重要,oracle提供的trcsess工具可以帮助我们,通过trcsess处理之后的tracefile就可以通过tkprof继续处理了。[@more@]SQL> select distinct sid from v$mystat;SID----------138SQL> select saddr,paddr,server,sid,serial# from v$session where sid=138;SADDR PADDR SERVER SID SERIAL#-------- -------- --------- ---------- ----------69......【阅读全文】

阅读(3383) | 评论(0) | 转发(0)

发布时间:2009-06-24 20:57:28

之前的版本貌似都放在了udump中...[@more@]SQL> select distinct sid from v$mystat; SID---------- 159SQL> select paddr,server from v$session where sid=159;PADDR SERVER-------- ---------6964C00C SHAREDSQL> alter session set sql_trace=true;会话已更改。SQL> select name,paddr from v$shared_server where paddr='6964C00C';NAME PADDR---- --------S000 6964C00CSQL> select pid,spid from v$process where addr='6964C00C'; PID SPID---------- ------------ 14 544SQL> sel......【阅读全文】

阅读(3051) | 评论(0) | 转发(0)

发布时间:2009-06-24 20:54:36

主要是验证一下block内部的一个"fb"标志The ‘fb’ value gives us flags about the row. ‘H’ means that we have the head of the row. ‘F’ means that we have the first piece of the row. ‘L’ means we also have the last piece of the row. Since this is the first and last piece of the row, the row is not chained. Since this is also the head of the row, the row has not been migrated.[@more@]SQL> create table tt(a char(2000),b char(2000),c char(2000) , d char(2000) ,e char(2000)) tablespac......【阅读全文】

阅读(145057) | 评论(0) | 转发(0)

发布时间:2009-06-24 18:01:29

可以利用下面的脚本获得tracefile name,在11g可以非常方便的获得,其他版本相对比较麻烦。在oradebug中也很容易获得。[@more@]select pa.value ||decode(d.PLATFORM_NAME,'Microsoft Windows IA (32-bit)','','Microsoft Windows IA (64-bit)','','/') || i.instance_name || '_ora_' || pr.spid || '.trc' as trace_filefrom v$session s, v$process pr, v$parameter pa, v$instance i , v$database dwhere s.username = user and s.paddr = pr.addrand pa.name='user_dump_dest';......【阅读全文】

阅读(2988) | 评论(0) | 转发(0)

发布时间:2009-06-23 14:17:47

不细看doc还真不行。http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/archredo.htm#i1006731[@more@]SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> startup mountORACLE 例程已经启动。Total System Global Area 104857600 bytesFixed Size 1247540 bytesVariable Size 96470732 bytesDatabase Buffers 4194304 bytesRedo Buffers 2945024 bytes数据库装载完毕。--启用手动归档SQL> alter database archivelog......【阅读全文】

阅读(3836) | 评论(0) | 转发(0)

发布时间:2009-06-23 13:44:45

doc的原话,记录一下,加深印象。[@more@]Specifying the Mode of Log TransmissionThe two modes of transmitting archived logs to their destination are normal archiving transmission and standby transmission mode. Normal transmission involves transmitting files to a local disk. Standby transmission involves transmitting files through a network to either a local or remote standby database.Normal Transmission ModeIn normal transmission mode, the archiving destination is another disk drive of the databas......【阅读全文】

阅读(3108) | 评论(0) | 转发(0)

发布时间:2009-06-23 11:44:45


阅读(3077) | 评论(0) | 转发(0)

发布时间:2009-06-23 09:08:32


阅读(3445) | 评论(0) | 转发(0)

发布时间:2009-06-19 11:47:58

The execution order in EXPLAIN PLAN output begins with the line that is the furthest indented to the right. The next step is the parent of that line. If two lines are indented equally, then the top line is normally executed first. 在doc上看到了,记录一下[@more@]SQL> select count(*) from dba_objects;COUNT(*)----------11345Execution Plan----------------------------------------------------------Plan hash value: 2598313856---------------------------------------------------------------------------......【阅读全文】

阅读(4324) | 评论(0) | 转发(1)

发布时间:2009-06-09 14:16:16

使用bbed需要注意:1、win下oracle不提供2、随oracle软件一起发布3、在unix/linux下使用时需要事先relink4、oracle最初使用bbed用来修复坏block,从9i开始可以通过rman的blockrecover来恢复,不过前提是事先做过备份[@more@][oracle@xys oracle]$ bbedPassword:BBED: Release - Limited Production on Tue Jun 9 13:13:04 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.************* !!! For Oracle Internal Use only !!! ***************BBED> help all;SET DBA [ dba | file#, block# ]SET FILENAME 'file......【阅读全文】

阅读(3577) | 评论(0) | 转发(0)

发布时间:2009-06-08 15:04:05

都是doc的内容:Templates are used to set redundancy (mirroring) and striping attributes of files created in an ASM disk group. When a file is created, redundancy and striping attributes are set for that file based on an explicitly named template or the system template that is the default template for the file type.When a disk group is created, ASM creates a set of default templates for that disk group. The set consists of one template for each file type (data file, control file, redo log file, a......【阅读全文】

阅读(3675) | 评论(0) | 转发(0)

发布时间:2009-06-08 14:31:01

问题虽小,却困扰了一段时间![@more@]SQL> create tablespace TEST datafile '+DG/asmdb/datafile/TEST.DBF' SIZE 3M;表空间已创建。SQL> SELECT FILE_NAME FROM DBA_DATA_FILES;FILE_NAME--------------------------------------------------------------------------------+DG/asmdb/datafile/users.266.688401581+DG/asmdb/datafile/sysaux.264.688401529+DG/asmdb/datafile/undotbs1.263.688401515+DG/asmdb/datafile/system01.dbf+DG/asmdb/datafile/test.dbf--=====================================ASMCMD> pwd+dg/asmdb......【阅读全文】

阅读(4708) | 评论(0) | 转发(0)

发布时间:2009-06-01 09:50:03

sys用户下的对象不支持导出[@more@]SQL> select owner,segment_name,tablespace_name from dba_segments where tablespace_name='USERS';OWNER SEGMENT_NAME TABLESPACE_NAME---------- -------------------- ------------------------------SYS REPAIR_TABLE USERSSYS TT USERSTEST1 TT USERSSYS T1 USERSTEST T USERSTEST TT USERS已选择6行。SQL>C:>expdp 'sys/system@test as sysdba' DIRECTORY=temp_dir dumpfile=users.dmp tablespaces=usersExport: Release - Production on 星期一, 01 6月, 2009 9:47:44Copy......【阅读全文】

阅读(4575) | 评论(0) | 转发(0)

登录 注册