Connecting to Oracle without installing the Instant Client
Thin mode is the default and needs no native client, and the field people get wrong is the one Oracle actually connects to: a service, not a database name.
5 posts
Writing on Oracle
Pooled connections with introspection and monitoring through the ALL_* and DBA_* data-dictionary views. Where it stops: Agent mode is unavailable here. Operate still reads the server's own reporting interface.
Two Oracle types that lose information on the way to a grid
A wide NUMBER arrives as a double and drops digits, and a timestamp with a zone folds its offset into UTC, so both are recorded rather than smoothed over.
Why there is no Explain action on an Oracle connection
Oracle has EXPLAIN PLAN and DBMS_XPLAN; what is missing is a two-statement wrapper, so the capability is declared false and the action is hidden.
Oracle monitoring depth is a privilege question
A least-privilege application user gets a dashboard that renders with gaps, because each dynamic-view read is guarded on its own rather than as one block.
Oracle diagrams are scoped to the connecting user
Five bulk dictionary reads build the tree regardless of table count, and every one of them is filtered by owner, so other schemas are simply not drawn.