Dear Readers, Trust you are doing well, Today I am writing this post related to recent issue which we faced on one of the critical database post switchover to standby site. When I was checking AWR comparison reports to do some sanity checks, I found write IO statistics were increased […]
Finally received my first Oracle ACE program gift after waiting for almost a year 🙂 & I wear it with pride!!!! Thank you so much @oracleace & @jen_s_nicholson !!! @Oracle @AIOUG #oracledatabase #oracledba #oraclecloud #oracleace #oracledatabaseworld #thankyou #oracle
Dear Readers, Hope you are doing well & enjoying my recent articles!!! Recently I faced strange issue with one of my Database instance target on OEM. It was showing down status, though connection test was successful with no errors: Target DB version: 19.8OMS version: 12.1.0.5OEM Agent version: 12.1.0.5 PFA screenshots […]
Dear Readers, Happy new year 2021!!! This is my first day of learning PostgreSQL and I faced issue while installing version 13.1 on windows. After almost spending 3 hours of troubleshooting I was able to identify the issue & fix it. In this post will explain basic steps to install […]
Dear Readers, I have published two more articles on KT EXPERTS. This articles focuses on new DB features that have been introduced in Oracle 18C along with its significance. Oracle 18C new feature: Cancel SQL instead of killing session Oracle 18C new feature: Schema Only Account Hope u will find […]
We need sleep function many a times in our code, may be for application logic or even sometimes for monitoring purpose. We always had this available with sleep() function that resides within DBMS_LOCK ==> DBMS_LOCK.SLEEP This was always a big security risk as granting access to DBMS_LOCK will make a […]
Dear Connections, I was chatting to one of my dear friend yesterday during Sangam19 and he turned to me and asked “Why should people attend any AIOUG events”. It made me pause to think for a moment. Any type of such events is going to take up your time and […]
Recently I was performing database reorg operation on one of pre-prod environment with traditional way of table/lob movement followed by index rebuild. After moving all segments from current tablespace to new, I was ready to drop original one. SQL> select count(0) from dba_segments where tablespace_name=’MY_TABLESPACE’; Â COUNT(0) ———-Â Â Â […]
The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog. Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 22,000 times in 2015. If it were a concert at Sydney Opera House, it would take about 8 […]
Some days before I came across very weird issue with SQL Developer. One of the developer in my company was complaining that, she is getting “no rows selected” after executing some select query. According to her it was an unexpected behaviour & expecting some rows from that query. After having […]
Adityanath's Oracle Blog 