Clustering Factor and it’s effect on non-assm and assm tablespace
Clustering Factor and it’s effect on non-assm and assm tablespace. The clustering factor is a measure of the ordernesss of […]
General Performance tuning
General DBA, General Performance tuning
Index in 12c by example test case
A. B-Tree Indexes I have discussed more details in the below blog. http://clouddba.co/index-internal-oracle-using-simple-test-case/ B.Invisible Indexes Deciding which columns to index
General DBA
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
General Performance tuning
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
General Performance tuning
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
Technology
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
Installation, oracle 12c
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
oracle 12c
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
security
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
SCRIPTS
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