Monthly Archives: gennaio 2016

Move listener log to another filesystem
  • 26
    Gen

Move listener log to another filesystem

Run lsnrctl command to change listener’s settings: [db000oracle@]/app/oracle/listener/log > lsnrctl Set the listener interested: LSNRCTL> set current_listener LSNR_[db_name] Current Listener is LSNR_[db_name] LSNRCTL> show log_status Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=BSCS)) LSNR_[db_name] parameter "log_status" set to ON The command completed successfully Change log_status to off so you can move the associated log: LSNRCTL> set log_status OFF Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=BSCS)) listener_[db_name] parameter...

Read More
ORACLE 12C :  Advanced Index compression
  • 7
    Gen

ORACLE 12C : Advanced Index compression

Oracle 12c rel.1 (12.1.0.2) introduced a new method for index compression called "advanced index compression" which is more effective in index compression than available methods in Oracle 11g . Creating an index using advanced index compression reduces the size of unique and non-unique indexes. Advanced index compression improves the compression ratios significantly . Advanced Index Compression is not...

Read More