Blog / People and Culture Blog
How to change Oracle Database NLS DATE FORMAT
Here is the below statement.
alter system set nls_date_format=’dd.mm.yyyy hh24:mi:ss’ scope=spfile
Related blogs
Database Blog
Dataguard manual switchover
Introduction Oracle Data Guard plays a pivotal role in ensuring business continuity by maintaining synchronized standby databases that can seamlessly take over…
People and Culture Blog
Troubleshooting Query Plan Optimization Using Query Store
Introduction SQL Server Query Store is enabled to assist in monitoring query performance and identifying query plan regressions. Query Store captures a history…
People and Culture Blog
When tempdb Won’t Shrink
Introduction In SQL Server, the tempdb system database can grow significantly due to heavy workloads, temporary objects, or large queries. Sometimes, even after…