Feb 4, 2016
If you ever want to know, in Oracle database, how much space you have used up so far (in terms of GB) by all of the objects in your schema, you can use the below SQL
seen from United Kingdom
seen from Russia
seen from Bangladesh
seen from United States
seen from United States
seen from T1
seen from China
seen from France
seen from United Kingdom
seen from Türkiye
seen from Vietnam
seen from China
seen from China
seen from Malaysia
seen from United States
seen from T1
seen from China
seen from United Kingdom
seen from France
seen from Germany
If you ever want to know, in Oracle database, how much space you have used up so far (in terms of GB) by all of the objects in your schema, you can use the below SQL
Data Compression– a unique feature of SQL Server TIP #91
Data Compression– a unique feature of SQL Server TIP #91
A part from performance many times we faced challenges related to space of our database. Sometimes our database is actually taking huge space and sometimes it our mistake due to which it took space.
It is worst condition when you are on a dedicated hosting or cloud hosting with limited space. In such case “Compression” is one of the best option.
This feature introduce in SQL SERVER 2008 onwards…
View On WordPress