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)

PowerShell – Update-Object – Function to add/update object properties

It is not thatĀ no oneĀ could write this function. In fact, anyone could, but no one would! If someone did, everyone would use it - a function to add/update properties of an object. More precisely, a function that Adds new properties Do appropriate checks to see property existence Ignore or alert if properties are missing Default … Continue reading PowerShell – Update-Object – Function to add/update object properties