Oracle 23c New Features for DBA'sLinux 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 […] Came across a note to recreate the trace (.trc) files that have been accidentally deleted. But please be noted that information written down before deletion of trace may or may not be available in the new file you have created. However this may help in some cases where the process is still trying to write […] Does dbms_stats collects statistics for invisible indexes? The answer is yes, Although the invisible indexes does not used by optimizer but they should be ready when it needed, hence the dbms_stats collects the statistics on the invisible indexes too. Here is small test case.
SQL> select to_char(last_analyzed,’YYYY-MM-DD HH24:MI:SS’), VISIBILITY from dba_indexes where index_name=’IDX_MTD’; […] |
||||
Follow Me!!!