TABLESPACE

Tablespaces in PostgreSQL 0 (0)

June 9, 2021

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….

Loading

📌
4💬 read more

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

November 7, 2020

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…

Loading

📌
0💬 read more

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

October 13, 2020

How to Check Temp Tablespace Usage in Oracle Below is SQL query to find out temporary tablespace utilization of the database. Mountain climber | Exercise Videos & Guides | Bodybuilding.com…

Loading

📌
0💬 read more

How to check tablespace size. 5 (2)

October 8, 2020

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…

Loading

📌
0💬 read more

TABLE SHRINKING AND DATA FILE RESIZE in Oracle 5 (1)

September 19, 2020

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…

Loading

📌
2💬 read more