clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases

This is mainly Oracle DBA blog which also cover performance tuning,oracle cloud dbaas,oracle rac dataguard,active dataguard,RMAN and other topics like Linux,AWS,Cassandra and other databases.Please subscribe below to get update on my blog.

  • AWS
  • MY PRESENTATION
  • Oracle DBA
    • Backup and Recovery
    • Troubleshooting
    • General Performance tuning
    • oracle gateway
    • PATCHING
    • Installation
    • Cloning
    • Dataguard
    • ASM
    • security
    • cloud control 13c
    • oracle 12c
    • PLSQL for DBA
  • Linux
  • MySQL DBA
  • PostgreSQL
  • SCRIPTS
  • DevOps
    • Docker
  • Online Training DBA
  • ORACLE INTERVIEW QUESTIONS
    • Generic DBA
    • EXPDP IMPDP Datapump interview questions
    • Database Architecture Interview Questions
    • Oracle user role and privilege interview questions
    • Redo,Undo,Control file interview questions
    • RMAN interview questions
    • Backup and recovery Interview questions
  • Oracle DBAAS 1z0-160
  • Oracle cloud DBaaS reference (1z0-160)
  • Python for DBA
    • Basic Python for DBA – part 1
    • Basic Python for DBA – part 2

Tag: oratop

  1. Home
  2. oratop
March 15, 2018

AWR report analysis in 12c depth-part 1

1.Let me  create a test case : I will take different OS statistics and run time statistics to compare with AWR report generated after execution. Case A.About test case in lower CPU:- I will create a table first create table t (id number, sometext varchar2(50),my_date date) tablespace data; Now I will create a simple procedure to load bulk data create […]

Read More
debasis maity General Performance tuning 4

Count per Day

  • 664144Total reads:
  • 207Reads today:

    Top Posts & Pages

    • Undo Advisor help to estimate the undo tablespace size and undo retention to avoid ORA-1555
    • Oracle database instance recovery is taking too much time after shutdown immediate
    • Script to sync check of applied archive log between 2 RAC databases
    • Index creation progress in oracle
    • Oracle Virtual Box VM:-How to create network setting and interface in Oracle Virtual Box to connect internet as well as connect from host
    • HOME
    • Online Training DBA
    • Oracle cloud DBaaS reference (1z0-160)
    • ORACLE DBA
    • Oracle Student guide
    • Python for DBA

    Copyright ©2023 clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases . All rights reserved. Powered by WordPress & Designed by Cyclone Themes

     

    Loading Comments...