oracle

Querying tables over database link is very common today. But what happens when we have a table that depends on one or more user defined types? Oracle needs to know the structure of our table and it’s columns when it receives it over the DB link. However, it cannot retrieve that information from remote server … Read moreQuery user defined types over database link

I just found a strange behavior in one of our PL/SQL procedures that is designed to load the data from external tables (files that arrive on the server). During one run, I noticed that “session PGA memory” was constantly increasing which made me look for a leak in the first place. To cut the very … Read moreMemory leak when changing external table location

I just noticed that gathering statistics on one table partition with above command actually does a full table scan of the whole table (all partitions) instead of gathering only for partition PART2. The command took way too long than it should, which caused me to look at what it was doing. And it appears that … Read moregather_table_stats granularity

This wait occurs when there is an unhandled exception in the SQL or PL/SQL code that is being run and en error is being raised. Each error counts as two waits. One for break and the other one for reset.