Oracle

  1. Home
  2. Oracle
    3. (
  3. Page 4
    4. )
by Team Ajara

How do I check if the Oracle options/packs are used?

Usage Statistics of the Oracle options/packs.   Step 1: connect to support.oracle.com Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1) download the options_packs_usage_statistics.sql script
by Team Ajara

Options and Packs in Oracle Database

What are the Options and Packs in Oracle Database? Advanced Compression Partitions OLAP – Online Analytical Processing RAC – Real Application Clusters Diagnostic Pack Tuning Pack Spatial Note: Except Spatial,
by Team Ajara

How to Verify Advanced Compression in Oracle

Verify Advanced Compression usage in Oracle: Step 1: Verification in Tables: SQL> col owner form a15 SQL> col TABLE_NAME form a32 SQL> SELECT table_name,compression,compress_for FROM dba_tables 2 where compression=’ENABLED’; no
by Team Ajara

Restoring COLD backup in the same location

Restoring COLD backup in the same location. Scenario with Networker Media Manager. Step 1 : Move SPFile for scenario purpose: [oracle@oratst0001 dbs]$ mv spfilevirtualdb.ora spfilevirtualdb.ora2 [oracle@oratst0001 dbs]$   Step 2
by Team Ajara

How to disable diagnostic and tuning pack

To disable diagnostic and tuning pack : Step 1) show parameter control; Step 2) alter system set control_management_pack_access=none scope=both; Step 3) show parameter control; We can see the disabled diagnostic
by Team Ajara

Partitioning table based on Quarter

How to create and maintain a quarterly partitions for a Table?   Range partitions Creating a table with Quarterly Partitions CREATE TABLE "STG"."QPT" ( "QPT_NBR" NUMBER(*,0), "START_DT" DATE ) TABLESPACE
by Team Ajara

Partitioning table based on Month

How to create and maintain a monthly partitions for a Table?   Range partitions Creating a table with Monthly Partitions CREATE TABLE “FORM_STG”.”QPT” ( “NBR” number, “FORM_DATE” DATE ) PARTITION
by Team Ajara

Recovering NOLOGGING Tables and Indexes Scenario

Recovering NOLOGGING Tables and Indexes Scenario.   Step 1: Create table and insert data. ================================================== SQL> alter table pqrs.xyz nologging; Table altered. SQL> insert into pqrs.xyz values (20); 1 row
by Team Ajara

Recovering After the Loss of Archived Redo Log Files

Recovering After the Loss of Archived Redo Log Files Scenario: Step 1: Verify Archives: SQL> archive loglist =========================================================== SQL> select 1* select NAME,ARCHIVED,DELETED,STATUS from v$archived_log SQL> / NAME ARC DEL