Practical engineering notes based on hands-on database, cloud, and AI work. Browse the articles by technology area.
A practical workflow for investigating slow SQL using runtime plans, estimated versus actual rows, partition statistics, ASH/AWR, and optimizer evidence.
Read article →An example of separating SQL*Plus client errors from Oracle database and PL/SQL compilation errors during a deployment.
Read article →How separating NOMOUNT, MOUNT, and OPEN—and checking ASM, alert logs, and trace files—helps reduce the troubleshooting scope.
Read article →Why AUTOEXTEND does not necessarily mean a datafile still has room to grow, and what to check before changing a tablespace.
Read article →How Oracle documentation, retrieval, vector search, and OCI Generative AI can be combined into a focused technical assistant.
Read article →A practical look at tool declarations, automatic tool selection, JSON arguments, execution, and returning tool results to the model.
Read article →Lessons from integrating the OCI Python SDK, selecting on-demand models, building chat requests, and normalizing nested responses.
Read article →An end-to-end architecture for chunking technical documentation, retrieving relevant context with vector search, and generating grounded answers.
Read article →