0 Comments

Tablespaces in PostgreSQL 0 (0)

Tablespaces in PostgreSQL A tablespace allows superusers to define an alternative location on the file system where the data files containing database objects (such as tables and indexes) can reside. The tablespace name must be distinct from the name of any existing tablespace in the database cluster. PostgreSQL uses a tablespace to map a logical […]

 288 Total Views,  1 Views Today

0 Comments

How to add datafile into tablespace in Oracle 4.5 (2)

Add datafile into tablespace in Oracle Most of the time due to the application’s DML operation, tablespace crosses their threshold. As everyone knows it’s a critical scenario, if we ignore/skipped adding space into tablespace it may cause the application at a hung state or the database to a hung or down. To avoid this cause […]

 912 Total Views,  2 Views Today

Spread the Knowledge!

0 Comments

How to Check Temp Tablespace Usage in Oracle 0 (0)

How to Check Temp Tablespace Usage in Oracle Below is SQL query to find out temporary tablespace utilization of the database. which includes Tablespace name(Temp tablespace), Total size, Used size, and Free size. SQL command which fetches Temp tablespace size in GB. Click here to get sample output. SQL command which fetch database size in MB. […]

 768 Total Views,  1 Views Today

Spread the Knowledge!

0 Comments

How to check tablespace size. 5 (2)

Below sql query is used to find total tablespace size of your database. which includes Tablespace name used size in MB, free size in MB and Total size in MB Sql command which fetch tablesapce size in GB Click here to get sample output We always encourage the technical person to visit section SCRIPTS to get more […]

 1,126 Total Views,  2 Views Today

Spread the Knowledge!