-
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-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-14 22:31:32 / Oracle数据库管理
在9I的时候NET MANAGER 配完后在企业管理器可以挂接远程的数据库，在1OG可以吗，怎么没找到,10G的企业管理器真不习惯。
查看(329)
评论(7)
-
2007-12-31 23:19:34 / Oracle数据库管理
Asktom 2007全年的合订本，整理打包为CHM格式。请到雪狼的个人空间下载完整版本(19.8M)：http://space.itpub.net/?uid-50530-action-viewspace-itemid-648762007年的合订本比往年合订本的工作最都要大的多，只是下载文件就断断续续费了几天功夫。如果欣赏雪狼所作出的努力，请将此贴顶起，雪狼谢谢您的支持！[雪狼制作，必属精品]
查看(11281)
评论(207)
-
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)
-
2007-12-10 15:22:42 / Oracle数据库管理
root是 root:x:0:1:Super-User:/:/sbin/shoracle::105:50:Oracle Database Account:/DMCDBS01/oracle:/bin/csh两种不同的shell我跑这个./oraincrbk.shroot@ # more oraincrbk.sh#!/usr/bin/csh## Backup Oracle instance DMM02echo Backup Oracle instance DMM02 on `date`su - oracle -c "/opt/tivoli/tsm/scripts/incrbkEDM02.sh"root@ # more incrbkEDM02.sh#!/usr/bin/csh## Backup database instance EDM02 at incremental level 1#setenv ORACLE_SID DMM02rman target
查看(295)
评论(4)
-
2007-11-19 14:48:05 / Oracle数据库管理
先是这个实例可以起来SQL> select * from v$instance;INSTANCE_NUMBER INSTANCE_NAME--------------- ----------------HOST_NAME----------------------------------------------------------------VERSIONSTARTUP_T STATUSPARTHREAD# ARCHIVE LOG_SWITCH_----------------- --------- ------------ --- ---------- ------- -----------LOGINSSHU DATABASE_STATUSINSTANCE_ROLEACTIVE_ST---------- --- ----------------- ------------------ ---------1 DMC
查看(227)
评论(3)
