How to obtain the database size of a PostgreSQL Server instance? Continue reading “Database size of a PostgreSQL server instance”
Tag: DBA
SQL Server Error: 15023
When we are restoring a database in a different SQL Server instance, it could happen that there is a Login with the same name of an existing user in the database. Continue reading “SQL Server Error: 15023”
Listing all columns from an Oracle database
In this short post, we are going to learn how to list all columns of every table in an Oracle database.
We want to get the name of the column, the name of the table it belongs to and the type of date for that column. Continue reading “Listing all columns from an Oracle database”
Tablespace size of an Oracle Database
How can I know the size of my Oracle Database? What is the size of the Tablespaces in an Oracle Database?
An Oracle database stores the data in logical units called Tablespaces. Therefore, to know the size of the whole instance you need to know the size of each tablespace. Continue reading “Tablespace size of an Oracle Database”