SQL Server: Quick Space & File Layout Analysis With PowerShell and PowerBI

Long time ago, I created a little chunk of TSQL to get a glimpse of my space and file layout information at the Database/File/Filegroup level. It is a basic routine that spins through all the databases of an instance to collect space usage data. Over the years, I have used it a lot and it … Continue reading SQL Server: Quick Space & File Layout Analysis With PowerShell and PowerBI

Advertisements

Oracle: Find The Total Size Of All Of Your CLOB & BLOB Columns In All Tables

Today I received a request from an application owner who wanted to know the size of all the CLOB and BLOB columns in all the non-system tables so that they have a good idea of the size involved for a migration. Tables with BLOB/CLOB columns The SQL to find the tables with the BLOB/CLOB columns … Continue reading Oracle: Find The Total Size Of All Of Your CLOB & BLOB Columns In All Tables

Oracle – Quick Tip – Find Table & Index Size (SQL Server Equivalent Of sp_spaceused)

Often, a common requirement would involve determining the space usage by an Oracle table and/or index. Knowing that the information in stored in the system views, we can query for the size as follows (just substitute the table name): OWNER TABLE_NAME INDEX_NAME SIZE_MB MY_TABLE_OWNER MY_TABLE_NAME 3929 MY_TABLE_OWNER MY_TABLE_NAME MY_TABLE_NAME_PK 436 MY_TABLE_OWNER MY_TABLE_NAME MY_TABLE_NAME_IDX02 379 MY_TABLE_OWNER … Continue reading Oracle – Quick Tip – Find Table & Index Size (SQL Server Equivalent Of sp_spaceused)