Partitions/Shell Script

Protected: Shell :EXPORTING DATA FROM REMOTE DATABASE USING NETWORK_LINK

6 years ago by Binnary Ajay KumarOracle DB Admin

There is no excerpt because this is a protected post.

Protected: How to kill Long Running Query using scripts.

6 years ago by Binnary Ajay KumarOracle DB Admin

There is no excerpt because this is a protected post.

Protected: Shell : Automate killing Blocking Sessions

6 years ago by Vinod SiramOracle DB Admin

There is no excerpt because this is a protected post.

Oracle :Batch updates using PLSQL Blocks.

6 years ago by Vinod SiramOracle DB Admin

Oracle :Batch updates using PLSQL Blocks. In this article , we will learn how to update million records in a table using plsql blocks. Aim : To avoid Undo errors –> For every 200 transactions we are keeping commit to avoid snapshot too old error.… Read More

Protected: Shell :Automated Gathering Stats using Shell Scripting for STALE STATS.

6 years ago by Vinod SiramOracle DB Admin

There is no excerpt because this is a protected post.

Oracle:HEALTH CHECK REPORT(Capturing Archive information).

6 years ago by Vinod SiramOracle DB Admin

Oracle:HEALTH CHECK REPORT(Capturing Archive information). In this article we will implement to capture the Archive information using Shell script. Lets create a table which can store Archive information. Connect to SYS user and execute below statement.

CREATE TABLE DBMON.ARCHIVE_USAGE_HISTORY
(
  GENERATION_DATE  DATE                         NOT NULL,
  INST_ID          NUMBER                       NOT NULL,
  TOTAL_DAY_GB     NUMBER
)
TABLESPACE DATA01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;

CREATE TABLE DBMON.ARCHIVE_USAGE_HISTORY

(

GENERATION_DATE DATE NOT NULL,

INST_ID NUMBER NOT NULL,

TOTAL_DAY_GB NUMBER

)

TABLESPACE DATA01

RESULT_CACHE (MODE DEFAULT)

PCTUSED 0

PCTFREE 10

INITRANS 1

MAXTRANS 255

STORAGE (

INITIAL 64K

NEXT 1M

MAXSIZE UNLIMITED

MINEXTENTS 1

MAXEXTENTS UNLIMITED

PCTINCREASE 0

BUFFER_POOL DEFAULT

FLASH_CACHE DEFAULT

CELL_FLASH_CACHE DEFAULT

)

LOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

Create unique index and primary key on ARCHIVE_USAGE_HISTORY… Read More

ORACLE : HOW TO CHECK INDEX FRAGMENTATION.

6 years ago by Ramesh VOracle DB Admin

HOW TO CHECK INDEX FRAGMENTATION. When a database is frequently updated via UPDATE, or DELETE statements we can expect it to become fragmented over the time. If database indexes are fragmented, the SQL query optimizer may chose a non-optimal execution plan when using an index to… Read More