(Hemant K Chitale) How does 12.1.0.2 ASM handle adding a disk of a different size to an existing DiskGroup ?
Tag: Oracle
Online Redo Log Switching from RMAN Backup
(mdinh) I was troubleshooting backup from standby databases and encountered an oddity which I wanted to verify.
Little things worth knowing: Can I Smart Scan a Global Temporary Table?
(Martin Bach) A question that has come up while preparing to deliver another Exadata Optimisation Class is whether you can offload queries against Global Temporary Tables (GTT) or not. There are subtle differences between heap tables and GTTs such as how statistics are handled and where they are sto
Adaptive Cursor Sharing
(advait) Adaptive cursor sharing was introduced by Oracle in 11g release 1 as a way to generate best plan for a SQL in all situation. Prior to adaptive cursor sharing, optimizer used to generate a single plan for a SQL statement and that plan is used by all cursors of that SQL_ID.
Attribute clustering (part 3)
(connormcdonald) So in part1 and part2, we looked at creating tables with clustered data. If you’re ready to climb aboard the attribute clustering heading toward Fastville Smile you might want to take an existing table and cluster it.
Oracle CUME_DIST Function with Examples
(Ben) In this article, I’ll cover what the Oracle CUME_DIST function is and show you some examples.
Configure Oracle EBS integrated soa gateway for SOAP services on 12.2.6
(Mohamed Azar) Here I am going to explain how to configure Oracle EBS integrated soa gateway for SOAP services on 12.2.6.
‘That STILL Ain’t Right’
(David Fitzjarrell) In a recent post to an Oracle forum a query was presented and a tuning request was made. It appears that the query was taking 20 hours to complete.
Ordering & Formatting Date Columns in APEX
(Scott Wesley) Quite often I’ll find I’d like to display a date with the time in a column within an APEX report, but you end up wondering how to control the wrap.
Oracle VARIANCE Function with Examples
(Ben) In this article, I’ll explain what the Oracle VARIANCE function is, and show you some examples.
