#oracle_database

[oracle-dba]

Oracle GoldenGate 12c Fundamentals (upgrade to 19c included)

Special offer of Oracle DBA Courses Accept our gift coupons links for professional online courses in Oracle DBA ( unlimited access) via Udemy Platform ( offer valid till 15 October.2020)

Oracle GoldenGate 12c Fundamentals (upgrade to 19c included) 93%off (12.99$)

Discount Coupon Link: https://www.udemy.com/course/oracle-goldengate-12c-fundamentals/?couponCode=ABIDGG0920

[niranjansarade]

Oracle 12c - 32K varchar2 and native json support

With Oracle 21c released in 2020, Oracle DB has been introducing very good capabilities and features every release. 

 https://en.wikipedia.org/wiki/Oracle_Database

It had introduced extended data types since 12c version - 

https://oracle-base.com/articles/12c/extended-data-types-12cR1

Prior to Oracle 12c, regardless of the character semantics used, the maximum size of a VARCHAR2, NVARCHAR2 and RAW columns in a database are as follows.

VARCHAR2 : 4000 bytes

NVARCHAR2 : 4000 bytes

RAW : 2000 bytes

With the introduction of Extended Data Types, Oracle 12c optionally increases these maximum sizes.

VARCHAR2 : 32767 bytes

NVARCHAR2 : 32767 bytes

RAW : 32767 bytes

The extended data types functionality is controlled using the MAX_STRING_SIZE initialization parameter. The default value is STANDARD, which restricts the maximum sizes to the traditional lengths. Setting the parameter value to EXTENDED allows for the new maximum lengths. 

https://blog.dbi-services.com/12c-extended-datatypes-better-than-clob/

The above blog shows an example of less number of round trips during read when using this extended feature over LOBs.

There was also a native json support introduced with this version - 

https://oracle-base.com/articles/12c/json-support-in-oracle-database-12cr1

https://www.oracle.com/technetwork/database/sql-json-wp-2604702.pdf

Here is an article on 21c json support - https://blogs.oracle.com/sql/post/how-to-store-query-and-create-json-documents-in-oracle-database

Happy exploring !

[adismith011]

Oracle Database top-performance

Want to keep your #Oracle_Database at top-performance? If yes, then choose Cognegic’s #Remote_DBA_Services or #Database_Administration_for_Oracle to ensure the high availability of your Oracle Database. We know that, if your Oracle Database does not work fine then definitely it affects your day-to-day work and also affect your entire company’s work. If you think that you Oracle Database are not at top-performance then try to contact us via dialing our number toll-free number and get the foremost solution. And with our pricing model, the users know very well what they are exactly getting through our support. Contact our professional experts through: Oracle Database System Online Oracle DB Support Oracle Database Solution For More Info: https://cognegicsystems.com Contact Number: 1-800-450-8670 Email Address- info@cognegicsystems.com Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801