- 博客(14)
- 收藏
- 关注
RSS订阅转载 EXP-00091: Exporting questionable statistics
oracle@/oracle/1110]$sqlplus "/as sysdba"SQL> select userenv('language') from dual;USERENV('LANGUAGE')---------...
2011-10-10 11:17:35
86
转载 How to re-install JVM
SQL> select comp_name, version, status from dba_registry;COMP_NAMEVERSION...
2011-10-04 13:46:31
100
转载 How to do oracle database character set migration
--install character set migration utility schemaSQL> @?/rdbms/admin/csminst.sql--backup and restart da...
2011-10-04 13:44:52
162
转载 Get the below error after duplicating database
ORA-01187: cannot read from file 121 because it failed verification tests ORA-01110: data file 121: '/pfrx11/d...
2011-10-04 13:41:48
98
转载 How to do the batch job (disable/enable constraint)
BEGIN FOR c IN (SELECT c.owner, c.table_name, c.constraint_name FROM user_constraints c, user_tables t...
2011-10-04 13:36:24
132
转载 ORA-01940: cannot drop a user that is currently connected
select s.sid, s.serial#, s.status, p.spidfrom v$session s, v$process pwhere s.username = '' and p.addr (+) = ...
2011-10-04 13:34:20
91
转载 How to get the TOP SQL
Top 10 by Buffer Gets:set linesize 100set pagesize 100SELECT * FROM(SELECT substr(sql_text,1,40) sql,buffer_gets...
2011-10-04 13:33:03
124
转载 Change the max extents of table
SQL> alter table storage (maxextents 500);SQL> alter table storage (maxextents unlimited); ...
2011-10-04 13:28:11
78
转载 Fix undo tablespace issue Errors
Fix undo tablespace issue Errors in file /oracle/admin/test/bdump/test2_smon_21466.trc:ORA-00600: internal error c...
2011-10-04 13:21:31
79
转载 Identify tablespace fragmentation
column FSFI format 999,99select tablespace_name,sqrt(max(blocks)/sum(blocks))*(100/sqrt(sqrt(count(blocks)))) ...
2011-10-03 16:09:06
92
转载 ORA-00018: maximum number of sessions exceeded
LIBRARY CACHE LOCKS DUE TO INVALID LOGIN ATTEMPTS (Doc ID 1309738.1)Bug 12990384: HIGH LIBRARY CACHE LOCK IN 11.2....
2011-10-03 16:00:28
103
转载 How to shrink log files in MS SQL Server
在full模式下，如果不定时备份并截断log文件，会导致log文件过大，从而把磁盘撑爆，可以依照以下步骤shrink log文件：1. 用sqlperf查看log大小及使用率：dbcc sqlperf(logspace)Data...
2011-10-03 15:57:31
267
转载 Identify index fragmentation
analyze index index_name validate structure;select name, trunc(100*(del_lf_rows/lf_rows)) pct_deleted, pct_...
2011-10-03 15:55:00
101
转载 Shrink the temp tablespace
create temporary tablespace TEMP2 TEMPFILE '/mnt/MX_ORA_6/oradata/PROD/temp2.dbf' SIZE 512M REUSE AUTOEXTEND O...
2011-10-03 15:50:26
118
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人