Author

Yukti Kharche

Solution Architect

Yukti Kharche is a Solutions Architect at Tessell with over 14 years of hands-on experience in enterprise database management, solution design, and technical project coordination. Her background as a senior Oracle DBA and Build Engineer spans installing, upgrading, and optimizing complex database estates across diverse operating systems, web application servers, and cloud environments. Throughout her career, Yukti has specialized in leading mission-critical database migrations and upgrades, guiding legacy systems onto modern platforms while prioritizing minimal downtime, performance gains, and strict data integrity. As a technical contributor, Yukti leverages her deep operational background to share practical architecture guides, migration frameworks, and database optimization strategies for database administrators and cloud infrastructure teams

Featured

Beyond Native Partitioning: Managing Time-Based Data on Oracle SE2

Oracle Standard Edition 2 does not include native partitioning, so time-based tables that grow continuously have to be split by hand. This post covers a framework we built for a utilities customer: monthly child tables exposed through a single UNION ALL view, with INSTEAD OF triggers routing DML to the correct table and a PL/SQL package handling creation, privileges, synonyms, and retention. It delivers most of the operational benefit of partitioning without an Enterprise Edition upgrade, but without optimizer-level partition pruning.

Latest from Author

Beyond Native Partitioning: Managing Time-Based Data on Oracle SE2

Architecture & Security

Showing 1–1 of 1 results