|
||||
|
Hi Hope you might have already gone through below, just in case if not. All of our developer tools/ETL tools datastage/Informatica etc. are failing with ora-28040 once we upgraded to oracle 12c. This is due to, As per Oracle, In Oracle 12.1 the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. This […] Hello All, IAOUG and APACOUC proudly announces ANZ Webinar Tour – 2017. The 2017 Webinar Tour will be running from July 3rd until August 25th with the participation of over 20 International Speakers that will be presenting over 50 interesting presentations, making it the largest webinar series ever made in the Oracle world! Registration Links […] In Previous post of the series, I have written about an overview of Oracle Sharding and its features. In this post, you will be seeing how to configure oracle shard and what steps are need to be performed. Over all, I felt its very easy to setup and configurewhen compare to RAC setup. All you […] Oracle is releasing a whistle blowing feature in distributed databases (shared nothing architecture) which has been dominated by many other databases in recent years. In upcoming release Oracle 12.2 , the Oracle Sharding feature provides the exact capability of shared nothing architecture with Leader node and shard nodes to distribute the data to nodes […] I have been asked by one of colleague (Vasu) about a weird issue, that the query returns rows in sort order in one database not in the other database. Without having much hassle, by running dbms_xplan.display_cursor(‘sql_id’,NULL,’ADVANCED) mode tell’s us the optimizer parameter “_gby_hash_aggregation_enabled” is having different values in each database. Which is mean to perform […] In earlier versions of Oracle, when one want to convert a table to partition, one must use move or export/import method and rename it. Now in 12.2 release we can use ALTER table command to convert the table into Partitioned Table. Here is sample command it is from the documentation excerpt, ALTER TABLE test_table MODIFY […] Memory & Guaranteed BufferCache/Shared Pool can be allocated at PDB Level. From the white paper here it is Well so far I haven’t seen any such need to keep a separate memory settings for each PDB as we […] Hi, You can now flashback PDB database exclusively with Local UNDO enabled. In earlier versions, Oracle shares the undo tablespace for CDB and PDB’s and creates a common view for transaction and instance recovery done at all CDB and PDB level. With local undo , Oracle has to change this a bit, it has to […] In 12.2 release, one of the coolest things that every DBA would love is to get history in SQLPLUS :). Now you can have history ON/OFF with SQLPLUS and see history SET HISTORY ON|OFF SHOW HISTORY Some other features like, FAST OPTION -F flag to set the ARRAYSIZE PAGESIZE STATEMENTCACHE all […] DBA’s , Oracle is coming with Sharding. The one killer feature that No-SQL databases claiming distributed processing with sharding aka a non-shared database storage. Now with release 12.2 Oracle releasing Sharding feature, with new command “Create Sharded Table” and with a catalog schema, well hold on second , its basically distributed partitioning relied on partitioning […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!