An interesting ‘problem’ surfaced a while ago, one where a user with zero quota on every tablespace could successfully create tables. Of course once it was time to insert data the inserts failed, but this was confusing the user creating the tables. The ‘problem’ stems from enabling deferred segment creation in the database. Let’s see how that can create a confusing situation,
Somewhere on this site is a post regarding how to validate against an XML schema…
If we are dealing with large amounts of data and have to use queries to find count of distinct values of some particular column or group of columns, the new 18.104.22.168 feature APPROX_COUNT_DISTINCT function can be significantly faster than using the traditional COUNT (DISTINCT expr) function with marginal differences in the exact result.
The examples below also show less optimizer cost overhead as well as temporary tablespace space usage as well.
If you attended my presentation at AUSOUG Perth earlier this month, or if you’ve had a peek at the slides, you may be interested in a more concrete demonstration of the ideas presented. So if you’d like to install and play with a sample application that includes a TAPI generator, feel free to download this.
I read that rolling back to a savepoint releases locks. This sounded reasonable so I decided to check it out in an Oracle 11.2 database. I logged in as user John (in blue) and noted my SID for future reference. Then I created a table, inserted a row, committed the change and created a savepoint.
FOR IMMEDIATE RELEASE NoCOUG watchers protest despicable tactics being used by NoCOUG management SILICON VALLEY (NOVEMBER 13, 2014) – Veteran NoCOUG watchers all over Northern California have been protesting the despicable tactics being used by NoCOUG management to lure Oracle Database professionals to the NoCOUG conference at the beautiful eBay Town Hall next week. Instead […]
An interesting case of ORA-600 :)
I was paged for standby lag and started looking into the issue. The db version was 22.214.171.124.0 version. Standby was lagging behind by 36 archives