|
||||
|
Yes for for Temporary Tables. Here is the excerpt from the documentation:- By default, undo records for temporary tables are stored in the undo tablespace and are logged in the redo, which is the same way undo is managed for persistent tables. However, you can use the TEMP_UNDO_ENABLED initialization parameter to separate undo for temporary […] 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 […] 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 […] 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’; […] Its more than 3 years 11g has released, still looking or finding something new every day or other. Today its the Parallel Hint that I came across from the documentation. Many has already blogged about this, still I am writing the same for my readers and Until 10g, the parallel hint behaviour is like […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!