Oracle indexes can be tuned looking to three main characteristics: SELECTIVITY: you can calculate index selectivity using this formula: SELECT DISTINCT_KEYS/NUM_ROWS SELECTIVITY FROM DBA_INDEXES / Values range from 0 to 1, where 1 is the optimal value (UNIQUE indexes and PK), while with values near to 0 performance is lower CLUSTERING FACTOR: measures how many…
Leggi tutto
This Article show how to recover from a block failure. In this case partitioned table will be created and single block will be corrupted. · Create Table CREATE TABLE “TEST_TAB_2” ( “ID” NUMBER(10,0) NOT NULL ENABLE, “DESCRIPTION” VARCHAR2(50 BYTE) NOT NULL ENABLE, “CREATED_DATE” DATE NOT NULL ENABLE )…
Leggi tutto
Oracle connects every interaction your customer has with your brand through the Oracle Customer Experience Cloud, making your customers’ experiences simple, consistent, and relevant throughout the customer lifecycle. Oracle Customer Experience Cloud helps you strengthen relationships with your customers with a platform that optimizes relevant engagements, improves service consistency, and ensures repeatable quality for each…
Leggi tutto
Oracle is the most comprehensive cloud provider on the planet…… Read the article http://www.oracle.com/us/corporate/features/complete-cloud/index.html
Commenti recenti