Index in 12c by example test case
A. B-Tree Indexes I have discussed more details in the below blog. //clouddba.co/index-internal-oracle-using-simple-test-case/ B.Invisible Indexes Deciding which columns to index…
7 years ago
Index internal oracle using simple test case
Index internal oracle using simple test case First of all I will create a table with char(1000) so that in…
7 years ago
How histogram can affect query plan change hence performance
How histogram can affect query plan change hence performance. 1.Let me create a test case.I am loading the table with…
7 years ago
Poor index identify and resolve manually or using sql tuning advisor
1.Let us create a test case first:- oracle@TST:TESTDB1[/home/oracle]$ sqlplus c##test/test C##TEST@TESTDB1> create table mytst1 as select * from dba_objects; Table…
7 years ago
RAC one node to another node clone if another rac crash due to file deletion or permission change in grid home
1. On the source node to target node, create a copy of the Oracle Grid Infrastructure home. For example, as…
7 years ago
Installation of Oracle 12c RAC Flex cluster infrastructure on Virtual Box
Introduction This document will help to guide you for installation of Oracle 12cR1 RAC Flex cluster infrastructure on Virtual Box…
7 years ago
EXPDP and IMPDP command reference 12c
A.Very useful method to upgrade 11gR2 to 12c using transportable=always Full transportable export/import is a new feature in Oracle Database…
7 years ago
Oracle Database Audit FGA using SYSLOG to capture
Oracle Database Audit using SYSLOG to capture Oracle Database can be configured to log events into a database table, XML…
7 years ago
Script for checking tablespace growth
with t as ( select ss.run_time,ts.name,round(su.tablespace_size*dt.block_size/1024/1024/1024,2) alloc_size_gb, round(su.tablespace_usedsize*dt.block_size/1024/1024/1024,2) used_size_gb from dba_hist_tbspc_space_usage su, (select trunc(BEGIN_INTERVAL_TIME) run_time,max(snap_id) snap_id from dba_hist_snapshot group by…
7 years ago
Script to clean or truncate unified audit record table
exec dbms_audit_mgmt.clean_audit_trail(audit_trail_type=>dbms_audit_mgmt.audit_trail_unified, use_last_arch_timestamp=>FALSE);
7 years ago