- 博客(26)
- 收藏
- 关注
RSS订阅转载 ORA-03117: two-task save area overflow
在用到package dbms_metadata的时候发现问题SQL> desc dbms_metadataERROR:ORA-03117: two-task save area overflowFrom me...
2009-02-09 10:30:18
712
转载 MYSQL简单操作
1. 登录mysqlmysql -u root -p2. 查询哪些用户可以登录mysqlmysql> select host,user from user;3. change column name(oracle好像不能c...
2009-02-09 09:56:04
134
转载 Linux远程桌面到Windows
1.到http://www.rpmfind.net 下载个rdesktop for linux[root]# rpm -ivh rdesktop-1.5.0-5.fc9.i386.rpm Preparing... ...
2009-02-05 09:20:57
111
转载 ORA-00257: archiver error. Connect internal only, until freed
SQL> select * from v$flash_recovery_area_usage;FILE_TYPE PERCENT_SPACE_USED--------...
2009-01-19 09:05:31
103
转载 sql优化
1.发现问题，从statspack中抓到一个sql需要的buffer gets和disk reads很高STATSPACK SQL report for Hash Value: 2088862589 Module: InSite...
2008-03-25 09:09:51
138
转载 Solaris: /home不可写
Solaris的/home目录是由automounter控制的，只有automounter可以在这个目录下创建文件。如果不希望automounter管理/home目录，可以在删除/etc/auto_master文件中包含"/ho...
2008-03-07 10:24:30
126
转载 ORA-01594: attempt to wrap into rollback segment (7) extent (2) which is being freed
no more addition operation for this message[@more@] ...
2008-03-07 10:21:05
123
转载 我遇到的ORA-600错误
1.ORA-00600: internal error code, arguments: [504], [0x70000000006C900], [640], [7], [shared pool], [2], [0], [0x7...
2008-03-07 10:14:48
293
转载 Index on partition table
一般来说，OLTP 系统适合采用全局索引，而数据仓库系统或 DSS 系统适合采用本地索引。此外，用户应尽可能地使用本地索引，因为此种索引更易管理。在选择索引类型时，可以参考以下经验： 如果表的分区键（partitioning c...
2008-01-19 00:07:53
120
转载 Veritas volume manager
/opt/mpp/lsvdev 查看lunvxdisk list 查看硬盘vsdisksetup -i sdab 初始化硬盘vxdg init oradg305 oradg305-sst0020-disk001=sdd 建dg加...
2008-01-18 23:41:05
160
转载 ORA-30496: argument should be a constant.
Developer met a error ora-30496 when modify column length.SQL> ALTER TABLE Test MODIFY (ID CHAR(10));ORA-30496:...
2007-12-07 08:46:52
334
转载 Statspack ORA-00001 Bug
From alert log :< ORA-12012: error on auto execute of job 1 < ORA-00001: unique constraint (PERFSTAT.STATS$S...
2007-12-07 08:28:49
110
转载 Import statistics from another Datbase
Steps to export/import db statistics between 2 databases.Here schema_name1 = schema_name2rem 1) Create the holding...
2007-12-07 08:14:52
127
转载 限定部分主机登录数据库
1) create sqlnet.ora in $ORACLE_HOME/network/admin with this content# SQLNET.ORA Network Configuration File: /orac...
2007-09-04 10:20:47
126
转载 固定行列转换
SQL> select * from test;CARD Q1 Q2---------- ---------- ----------a 1 12a 1 21a 2 43a 2 65b 1 12b 2 87b 2 17 ro...
2007-09-03 10:16:39
97
转载 RMAN MAINTENANCE
取消註冊catalogSQL> select db_key,db_id from db; db_key db_id 429 201401412SQL> execute dbms_rcvcat.unregisterda...
2007-08-30 08:46:26
128
转载 常用的分析函数
常用的分析函数如下所列:row_number() over(partition by ... order by ...)rank() over(partition by ... order by ...)dense_rank()...
2007-08-28 08:23:41
178
转载 一个sql创建数据库
$ more create9idb.sqlspool CreateDB.log-- shutdown immediate;-- shutdown abort;-- !strings /oracle/305/oracle/prod...
2007-08-27 08:32:36
123
转载 Redhat OS checklist sample
[root ~]# more /etc/resolv.conf# Added by kickstart file# -----------------------domain test.comnameserver 165.20...
2007-08-24 08:35:08
127
转载 Logmnr
SQL> conn /as sysdbaConnected.SQL> show parameter utl SQL> @?/rdbms/admin/dbmslm.sqlPackage created.Grant...
2007-08-22 08:26:39
86
转载 在solaris下看iso文件内容
root # mkdir /tmp/1root # mkdir /tmp/2root # mkdir /tmp/3root # mkdir /tmp/4 /tmp/5root # pwd/mnt/inst/RHEL4-U4-x8...
2007-08-21 08:00:01
133
转载 Rman异机还原database
1. 创建用户名,组2. 创建相同的目录Datafile redo log arch bdump cdump create udump配置tnsnames.ora listener.ora拷贝pfile 修改,创建spfile...
2007-08-20 15:25:49
134
转载 upgrade oracle9207 to 9208
1. install 9208 patch set2. alter system set java_pool_size='150M' scope=spfile;3. shutdown immediate startup4....
2007-08-20 15:09:38
63
转载 Migration from Oracle 9i to Oracle 10gR2
System Information Source systemOracle: 9.2.0.7Destination SystemOracle: 10.2.0.2 1. run check sc...
2007-08-20 14:38:57
78
转载 Installation oracle9207 on Redhat AS4
1.Check package OS AS4 update 4rpm 版本必须高于下面的版本，使用rpm –qa | grep 查询compat-db-4.1.25-9 compat-gcc-32-3.2.3-47.3 comp...
2007-08-20 14:15:10
76
转载 Install oracle10.2 on Solaris10 x86
1.Check OS packageSUNWarc SUNWlibms SUNWi1of SUNWbtool SUNWsprotSUNWi1cs SUNWhea SUNWi15cs SUNWlibm SUNWtoo SUNWx...
2007-08-20 13:48:55
123
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人