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: spm

  1. Home
  2. spm
March 8, 2018

SPM oracle 12c test case

A.Enabling  SPM manually to stabilize plan for a particular query For this test case I will create a table with skewed data so that for one bind value it will go for one execution plan and for other bind value,it will go for another execution plan.Ideally this should be good to go for different execution plan depending on the bind […]

Read More
debasis maity General Performance tuning 0

Debasis Maity

  • Email
    debasis.tcs@gmail.com
Loading

Translate

Ad

Please connect me in linkedin

  • LinkedIn

    Top Posts & Pages

    • Step by Step Oracle Active Data Guard Far Sync RAC
    • Undo Advisor help to estimate the undo tablespace size and undo retention to avoid ORA-1555
    • Installation of Oracle 12c RAC Flex cluster infrastructure on Virtual Box
    • Database Architecture Interview Questions
    • Index creation progress in oracle
    • Redo,Undo,Control file interview questions
    • TDE encryption setup for migrating on-premise backup to Oracle cloud using RMAN
    • Oracle user role and privilege interview questions

    Follow Us

    • AWR report analysis in 12c depth-part 1
    • Oracle DBaaS 1z0-160 part 4:-Creating Cloud service roles and users and assign new roles
    • Lambda to Start EC2 Instances on schedule and send instant public IP over email to multiple recipients using SNS
    • TDE encryption setup for migrating on-premise backup to Oracle cloud using RMAN

    • HOME
    • Online Training DBA
    • Oracle cloud DBaaS reference (1z0-160)
    • ORACLE DBA
    • Oracle Student guide
    • Python for DBA

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

     

    Loading Comments...