Alok Giri Oracle

CREATE TABLE index_log (  owner          VARCHAR2(30),  index_name     VARCHAR2(30),  last_inspected DATE,  leaf_blocks    NUMBER,     target_size    NUMBER,  idx_layout     CLOB); ALTER TABLE index_log ADD CONSTRAINT pk_index_log PRIMARY KEY (owner,index_name); CREATE TABLE index_hist (  owner          VARCHAR2(30),  index_name     VARCHAR2(30),  inspected_date DATE,  leaf_blocks    NUMBER,     target_size    NUMBER,  idx_layout     VARCHAR2(4000)); ALTER TABLE index_hist ADD CONSTRAINT pk_index_hist PRIMARY KEY  (owner,index_name,inspected_date); CREATE OR REPLACE PACKAGE index_util AUTHID CURRENT_USER IS vMinBlks     CONSTANT POSITIVE := 1000; vScaleFactor CONSTANT NUMBER := 0.6; vTargetUse   CONSTANT POSITIVE := 90;  -- equates to pctfree 10  vHistRet     CONSTANT POSITIVE := 10;  -- (#) records to keep in index_hist  procedure inspect_schema (aSchemaName IN VARCHAR2);  procedure inspect_index (aIndexOwner IN VARCHAR2, aIndexName IN VARCHAR2, aTableOwne

Guys  go with Oracle link for more details of Oracle 18C database new featured in between I will come to you with consolidated details. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-04A4834D-848F-44D5-8C34-36237D40F194

Owo..So many features of Oracle 18C and i will share the new features soon. PDB Lockdown Profile Enhancements Refreshable PDB Switchover PDB Snapshot Carousel New Default Location of Oracle Database Password File Read-Only Oracle Home Oracle Data Guard Multi-Instance Redo Apply Supports Use of Block Change Tracking Files for RMAN Backups Automatic Correction of Non-logged Blocks at a Data Guard Standby Database Shadow Lost Write Protection Backups from non-CDBs are usable after migration to CDB Support for PDBs as Shards and Catalogs User-Defined Sharding Method Consistency Levels for Multi-Shard Queries Manual termination of run-away queries Approximate Top-N Query Processing LOB support with IMC, Big Data SQL Copy a PDB in an Oracle Data Guard Environment Online Merging of Partitions and Subpartitions Concurrent SQL Execution with SQL Performance Analyzer Database In-Memory Support for External Tables Memoptimized Rowstore Integration of Active Directory Servic