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
Oracle DBA
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
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
oracle 12c
Upgrade of Oracle 11g RAC database to Oracle 12c RAC DBUA
This document will help you providing guideline to upgrade Oracle 11g RAC to Oracle 12c RAC clusterware and Database .
Dataguard, Troubleshooting
ORA-01111: name for data file is unknown – rename to correct file
Error in dataguard alert log/start managed recovery process:- SYS@XXX>alter database recover managed standby database; alter database recover managed standby database