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).
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.
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 184.108.40.206
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.
It regroups both the search engine and the index management.
Oracle Database 220.127.116.11 has been released on 22 July 2014.
Following are some of the new features and options:
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:
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!
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
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
In fact we logged an SR on the subject based on experiences on failing over using DataGuard Broker