爱的光芒 - TeamBlog

ORA-3113 database upgrade

Execute the post execution steps for the patch, and those are as follows

1. Run the startup migrate command. If you are running Oracle Real Applications Clusters, set cluster_database in the initSID.ora file to FALSE prior to starting in migrate mode.

2. Run the spool patch.log command.

3. Run the @\rdbms\admin\catpatch.sql script.

4. Run the spool off command.

5. Review the patch.log file for errors, and rerun the catpatch.sql script after correcting any problems.

6. Run the shutdown command.

7. Run the startup command.

8. Run the ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql script. This step is optional, and will recompile all invalid PL/SQL packages now instead of when the packages are accessed the first time. You can use the utlrcmp.sql script to parallelize this in multiprocessor computers.

9. Run the exit command.

takken @ 2006-12-31 12:32 | 评论 (0) | 小命令 | 无标签 | 加入收藏

ORA-600 query

SQL> alter system flush shared_pool;
SQL> alter session set events '10119 trace name context forever, level 12';

takken @ 2006-12-31 11:13 | 评论 (0) | 小命令 | 无标签 | 加入收藏

ORA-3113 and ORA-7445 [kknerd] When Dropping a Tab

1.SQL>select object_id,object_name from dba_objects where object_id in (select obj# from sys.ustats$);

2.SQL>delete from sys.ustats$ where obj#=<object_id from step 1>;

3.SQL> commit;

4.SQL> drop table table_name ;

takken @ 2006-12-31 10:57 | 评论 (0) | 小命令 | 无标签 | 加入收藏

增加容量

chfs -a size=+2048M /ufdata

takken @ 2006-12-29 17:20 | 评论 (0) | 小命令 | 无标签 | 加入收藏

UNIX上查看CPU个数和内存

查看cpu

1、aix和hp上面：
lsdev -C | grep Process | wc -l

lscfg |grep proc lsattr -El proc0

lscfg |grep mem lsattr -El mem0

2、solaris上面：
psrinfo -v | grep "Status of processor" | wc -l

用psrinfo(1M)就可以查看。由于多内核/多线程技术的广泛采用，要查出物理CPU的数目可以使用-vp参数，例如：

＃ psrinfo -vp
The physical processor has 32 virtual processors (0-31)
UltraSPARC-T1 (cpuid 0 clock 1000 MHz)

UltraSPARC-T1的CPU共有8内核，每内核4个线程，因此如果单用-v参数看到的CPU数目是32个，而不是1个。

3、linux上面
cat /proc/cpuinfo | grep processor | wc -l

查看内存

1、在hp/ux上面
root 用户可以用sam 和 mstm ，非root用户可以用：cat /var/adm/syslog/syslog.log|grep Physical
2、在aix上面
lsdev -C | grep mem
lsattr -El mem0 lsattr -E -l sys0 -a realmem

查看虚拟内存

lsps -a

3、在solaris上面
prtconf | grep -i mem
4、在linux上面
free

查看操作系统的位数：

在solaris上面：如何查看系统内核是32位的还是64位的？

isainfo -b isainfo -v

在hpux上面：#/bin/getconf KERNEL_BITS

在aix上面：bootinfo -y

关于solaris的faq：

http://wiki.gceclub.sun.com.cn/index.php/OpenSolaris/Solaris%E4%B8%AD%E6%96%87FAQ

aix上是否开启aio：

lsdev -Cc aio

takken @ 2006-12-29 17:15 | 评论 (0) | 小命令 | 无标签 | 加入收藏