|
||||
|
Hello, If some one asks you about difference between Rebuild and coalesce indexes, here is the short list of the same. Rebuild Index Coalesce Index Quickly moves index to another tablespace Cannot move index to another tablespace Higher costs: requires more disk space Lower costs: does not require more disk space Creates new tree, shrinks […] Here you go, http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html I love to see the documentation first. Started downloading Linux version 12.1.0.1 is available for download at edelivery.oracle.com Answer 10g No, 11gR2 Yes 10g:- SQL> select * from v$version; BANNER ——————————————————- Oracle Database 11g Release 10.2.0.5.0 – Production PL/SQL Release 10.2.0.5.0 – Production CORE 10.2.0.5.0 Production TNS for 32-bit Windows: Version 10.2.0.5.0 – Production NLSRTL Version 10.2.0.5.0 – Production SQL> create table test as select rownum id, ‘TEST’ name from […] Have you ever heard of archive backups in 11g, if not here it is, Normally to make sure that database can be brought up from a particular backupset rman will retain all archived redo logs as well which are necessary. This happens because rman also considers the option that you may want to consider […] In 11g there are two major enhancements to restore points 1. Create restore point as of scn, until 10g you can create a restore point with current scn only SQL> create restore point p1 as of scn 19393930; 2. Preserve the restore points SQL> create restore point p1 preserve; The second point above need […] Got this architecture diagram from the internet for 12c database
Source:- Some explanation according to my understanding:- 1) Oracle SGA is shared between multiple databases called Pluggable databases (PDB) 2) A root database called container database which holds all the Oracle dictionary globally (CDB) shareable across PDB’s 3) Listener registers both CDB instance […] Here is the step by step document for recovering the standby if archive is missing and not recoverable, using a feature called rollforward standby using incremental backup introduced in 10g. 1) After recovery in step above login to sqlplus and get the current scn from standby database; SQL> col CURRENT_SCN format 999999999999 SQL> select current_scn […] We have got into a trouble today with dba_hist_sqlstat when we are working on a performance issue. This performance issue is about a statement that running very slow compared to its previous run of 20 mins. Thats another story. As this story continues yesterday and today, we found our sql statement comfortably in v$sql […] Just to note if anyone need, Difference between shrink space/compact/cascade Shrink space compact -Just moves the rows from end of the table to beginning of the table. Does not drop the high water mark of the table. Shrink space – Moves the rows from end of the table to the beginning of the table […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!