![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle数据库管理
pizi110
这个作者很懒,什么都没留下…
展开
-
查看oracle sql资源占用过多的sql
SELECT ROWNUM top, t.* FROM (SELECT x.CPU_TIME/x.executions per_cpu, x.hash_value, x.sql_text FROM v$sqlarea x WHERE x.executions>0 AND x.parsing_user_id <>0 ORDER BY x.CPU_TIME/x.ex...转载 2020-02-25 01:48:30 · 812 阅读 · 0 评论 -
oracle11g静默安装数据库+手工创建实例
可用户11.2.0.4 静默安装 1:配置响应文件 响应文件模板 /software/database/response/db_install.rsp vi /software/database/response/install.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_sc...转载 2020-02-22 20:51:36 · 855 阅读 · 0 评论 -
oracle数据库备份脚本
#!/bin/sh source /home/oracle/.bash_profile rman target sys/oracle msglog='/tmp/full.log' append <<EOF run { allocate channel ch1 device type disk; allocate channel ch2 device type disk; allocat...原创 2019-05-29 10:57:44 · 191 阅读 · 0 评论 -
check_tablespace
#!/bin/bash # tablespace usagep check source ~/.bash_profile function check { sqlplus -S "/ as sysdba" << EOF set linesize 200 set pagesize 200 spool /tmp/ora_tablespace.txt select a.tablespace...原创 2019-05-29 11:09:11 · 135 阅读 · 0 评论 -
delete_arch
#!/bin/bash source /home/oracle/.bash_profile rman target / msglog=/data/delete_arch.log append << EOF run { delete noprompt archivelog until time 'sysdate-7'; } exit; EOF原创 2019-05-29 11:12:36 · 150 阅读 · 0 评论 -
expdp之前需要切换归档吗
在RMAN备份的时候都要先切换归档3次才能够将redo log里面的内容备份出来,在做expdp之前也需要做切换归档的操作么,如果不做归档切换,能直接备份出在redolog中的内容吗,谢谢! ...原创 2019-06-01 19:58:53 · 336 阅读 · 0 评论