|
||||
|
From 11g onwards Oraclr releasing patches without downtime requirement for some patches. Opatch command line has now an additional options called query and _is_online_patch which can be used to determine whether the patch can apply online or not. XXXXXXXX:TEST:UAT $ opatch query -is_online_patch /home/users/oracle/9877980 -invptrloc /u01/in/TEST/oracle/db/11.2.0.2/oraInst.loc Invoking OPatch 11.2.0.1.1 Oracle Interim Patch Installer […] We all know that Oracle maintain index keys as a pointers to the original rows of table and there are different types of indexes (Btree and bitmap), while what if the index entries are getting inserted either last of index leaf blocks or in between of leaf block and those leaf blocks are already full. […] My old good friend has a question, am not sure whether I have cleared when we discussed but here I made this attempt. “What is the difference between undo,flashback log, redo log files.” First Flashback log vs. Redo log 1) Flashback logs and redo log files are similar in nature 2) LGWR writes to redo […] Very old thing, but to just refresh, Ever wonder how the extent sizes is managed if your tablespace is in LMT and autoallocate as like below.
CREATE TABLESPACE large_tables DATAFILE ‘/u01/oracle/data/DB1/large_tables_01.dbf’ SIZE 100M EXTENT MANAGEMENT LOCAL AUTOALLOCATE; When you specify auto allocate, Oracle will allocate extent sizes of 64KB, 1MB, 8MB, […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!