view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Space used by objects

Calculate the space used by a single object This script will help you calculate the size of a single object : [crayon-53f40af9f30d6610532020/] Calculate the space used by a whole schema If you want the space used by a whole schema, then here is a variation of the first query : [crayon-53f40af9f30e6161562003/]
The post Space used by objects appeared first on Oracle DBA Scripts and Articles (Montreal).

New Theme: Celsius

Today I’m happy to announce a new, free theme to spruce up your site!

Cloning pluggable database with custom snapshot

When cloning pluggable databases Oracle gives you also SNAPSHOT COPY clause to utilize storage system snapshot capabilities to save on storage space. But it works only when datafiles are placed on ACFS, ZFS Appliance over DNFS or Netapp (Oracle Multitenant Pluggable Database Snapshot Cloning: Use Cases and Supported Platforms Doc ID 1597027.1) and you also cannot unplug/drop the source PDB and you also cannot unplug the clone PDB.

My misunderstandings regarding when indexes would not be used

It is normal for bloggers including myself to post about the great things they have done  – however in this case I am blogging about why I was surprised that adding a specific index had the substantial benefits it did have.

The table contains around 32M rows, is not partitioned and is on Linux

Documentum: some useful queries (DQL/IAPI)

In this blog post I want to sharing some useful DQL and IAPI queries that I am using all the time. They are more dedicated to Documentum support/debug and grouped by components. In order to use them, I recommend Qdman: it is the best tool I know to use DQL and IAPI scripts.
1. xPlore
It regroups both the search engine and the index management.

Oracle Database Released (22 July 2014)

RSS content
Oracle Database has been released on 22 July 2014.
Following are some of the new features and options:

SQL Server 2014: DBCC CHECKDB and ReFS support

Have you noticed an interesting behavior with SQL Server 2014 when you are running a dbcc checkdb command? If not, you should have a look at this blog post. I discovered it completely by accident during some tests. If you watch carefully, you will see "weird" files appear while the dbcc checkdb command is running.
Below is a sample of the file you will find near the corresponded database file:

Introducing: Comment Likes

I’m sure we’ve all experienced this — reading through a comment thread, and seeing a particularly well-written comment, whether it be informative, insightful, or just plain funny. You want to show the commenter that you appreciate their work, but don’t have a reply for them, so you just move on. Well, those days are over!

Why Write-Through is still the default Flash Cache Mode on #Exadata X-4

The Flash Cache Mode still defaults to Write-Through on Exadata X-4 because most customers are better suited that way – not because Write-Back is buggy or unreliable. Chances are that Write-Back is not required, so we just save Flash capacity that way. So when you see this


Preventing standby databases opening in Active DataGuard mode + chopt !!!

It is long been a concern of mine that it is relatively easy to open a standby database  inadvertently and then be potentially liable to a licensing cost as usage is shown in the DBA_FEATURE_USAGE_STATISTICS view.

In fact we logged an SR on the subject based on experiences on failing over using DataGuard Broker

view counter