(Jeff Smith) I haven’t had time to talk about this as much as I would like to here, but I at least have some slides I can share.
Tag: Oracle
Change Item Icon Dynamically
(Jeffrey Kemp) The floating item type has an optional “Icon” property that allows you to render an icon next to the item, which can help users quickly identify what the item is for.
Types of Table Partitions in Oracle
(Jagruti Jasleniya) In this article we will see types of partitions available in Oracle.
TNS-01189
(Andrew Reid) I saw a couple of messages like this in an Oracle listener log recently:
GoLang: Querying records from Oracle Database using goracle
(brendantierney) Continuing my series of blog posts on using Go Lang with Oracle, in this blog I’ll look at how to setup a query, run the query and parse the query results.
Swapping (paging) for DBAs
(savvinov) Classic symptoms of memory pressure (free physical memory running low + swapping) are often more difficult to interpret than they seem, especially on modern enterprise grade servers.
Database Migration from non-CDB to PDB – The Minimal Downtime Challenge
(Mike.Dietrich) There are several pitfalls when you plugin a non-CDB into a CDB environment. I’d like to highlight some of them – and show you potential workarounds as well.
Index Partitioning
(Jagruti Jasleniya) In previous article we saw what is partitioning in oracle and the benefits it brings .
SORT GROUP BY NOSORT ROLLUP
(Oren Nakdimon) In the previous post we saw that the Oracle Optimizer has a special operation – SORT GROUP BY ROLLUP – for performing several aggregations of the same population in a single scan, as long as the grouping keys are in a “rollup form”; for example:
HIGH_VALUE (and other LONG columns) revisited
(Connor McDonald) Just a quick post to ensure people don’t get caught out by a recent “trick” I saw on an AskTOM question for extracting the HIGH_VALUE out of it’s LONG storage in the dictionary to a more appropriate datatype.
