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 […]
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 […]
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 fetches database size in MB. […]
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 […]
Step By Step Table Shrinking and Data File Resize in Oracle Due to less budget sometimes the client asks to shrink the mount point space where our datafiles exist and if developers said that the table size is getting high and due to that our database size is increasing so, in both scenarios we can […]
Recent Comments