Skip to content
Debugging Oracle Performance
A blog by Dinesh Bandelkar
  • Home
  • Cloud
    • OCI
  • New Features
    • Oracle 23ai
    • Oracle 19c
    • Oracle 18c
  • Administration
    • RAC
  • Performance
    • Troubleshooting
    • Database Memory
    • DataGuard
    • RMAN
  • Exadata
    • Maintenance
  • About

Author: Dinesh Bandelkar

SCAN Registration : Database services not registered in SCAN Listeners of Node1

November 18, 2021 Dinesh Bandelkar 2 Comments

Problem Statement In Real application Cluster setup, SCAN LISTENER running on 1st node could only register local instances and not…

Continue Reading

Posted in: RAC Filed under: database-administration

How to Setup OCI Storage Gateway?

May 5, 2020 Dinesh Bandelkar Leave a comment

What is Storage Gateway? Using Storage Gateway, your applications can interact with Oracle Cloud Infrastructure Object Storage through standard NFSv4…

Continue Reading

Posted in: OCI Filed under: cloud

Validate OCI Instance Block Volume Performance

April 25, 2020 Dinesh Bandelkar 1 Comment

Problem Statement We need to migrate our production workload in Oracle Cloud Infrastructure. Based on image shape, CPU and memory…

Continue Reading

Posted in: OCI Filed under: cloud

OCI Instance Console Connection from Windows OS

April 11, 2020 Dinesh Bandelkar 1 Comment

Problem Statement Connecting OCI Instance Serial Console using LINUX is easy and well documented. However very limited documentation exists on…

Continue Reading

Posted in: OCI Filed under: cloud

How to rollback Exadata configuration using OEDA Deployment script – “onecommand”

February 2, 2020 Dinesh Bandelkar Leave a comment

Problem Statement Customer anticipated to have different user for Grid infrastructure (grid) and Oracle database (ora12c) installation however OEDA has…

Continue Reading

Posted in: Maintenance Filed under: Exadata

Oracle Database “19c New Features”

August 3, 2019 Dinesh Bandelkar 18 Comments

Inspecting the Oracle 19c documentation, following are some of the fascinating new database features for your reference. Automatic Indexing The…

Continue Reading

Posted in: Oracle 19c Filed under: New Features

“Exadata Patching Failed” : ASM instance not starting after rescue

April 12, 2019 Dinesh Bandelkar 2 Comments

Problem Statement Exadata Patching failed on 1st Compute Node OS subsequently it was unable to boot. ILOM console was hanging…

Continue Reading

Posted in: Maintenance Filed under: Exadata

Oracle Database “18c New Features”

June 4, 2018 Dinesh Bandelkar 4 Comments

Perusing the Oracle 18c documentation , following are some of the riveting new database features for your reference. Private Temporary…

Continue Reading

Posted in: Oracle 18c Filed under: New Features

PeopleSoft “Integration Broker” Performance Issue after Dataguard Remote “FAR SYNC” implementation

May 29, 2018 Dinesh Bandelkar 1 Comment

Problem Statement Production database was hosted on a 6 Node RAC setup and used for PeopleSoft application. Dataguard configured with LOCAL…

Continue Reading

Posted in: DataGuard Filed under: Performance

ORA-04031: unable to allocate 352 bytes of shared memory (“shared pool”,”unknown object”,”sga heap(1,0)”,”krsdicle”)

May 24, 2018 Dinesh Bandelkar 3 Comments

Problem statement Database is recently upgraded to 12.1.0.2 version. After few days, database started terminating with ORA-04031 error consistently. Excerpts…

Continue Reading

Posted in: Database Memory Filed under: Performance

Post navigation

Page 2 of 2
← Previous 1 2
Copyright © 2018-2024 Dinesh Bandelkar
 

Loading Comments...