随笔分类 - Oracle / Oracle Scripts
摘要：1、Oracle script to check the database growth SET LINESIZE 200 SET PAGESIZE 200 COL "Database Size" FORMAT a13 COL "Used Space" FORMAT a11 COL "Used in
阅读全文
摘要：Let consider the below example, where we list all the indexes in the database. sql> select index_name from dba_indexes where tablespace_name ='EXAMPLE
阅读全文
摘要：Oracle script to check the database growth SET LINESIZE 200SET PAGESIZE 200COL "Database Size" FORMAT a13COL "Used Space" FORMAT a11COL "Used in %" FO
阅读全文
摘要：This is a script to get the tablespace utilization in Oracle Database 12c. You can use this script to get the tablespace utilization ALLOCATED(MB), US
阅读全文
摘要：在很多使用,因为各种原因,我们需要定时批量的kill一部分session,用来释放数据库部分资源,这里是因为bug导致temp不能正常释放,也可能是因为bug导致pga不释放,还有可能是因为太多inactive占用资源等等.我这里提供了两种方法来实现该功能存储过程实现kill session --创
阅读全文
摘要：column h0 format 999 column h1 format 999 column h2 format 999 column h3 format 999 column h4 format 999 column h5 format 999 column h6 format 999 col
阅读全文
摘要：vi /scripts/check/xunjian.sql set heading off select '一、数据库的基本情况' from dual; set heading off select '1、数据库版本' from dual; set heading on select * from
阅读全文
