![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle - 项目
shenghuiping2001
被裁员,失业中......(毕业于南京航空航天大学,在IBM工作过10年,现在专注splunk架构和数据分析。拥有Oracle: OCP认证, AWS: ASP认证, Azure: admin系统管理员认证。)
展开
-
给oracle 打patch
今天练习在oracle 上打patch Step1: unpress the patch [oracle@aoracle patch]$ ls -l total 1136 -rw-r--r-- 1 oracle oinstall 1157120 Sep 2原创 2011-09-28 18:24:40 · 1177 阅读 · 0 评论 -
Oracle 解锁 的sql (product 慢可以用一下)
发现oracle 占用了很多cpu,可能是sql 锁,下面发现的sql 就可以试试用来解锁: set serveroutput on size 10000 declare cursor c1 is select * from v$lock where request != 0 order by id1, id2; wid1 num原创 2011-11-02 18:55:32 · 626 阅读 · 0 评论 -
ora-00257 默认的 db_recovery_dest 满 用户不能登入 (解决)
This afternoon, customer had faced one problem: The user can not not connect to database, ora-00257 error log occur: Caustion: The achivelog is full 1: Even we delete the archivelog from原创 2012-02-15 18:42:00 · 1518 阅读 · 0 评论