|
||||
|
A user has posted me "how to find the fragmentation for a table that contains CLOB", ironically all the queries and other stuff will lead to confusion or no more useful. Honestly, to answer this question I have searched many things to clear up, only Jonathan has a clear cut demonstration and answer for […] New Background Processes that has been introduced from 12c, compared with 11.2.0.2 Database.
12 C Process Name AQPC AQ Process Coordinator ARSn ASM Recovery Slave Process BWnn Database Writer Process FENC Fence Monitor Process IPC0 IPC Service Background Process LDDn Global Enqueue Service Daemon Helper Slave LGnn Log Writer Worker LREG Listener Registration Process […] The following are the parameters are introduced newly in 12c. (Note I have compared them with 11.2.0.1 Database) Excluded _Parameters
select KSPPINM, KSPPDESC from x$ksppi where con_id=1 minus select KSPPINM, KSPPDESC from t2@Geek DBA11g order by 1,2 awr_snapshot_time_offset Setting for AWR Snapshot Time Offset cell_offloadgroup_name Set the offload group name clonedb clone database connection_brokers […] Here are the some of enhancements for Import (IMPDP) Disabling Logging for Oracle Data Pump Import You can now use the DISABLE_ARCHIVE_LOGGING Paramaeter to disable logging for table, index or both during import. Logging is not completely disable but only a small amount is generated. Also don`t forget that there is a database parameter […] Here is the list of enhancements for export datapump.
expdp Specifying the Encryption Password You can now specify silently a password during runtime. When you import a encrypted Dumpfile you can pass the Password for that file from the STDIN. The password will not visible by commands like ps or will not […] From 12c Onwards, Oracle has made some important changes to SQLloader and enhanced a lot, one of the feature was express loading with minimal configuration. You will just need to create a data file with same name as Table name and thats it no control file or other parameters required. It just default […] Hello All, I have received an email with an attachment about schema level Replication using Oracle Streams, indeed very nice and good Document. Thanks to Mr. SivaKrishna B for his efforts in preparing this nice and very well structured document , I would like to appreciate his kind gesture to share his document to all of […] From 12c Onwards, Oracle statistics gathering has been improvised and after bulk load operations the statistics will be gather automatically. Earlier, Create as select , or Insert as select operations required manual statistics gathering, where in this has been removed now. The following bulk operations is supportive for automatic statistics gather on fly. CREATE […] The ACTIVE DUPLICATE DATABASE option in 11g clone the source database by coping the full image of the data files to the auxiliary instance location through the network. This procedure doesn’t not required any pre backup existence to clone the database. However, in Oracle 12c, when ACTIVE DUPLICATE DATABASE is initiated, instead of sending the […] As discussed, earlier, Another important nice feature in RMAN from 12c is using network based recovery or incremental backup strategy from the servics. This eliminates taking incremental backups or copy those backup to standby and saves lot of time. Lets check, On Primary, check the latest log Check on Primary SQL> archive log […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!