ITPub博客

应税所得2适用税率速算扣除数级数0-150003%011500-4500150010%10524500-9000450020%55539000-35000900025%1005435000-550003500030%2755555000-800005500035%55056...

 RDA的使用（一）RDA的帮助1. 解压RDA文件p15929817_430_LINUX.zip[hrmsoraclone@hrmodbt01 tmp]$ unzip p15929817_430_LINUX.zip2. 使用RDA的帮助[hrmsoraclone@hrmodbt01 tmp]$ cd rda/[hrmsoraclone@hrmo...

hrmsdbset environment variables for restoreexport NLS_LANG=American_America.UTF8export NLS_DATE_FORMAT="mm-dd-yyyy:hh24:mi:ss"rman target /startup nomount;set dbid 2948431088;1. restore controlfile...

 补丁：p8202632_10205_linux_x86-64.zip 1.export DISPLAY=localhost:0.02.xhost +3../runInstaller 1.Start the database in the UPGRADE mode:SQL> STARTUP UPGRADE2.Set the system to spo...

1、关闭szmmisu01上的数据库和上面的mmis服务。2、在SB40上分配60G空间给szmmisu01.3、在szmmisu01对新分配的磁盘进行分区。Fdisk  /dev/sdbCommand (m for help): nCommand action   e ...

升级OPenssh到OpenSSH_6.1p1 一、开启telnet，防止ssh中断后无法远程连接服务器。#vi /etc/xinetd.d/krb5-telnet 把yes该为no,# /etc/init.d/xinetd start加载windows的共享盘到Linux中mount -t cifs -o ...

IO 阻塞时 每秒物理读 1769 * 8k = 13MPhysical reads:         1,769.5         141.0      &nb...

1.普通数据文件alter database datafile '/u02/fmsprd/fmsprddatasystem01.dbf' offline;mv fmsprddatasysaux01.dbf   sysaux01.dbfalter database rename file '/u02/fmsprd/fmsprddatasysaux01.dbf' ...

1、找出所有受影响的对象vi checkdb.shrman target  / nocatalog <<EOFrun{allocate channel d1 type disk;allocate channel d2 type disk;allocate channel d3 type disk;allocate channel d4 type disk;backu...

 追踪enqueue lock,DDL语句锁SQL> alter session set timed_statistics = true;SQL> alter session set statistics_level=all;SQL> alter session set max_dump_file_size = unlimited;SQL> alter session set ...

Select extract(day from snap_interval) * 24 * 60 +       extract(hour from snap_interval) * 60 +       extract(minute from snap_interval) "S...

 1把之前drop的日志文件group1,group2,group3重新使用，同时删除drop group4,group5,group6。select * from v$log;col member for a50select * from v$logfile;alter database add logfile group 1 ('/umm...

http://www.oracleonlinux.cn/2012/09/log-miner-recover-data/http://www.killdb.com/index-of-articlehttps://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=1339099855777434&_afrWind...

想收集SQL trace信息使用tvdxtat.在用户目录下.bash_profile加入alias tvdxtat=' .  /uhrms/scripts/tvdxtat.sh'然后source .bash_profile生效。

1 今天做HRMS Clone工作，需要更改数据库名。改了数据库名发现，数据库打不开。报错SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more re...

http://www.itpub.net/forum.php?mod=viewthread&tid=1361814http://www.oracle.com/technetwork/cn/articles/rac11g-setting-100145-zhs.html#tophttp://www.oracledatabase12g.com/archives/step-by-step-instal...

 oracle新特性http://yangtingkun.itpub.net/post/468/448296  VCS服务http://cache.baidu.com/c?m=9d78d513d98710ee4fede5245e4397240d13c03d338d96533dc3923b8e7908030527f4bb50784b13d3b22c345af90e...

 介紹安裝oracle 11grac 安裝http://dbastreet.com/docs/11gR2RacInstall_gridinfra.htmlhttp://dbastreet.com/docs/11gR2RacInstall_rac.htmlhttp://dbastreet.com/docs/11gR2RacInstall_dbca.htmlhttp://...

echo '--------------------------------------------------'echo 'Enter your choice :';read -t 15 nameif [ "$name" = "" ] then         echo  'Welcome to...

11323