Posts

Fragmentation In Oracle Table

Table Fragmentation
Post a Comment
Read more

Expdp Backup Using Shell Script

EXP_TAB_cmprss.sh $Header: EXP_TAB_cmprss.sh   # *====================================================================================+ # |  Author - DBACLASS ADMIN TEAM # |                                                       | # +====================================================================================+ # | # | FILENAME # |     EXP_table_bkp_cmprss_dbaclass.sh # | # | DESCRIPTION # |     Daily Export backup script of a list of table # | PLATFORM # |     Linux/Solaris   # +===========================================================================+ #!/bin/bash echo Set Oracle Database Env ...
Post a Comment
Read more

Tablespace Monitoring Shell Script

SQL FILE 3 set feedback off set pagesize 70 ; set linesize 2000 set head on COLUMN Tablespace         format a25 heading 'Tablespace Name' COLUMN autoextensible         format a11               heading 'AutoExtend' COLUMN files_in_tablespace     format 999              heading 'Files' COLUMN total_tablespace_space format 99999999 heading 'TotalSpace' COLUMN total_used_space       format 99999999 heading 'UsedSpace' COLUMN total_tablespace_free_space format 99999999 heading 'FreeSpace' COLUMN total_used_pct               format 9999        heading '%Used' COLUMN total_free_pct  ...
Post a Comment
Read more