Enable compression on table:
===================
Basic compression :
ALTER TABLE table_name move COMPRESS ;
Advanced compression :
alter table table_name move ROW STORE COMPRESS ADVANCED;
Please check other posts for compression on partition table.
The content includes guides, troubleshooting tips, and best practices for managing database environments, with an emphasis on Oracle and PostgreSQL systems. You can read the full analysis at Anuroop Challa's DBA Blog.
Subscribe to:
Post Comments (Atom)
-
SQL Tuning Task Creation ORA-13780: SQL statement does not exist. ================================================= example:- declare...
-
Shareplex some commands i will post here and update in this post with more commands later, if i provide with example so post become length...
-
ORA 700 [kskvmstatact: excessive swapping observed] ======================================== One of my database down suddenly. Reason:...
Common Oracle Clusterware crsctl commands
Oracle Clusterware crsctl commands: # Check cluster status crsctl check crs crsctl check cluster # Cluster resources crsctl status reso...
No comments:
Post a Comment