-
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
查看(229)
评论(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 （这里不明白他到底统计的是什么）这里统计的是一共有多少
查看(207)
评论(3)
-
2008-06-02 22:53:16 / Oracle数据库管理
就是说只要一个session修改了这个值老数据就会写到回滚段里，buffer里变成脏数据，并不需要commit 或checkpiont，或需要什么触发dbwr或lgwr。是这样吧
查看(290)
评论(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_
查看(302)
评论(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 ....
查看(315)
评论(5)
-
2008-04-19 12:04:36 / Oracle数据库管理
SQL> select * from v$tablespace;TS# NAMEINCLUD---------- ------------------------------------------------------------ ------0 SYSTEMYES1 UNDOTBS1YES3 CWMLITEYES4 DRSYS
查看(5594)
评论(10)
-
2008-03-26 21:44:34 / Oracle数据库管理
Microsoft Windows [Version 5.2.3790](C) Copyright 1985-2003 Microsoft Corp.C:\Documents and Settings\Administrator>sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.1.0 - Production on 星期三 3月 26 21:26:10 2008Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.ERROR:ORA-01031: insufficient privileges请输入用户名:sqlnet.ora文件# sqlnet.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora# Generated by Orac
查看(244)
评论(3)
-
2008-03-15 11:39:57 / Oracle数据库管理
例如我7654这个进程占的CPu最多，我怎么才能看出他的sql语句，和执行计划
查看(306)
评论(3)
-
2008-03-14 22:31:32 / Oracle数据库管理
在9I的时候NET MANAGER 配完后在企业管理器可以挂接远程的数据库，在1OG可以吗，怎么没找到,10G的企业管理器真不习惯。
查看(329)
评论(7)
-
2007-12-26 09:09:33 / Oracle数据库管理
先是shutdown immediate半天停在哪里等不及了之后shutdown abortstartup后出现下面问题：SQL> startupORACLE instance started.Total System Global Area 2148620668 bytesFixed Size457084 bytesVariable Size771751936 bytesDatabase Buffers1375731712 bytesRedo Buffers679936 bytesORA-00205: error in identifying controlfile, check alert log for more infobdump的alter日志：Wed Dec 26 09:21:23 2007starting up 1 shared
查看(230)
评论(5)
