Tuesday, August 27, 2013
How to get size of all tables in an Oracle database schema
If you ever wanted to know how what's taking space in an Oracle database, or how large is the table you're working on, here's a script which answers these questions. It shows the size of all the database objects large than 10 Mb in a particular database schema.
Subscribe to:
Posts (Atom)
Popular Posts
-
If you ever wanted to know how what's taking space in an Oracle database, or how large is the table you're working on, here's a...
-
A few days ago I installed Oracle Linux in an Oracle VirtualBox VM. Once it was installed I found that eth0 interface wasn't starting up... -
I recently switched to Oracle SQL Developer for my PL/SQL development needs. I have mixed feeling about SQL Developer: it's been in dev...
-
In March 2010 I went to Cebu Island of the Philippines with a group of Russian freedivers. This is my diary of what happened there. It is a ... -
This tutorial explains how to record the output of one MIDI track (for example, arpeggiator’s output) into another MIDI track. Although FL... -
The Composing and Producing Electronic Music course is finally over. I learned a lot over the past 12 weeks on topics like sound design, h... -
The assigmnent for week 2 of Composing and Producing Electronic Music was to make a drum groove for a Drum'n Bass track. Here'...
-
The next day, having arrived at Club Serena at 8 am, I discovered that the yoga had already started. I asked, and it turned out it started a... -
It's been quite some time since I wrote these lines. And, perhaps, if I were writing this now, I wouldn't write it in the same way -... -
All database applications can be divided into 2 classes: OLTP and data warehouses. OLTP stands for Online Transactions Processing. It’s ...
