Tuesday, March 31, 2020

What is the difference between real-time apply and real-time query?

›
Real-time apply is the process of applying the redo in the current standby redo log file as it is being filled , in contrast to waiting fo...
Wednesday, March 25, 2020

How to list index subpartitions and their sizes

›
SELECT IDXSUBPART.INDEX_OWNER, IDXSUBPART.INDEX_NAME, IDXSUBPART.PARTITION_NAME, IDXSUBPART.SUBPARTITION_NAME,IDXSUBPART.TABLESPACE_NAME, ...
Tuesday, March 24, 2020

How do you move an index organized table?

›
The following index needs to be moved from tablespace DATA1 to tablespace DATA2: select unique segment_name,segment_type,tablespace_name...
Friday, March 20, 2020

A function that shows schema size in PostgreSQL

›
Thanks to Emanuel Calvo for publishing this procedure. I put it in a script: SET search_path TO public; SHOW search_path; CREATE OR REP...

Comparing users, schemas, instances and databases between Oracle and PostgreSQL

›
If you have to deal with both Oracle and PostgreSQL databases in your daily work, it can be confusing to deal with terms such as users, sch...
Wednesday, March 18, 2020

How to display a run-time parameter in a postgreSQL instance

›
Like with Oracle, PostgreSQL has an easy way to display run-time parameters: [postgres@oric-pg01~]$ psql psql (11.7) Type "help...
Monday, March 16, 2020

How to specifiy default compression for a tablespace

›
CREATE BIGFILE TABLESPACE star_data DATAFILE '/oradata/proddb01/star_data.dbf' SIZE 1024M AUTOEXTEND ON NEXT 128M MAXSIZE 12T ...