|
||||
|
EZConnect is something very useful to make fast connection calls without requiring a TNS. Problem is that, until now, if you want to use some value pairs likes SDU, RETRY_COUNT, CONNECT_TIMEOUT, this wasn’t possible and you would end-up using TNS. Now in 19c you will be able to write something like: sqlplus user/pwd@//DB:1521/host?connect_timeout=100&transport_connect_timeout=10&retry_count=3 […] SecureFiles Defragmentation SecureFiles defragmentation provides online defragmentation of allocated and freed space in SecureFiles segments, for all types of SecureFiles LOBs – compressed, deduplicated, encrypted. Defragmentation can be done automatically by a background process, and the segment advisor can estimate the fragmentation levels and how much space can be saved. Defragmentation can […] Please watch the latest videos on installing kubernetes using Vagrant box on your laptop and practice for your devops stuff. Pre-req Install vagrant on your laptopGet an account on container-registry.oracle.comDownload https://github.com/oracle/vagrant-boxes repository Navigate to the git repo that is downloaded and just run On Command prompt, cd <folder>/kubernetes vagrant up master once the machine […] Thanks to Vasu N for sharing the details and discussing on this. Issue with parallel hint on 19c CDB database where the hint is not honored and going for serial scans. Apparently seems to be Oracle bug Bug 30618478 – UPGRADE : SQLS WITH PARALLEL HINT RUNNING SERIALLY INTERMITTENTLY. Here is the test case for […] Starting 20c, One can keep expression in Initialization Parameters. some examples from documentation as below Initialization parameter expressions can contain the following constructs:Integer values OLAP_PAGE_POOL_SIZE = 1073741824 Decimal values, only when they are part of a numeric operation CPU_COUNT = 8 * 0.6 If the operation resolves to a decimal value, then the result […] In oracle 20c, JSON is a new SQL and PL/SQL data type for JSON data. The data is stored in the database in a binary form for faster access to nested JSON values. You can use JSON data type and its instances in most places where a SQL data type is allowed, including: […] In Oracle 19c, one can submit the DML to readonly standby database. the internals of the database detect a dml on standby and redirect that dml to primary apply it on primary and apply to standby back. However this require careful consideration of redo generation and identify the potential dml’s or occasional dml;s that […] As per recent update in blogs.oracle.com, Oracle is planning to include a Standard Edition High Availability solution with Oracle Grid Infrastructure that provides cluster-based failover for Standard Edition Oracle Databases using Oracle Clusterware. Image Source: Blogs.oracle.com This will help customers who are on standard edition license to level high availability features that are […] Autoupgrade is compatible with 12.2 and 18.5 and you need to download the kit from 2485457.1 Autoupgrade.jar is available default in 19c How this works Prevent Issues : Analyze and Fixup Modes java -jar autoupgrade.jar -config config.txt -mode analyze java -jar autoupgrade.jar -config config.txt -mode fixups Simplifying […] In order to duplicate a database one must use rman duplicate command or manual procedure to copy and restore the files From 19c, DBCA facilitates duplication of db with new “CreateDuplicateDB” Requires easy connection string so that it duplicates the target db to wherever running § From 19c, ability to […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!