Author: Navneet

How often do we see wrong use of to_char on date fields and causing huge performance impact? Just saw a query with date field in where condition with to_char conversion with compared to a date value in string. It was a billion rows table and a simple count of rows was taking 3 hours to… Continue reading To_char a date field and keep waiting for the results

There was an Incident reported today where suddenly one of the job started working slow. Actually, it was working slow since couple of weeks now and since the final output of the job was to download a file, initial focus was to troubleshoot on the application side of the things to see if something has… Continue reading Why collecting Database object growth trend is important?

How often do you see this error in your database alert log file when you have “db_recovery_file_dest_size” parameter configured and Archive log destination is set to use Recovery File Destination. There is no harm or problem in this approach as long as you are following all the right practices of cleaning up the FRA/Recovery destination.… Continue reading ORA-19815: WARNING: db_recovery_file_dest_size of xxxxxx bytes is 100.00% used, and has 0 remaining bytes available.

Issue/Problem: Pluggable database opens in Restricted Session Mode after being created from an XML file/image. User logins receive following Error ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege Cause: Pluggable database is created/Re-build from existing XML file (Which might have been used in past without an issue). Creation of PDB ran without an… Continue reading Database option SDO mismatch: PDB installed version 12.1.0.2.0. CDB installed version NULL

AIOUG’s 1st regional Chapter, North India Chapter is bringing you the 1st Tech Meet(Tech Day) of 2018 in NCR. RAC Internals & Machine Learning – By Sandesh Rao Sandesh Rao is a VP running the RAC Assurance Team within RAC Development at Oracle Corporation specializing in performance tuning , high availability , disaster recovery and… Continue reading North India Chapter – 1st Tech Meet 2018

SQL Developer is a powerful tool for both Developers and DBA’s. With every new version and release, Oracle is making sure that SQL Developer becomes more and more powerful that can bridge gap between DBA and a Developer. It is no longer just a Developer’s Friend. Its horizon has increased many folds and I would… Continue reading SQL Developer – Common Friend of DBA’s and Developers

AIOUG and North India chapter concluded yet another event in North India and this time it was AIOUG’s Yearly 1 day technical Event OTN Yathra. It was held at Fidelity Gurgaon this time on 25th June 2017, Sunday. As North India Chapter Team, We truly thanks everyone of you who spared out time on all… Continue reading OTN Yathra 2017 – Gurgaon

Link to my paper on one of the issue that I faced in work. This was regarding one of the Custom query from Peoplesoft and an example of how a wrongly placed although logically correct Table in the join can make your query perform really bad. Query tuning – Fixing it semantics way from Navneet… Continue reading Query Tuning – Semantic Way

How often we have seen that We delete some Oracle Datafile or move a datafile (specifically Online Move in Oracle 12c) from one disk to another disk to release space on one of the Disk Mount point but even after successful move or delete, you do not see space getting free’d up. Without going into detail… Continue reading Releasing Disk Space after deleting file on Linux

— fsp.sql rem ———————————————————- rem Created by Navneet Upneja rem rem fsp.sql (Have to be executed as SYS User) rem rem Purpose: Flush Shared Pool just for 1 SQL ID in connected Instance rem analyzed rem rem ————————————————————- set define on define Enter_SQL_ID = ‘&1’; declare v_sql_id varchar2(20) := ‘&Enter_SQL_ID’; begin dbms_output.put_line(‘&1′); for i in… Continue reading Script to Flush Single SQL Statement from Shared Pool