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 States
seen from China
seen from United States
seen from United States
seen from United States
seen from United States
seen from United States
seen from United States
seen from United States
seen from United States
seen from Hungary
seen from Germany
seen from Malaysia
seen from United States
seen from United States
seen from Netherlands
seen from Malaysia
seen from United States
seen from United States
seen from Russia
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