-
2008-08-28 17:00:21 / Oracle数据库管理
要建个用户对edm的表有select insert delete update权限,对自己的表有create drop table权限怎么来做
查看(53)
评论(0)
-
2008-08-27 11:52:47 / Oracle数据库管理
由于工作原因经常要杀死锁死的存储过程在网上看到很多这样的答案但是感觉有问题,大家帮我1.查哪个过程被锁查V$DB_OBJECT_CACHE视图:SELECT * FROM V$DB_OBJECT_CACHE WHERE OWNER='过程的所属用户' AND LOCKS!='0';2. 查是哪一个SID,通过SID可知道是哪个SESSION.查V$Access视图: SELECT * FROM V$ACCESS WHERE OWNER='过程的所属用户' AND NAME='刚才查到的过程名';3. 查出SID和SERIAL#查V$SESSION视图: SELECT SID,SERIAL#,PADDR FROM V$SESSION WHERE SID='刚才查到的SID'查V$PROCESS视图: SELECT SPID FROM V$
查看(130)
评论(11)
-
2008-07-05 20:50:39 / Oracle数据库管理
系统平台:solaris2.8oracle:9IBDUMP文件中有很多Created Undo Segment _SYSSMU53$Undo Segment 53 Onlined类似动作。但是回滚段8点钟很闲。分析什么原因呢?BDUMP文件:。。。。Sat Jul5 10:13:31 2008Thread 1 advanced to log sequence 4709Current log# 1 seq# 4709 mem# 0: /DMCDBS01/DMCEDM01/oradata/DMCEDM02/redo01.logSat Jul5 10:13:31 2008ARC1: Evaluating archivelog 3 thread 1 sequence 4708ARC1: Beginning to archive log 3 thread 1 sequence 4708Creating archive destina
查看(243)
评论(10)
-
2008-06-28 16:51:01 / Oracle数据库管理
检查不起作用的约束SELECT owner, constraint_name, table_name,constraint_type, statusFROM dba_constraintsWHERE status = 'DISABLED’ AND constraint_type = 'P'检查无效的triggerSELECT owner, trigger_name, table_name, statusFROM dba_triggersWHERE status = 'DISABLED’问提:这里不起作用的约束和无效的tigger 是在定义的时候就定义成了无效的,还是在由于这个约束或触发在应用中没有起作用。或是什么原因造成的。如果数据库中有很多这样的情况会有什么样的后果呢
查看(122)
评论(3)
-
2008-06-11 11:21:53 / Oracle数据库管理
如果指定表空间的对象的NEXT_EXTENT不相同会有什么不良?SELECT segment_name, segment_type, ds.next_extent as Actual_Next, dt.tablespace_name, dt.next_extent as Default_NextFROM dba_tablespaces dt, dba_segments dsWHERE dt.tablespace_name = ds.tablespace_nameAND dt.next_extent !=ds.next_extentAND ds.owner = UPPER ( '&OWNER' )ORDER BY tablespace_name, segment_type, segment_namSEGMENT_NAMESEGMENT_TYPE
查看(155)
评论(6)
-
2008-06-10 11:33:42 / Oracle数据库管理
SELECT e.owner, e.segment_type , e.segment_name , count(*) as nr_extents ,s.max_extents, to_char ( sum ( e.bytes ) / ( 1024 * 1024 ) , '999,999.90') as MBFROM dba_extents e , dba_segments sWHERE e.segment_name = s.segment_nameGROUP BY e.owner, e.segment_type , e.segment_name , s.max_extentsHAVING count(*) > &THRESHOLDOR ( ( s.max_extents - count(*) ) < &&THRESHOLD )ORDER BY count(*) desccount(*) as nr_extents (这里不明白他到底统计的是什么)这里统计的是一共有多少
查看(131)
评论(3)
-
2008-06-02 22:53:16 / Oracle数据库管理
就是说只要一个session修改了这个值老数据就会写到回滚段里,buffer里变成脏数据,并不需要commit 或checkpiont,或需要什么触发dbwr或lgwr。是这样吧
查看(234)
评论(3)
-
2008-06-01 22:34:20 / Oracle数据库管理
如题。我通过下面的sql检查表空间使用率:SELECT tablespace_name, max_m, count_blocks free_blk_cnt, sum_free_m,to_char(100*sum_free_m/sum_m, '99.99') || '%' AS pct_freeFROM ( SELECT tablespace_name,sum(bytes)/1024/1024 AS sum_m FROM dba_data_files GROUP BY tablespace_name),( SELECT tablespace_name AS fs_ts_name, max(bytes)/1024/1024 AS max_m, count(blocks) AS count_blocks, sum(bytes/1024/1024) AS sum_free_m FROM dba_free_space GROUP BY tablespace_name )WHERE tablespace_name = fs_ts_
查看(239)
评论(3)
-
2008-04-22 22:51:29 / Oracle数据库管理
Export: Release 9.2.0.6.0 - Production on Tue Apr 22 21:46:28 2008Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.6.0 - ProductionExport done in US7ASCII character set and UTF8 NCHAR character setserver uses ZHS16GBK character set (possible charset conversion)About to export specified users ....
查看(229)
评论(5)
-
2008-04-19 12:04:36 / Oracle数据库管理
SQL> select * from v$tablespace;TS# NAMEINCLUD---------- ------------------------------------------------------------ ------0 SYSTEMYES1 UNDOTBS1YES3 CWMLITEYES4 DRSYS
查看(5437)
评论(10)