Technology – Page 9 – clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases

Oracle 13c cloud control agent installation

debasis maity / February 13, 2018

OMS Server: Where runs the Enterprise Manager Middleware Client Server: Where we’re going to install the agent 1.Pre-requisites setup to […]

Oracle PGA (Program Global Area) in 12c

debasis maity / February 9, 2018

What is PGA The Program Global Area (PGA) is a private memory region that contains the data and control information

General Performance tuning

Clustering Factor and it’s effect on non-assm and assm tablespace

debasis maity / February 5, 2018

Clustering Factor and it’s effect on non-assm and assm tablespace. The clustering factor is a measure of the ordernesss of

General DBA, General Performance tuning

Index in 12c by example test case

debasis maity / February 4, 2018

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

debasis maity / February 1, 2018

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

debasis maity / January 22, 2018

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

debasis maity / January 22, 2018

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