Converting Varchar Date Strings to Date Types in Oracle
Introduction
Overview
In Oracle databases, date and time values stored as varchar types often need to be converted into proper date formats for operations like comparisons and calculations. This article explains how to utilize the TO_DATE functon to transform string representations of dates into date types within Oracle.
Background
In many appl ...
Posted on Thu, 07 May 2026 11:18:13 +0000 by madspof
Optimizing Oracle Undo Tablespace Configuration and Monitoring
Identifying Undo Tablespace Issues
When an Oracle database's undo tablespace consistently exceeds 85% utilization despite repeated expansions, it raises questions about actual space requirements and proper configuraton. Key metrics to examine:
SELECT a.tablespace_name,
ROUND(a.bytes/1024/1024/1024, 0) "total_GB",
ROUND(( ...
Posted on Thu, 07 May 2026 10:24:19 +0000 by dicamille