Database Technology

Tuesday, October 8, 2024

script to find out table part of the datashare in AWS redshift

script to find out table part of the datashare in AWS redshift:

SELECT share_type,

btrim(share_name)::varchar(16) AS share_name,

object_type,

object_name

FROM svv_datashare_objects

WHERE share_name='<share_name>'

AND object_name LIKE '%<table_name>%'

ORDER BY object_name;

Friday, June 7, 2024

script to find out user part of which group in AWS Redshift

script to find out user part of which group in AWS Redshift:

you just need to feed the username and script will provide associated group name

SELECT

pg_group.groname

,pg_group.grosysid

,pg_user.*

FROM pg_group, pg_user

WHERE pg_user.usesysid = ANY(pg_group.grolist)

AND pg_user.usename='<user_name>'

ORDER BY 1,2 ;

script to find what are the users associated with group in AWS Redshift

script to find what are the users associated with group in AWS Redshift:

select usename

from pg_user , pg_group

where pg_user.usesysid = ANY(pg_group.grolist) and

pg_group.groname='<group_name>';

Monday, May 20, 2024

How to disable automatic restart of the cluster services in oracle RAC

login as root user in linux server and check the status of cluster resources

1)# ./crsctl status resource -t

stop all the services

2)[root@<server_name> bin]# ./crsctl stop cluster -all

3)disable the automatic restart of the cluster

[root@<server_name> bin]# ./crsctl disable has

***************************************************

[root@<server_name> bin]# ./crsctl status resource -t

--------------------------------------------------------------------------------

Name Target State Server State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.SHARED.advm

ONLINE ONLINE <server_name> Volume device /dev/a

sm/shared-500 is onl

ine,STABLE

ora.DATA.dg

ONLINE ONLINE <server_name> STABLE

ora.FRA.dg

ONLINE ONLINE <server_name> STABLE

ora.LISTENER.lsnr

ONLINE ONLINE <server_name> STABLE

ora.asm

ONLINE ONLINE <server_name> Started,STABLE

ora.data.shared.acfs

ONLINE ONLINE <server_name> mounted on /shared,S

TABLE

ora.net1.network

ONLINE ONLINE <server_name> STABLE

ora.ons

ONLINE ONLINE <server_name> STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE <server_name> STABLE

ora.LISTENER_SCAN2.lsnr

1 ONLINE ONLINE <server_name> STABLE

ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE <server_name> STABLE

ora.cdb1.db

1 OFFLINE OFFLINE Instance Shutdown,ST

ABLE

ora.<server_name>.vip

1 ONLINE ONLINE <server_name> STABLE

ora.collabn2.vip

1 ONLINE INTERMEDIATE <server_name> FAILED OVER,STABLE

ora.cvu

1 ONLINE ONLINE <server_name> STABLE

ora.oc4j

1 OFFLINE OFFLINE STABLE

ora.rac.db

1 OFFLINE OFFLINE Instance Shutdown,ST

ABLE

2 OFFLINE OFFLINE STABLE

ora.scan1.vip

1 ONLINE ONLINE <server_name> STABLE

ora.scan2.vip

1 ONLINE ONLINE <server_name> STABLE

ora.scan3.vip

1 ONLINE ONLINE <server_name> STABLE

ora.target.db

1 OFFLINE OFFLINE STABLE

--------------------------------------------------------------------------------

[root@<server_name> bin]# ./crsctl stop cluster -all

CRS-2673: Attempting to stop 'ora.crsd' on '<server_name>'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on '<server_name>'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on '<server_name>'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on '<server_name>'

CRS-2673: Attempting to stop 'ora.FRA.dg' on '<server_name>'

CRS-2673: Attempting to stop 'ora.data.shared.acfs' on '<server_name>'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on '<server_name>'

CRS-2673: Attempting to stop 'ora.<server_name>.vip' on '<server_name>'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on '<server_name>'

CRS-2673: Attempting to stop 'ora.cvu' on '<server_name>'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on '<server_name>' succeeded

CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on '<server_name>' succeeded

CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.scan3.vip' on '<server_name>'

CRS-2673: Attempting to stop 'ora.scan2.vip' on '<server_name>'

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on '<server_name>'

CRS-2677: Stop of 'ora.cvu' on '<server_name>' succeeded

CRS-2677: Stop of 'ora.<server_name>.vip' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.collabn2.vip' on '<server_name>'

CRS-2677: Stop of 'ora.data.shared.acfs' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.DATA.SHARED.advm' on '<server_name>'

CRS-2677: Stop of 'ora.DATA.SHARED.advm' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.DATA.dg' on '<server_name>'

CRS-2677: Stop of 'ora.FRA.dg' on '<server_name>' succeeded

CRS-2677: Stop of 'ora.scan1.vip' on '<server_name>' succeeded

CRS-2677: Stop of 'ora.scan2.vip' on '<server_name>' succeeded

CRS-2677: Stop of 'ora.scan3.vip' on '<server_name>' succeeded

CRS-2677: Stop of 'ora.collabn2.vip' on '<server_name>' succeeded

CRS-2677: Stop of 'ora.DATA.dg' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.asm' on '<server_name>'

CRS-2677: Stop of 'ora.asm' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.ons' on '<server_name>'

CRS-2677: Stop of 'ora.ons' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on '<server_name>'

CRS-2677: Stop of 'ora.net1.network' on '<server_name>' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on '<server_name>' has completed

CRS-2677: Stop of 'ora.crsd' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.ctssd' on '<server_name>'

CRS-2673: Attempting to stop 'ora.evmd' on '<server_name>'

CRS-2673: Attempting to stop 'ora.storage' on '<server_name>'

CRS-2677: Stop of 'ora.storage' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.asm' on '<server_name>'

CRS-2677: Stop of 'ora.evmd' on '<server_name>' succeeded

CRS-2677: Stop of 'ora.ctssd' on '<server_name>' succeeded

CRS-2677: Stop of 'ora.asm' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on '<server_name>'

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on '<server_name>' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on '<server_name>'

CRS-2677: Stop of 'ora.cssd' on '<server_name>' succeeded

[root@<server_name> bin]#

[root@<server_name> bin]# ./crsctl disable has

CRS-4621: Oracle High Availability Services autostart is disabled.

ORA-29702: error occurred in Cluster Group Service operation in oracle database

Issue:

when I started my oracle database got the below error.

ORA-29702: error occurred in Cluster Group Service operation

SQL> startup mount;

ORA-29702: error occurred in Cluster Group Service operation

Solution:

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk rac_off ioracle

make -f ins_rdbms.mk ioracle

[oracle@<server_name> ~]$ cd $ORACLE_HOME/rdbms/lib

[oracle@<server_name> lib]$ make -f ins_rdbms.mk rac_off ioracle

rm -f /u01/app/oracle/product/12.1.0/dbhome_1/lib/libskgxp12.so

cp /u01/app/oracle/product/12.1.0/dbhome_1/lib//libskgxpg.so /u01/app/oracle/product/12.1.0/dbhome_1/lib/libskgxp12.so

rm -f /u01/app/oracle/product/12.1.0/dbhome_1/lib/libskgxn2.so

cp /u01/app/oracle/product/12.1.0/dbhome_1/lib//libskgxns.so \

/u01/app/oracle/product/12.1.0/dbhome_1/lib/libskgxn2.so

/usr/bin/ar d /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/libknlopt.a kcsm.o

/usr/bin/ar cr /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/ksnkcs.o

chmod 755 /u01/app/oracle/product/12.1.0/dbhome_1/bin

- Linking Oracle

rm -f /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/oracle

/u01/app/oracle/product/12.1.0/dbhome_1/bin/orald -o /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/oracle -m64 -z noexecstack -Wl,--disable-new-dtags -L/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/ -L/u01/app/oracle/product/12.1.0/dbhome_1/lib/ -L/u01/app/oracle/product/12.1.0/dbhome_1/lib/stubs/ -Wl,-E /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/opimai.o /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/ssoraed.o /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/ttcsoi.o -Wl,--whole-archive -lperfsrv12 -Wl,--no-whole-archive /u01/app/oracle/product/12.1.0/dbhome_1/lib/nautab.o /u01/app/oracle/product/12.1.0/dbhome_1/lib/naeet.o /u01/app/oracle/product/12.1.0/dbhome_1/lib/naect.o /u01/app/oracle/product/12.1.0/dbhome_1/lib/naedhs.o /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/config.o -lserver12 -lodm12 -lcell12 -lnnet12 -lskgxp12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lclient12 -lvsn12 -lcommon12 -lgeneric12 -lknlopt `if /usr/bin/ar tv /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap12" ; fi` -lskjcx12 -lslax12 -lpls12 -lrt -lplp12 -lserver12 -lclient12 -lvsn12 -lcommon12 -lgeneric12 `if [ -f /u01/app/oracle/product/12.1.0/dbhome_1/lib/libavserver12.a ] ; then echo "-lavserver12" ; else echo "-lavstub12"; fi` `if [ -f /u01/app/oracle/product/12.1.0/dbhome_1/lib/libavclient12.a ] ; then echo "-lavclient12" ; fi` -lknlopt -lslax12 -lpls12 -lrt -lplp12 -ljavavm12 -lserver12 -lwwg `cat /u01/app/oracle/product/12.1.0/dbhome_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnro12 `cat /u01/app/oracle/product/12.1.0/dbhome_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnnzst12 -lzt12 -lztkg12 -lmm -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lztkg12 `cat /u01/app/oracle/product/12.1.0/dbhome_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnro12 `cat /u01/app/oracle/product/12.1.0/dbhome_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnnzst12 -lzt12 -lztkg12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `if /usr/bin/ar tv /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo12"; fi` -L/u01/app/oracle/product/12.1.0/dbhome_1/ctx/lib/ -lctxc12 -lctx12 -lzx12 -lgx12 -lctx12 -lzx12 -lgx12 -lordimt12 -lclsra12 -ldbcfg12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -locr12 -locrb12 -locrutl12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12 -loraz -llzopro -lorabz2 -lipp_z -lipp_bz2 -lippdcemerged -lippsemerged -lippdcmerged -lippsmerged -lippcore -lippcpemerged -lippcpmerged -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lsnls12 -lunls12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lasmclnt12 -lcommon12 -lcore12 -laio -lons `cat /u01/app/oracle/product/12.1.0/dbhome_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/12.1.0/dbhome_1/lib -lm `cat /u01/app/oracle/product/12.1.0/dbhome_1/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/12.1.0/dbhome_1/lib

test ! -f /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle ||\

mv -f /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracleO

mv /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/oracle /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle

chmod 6751 /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle

[oracle@<server_name> lib]$ make -f ins_rdbms.mk ioracle

chmod 755 /u01/app/oracle/product/12.1.0/dbhome_1/bin

- Linking Oracle

rm -f /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/oracle

test ! -f /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle ||\

mv -f /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracleO

mv /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/oracle /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle

chmod 6751 /u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle

[oracle@<server_name> lib]$

[oracle@<server_name> lib]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Mon May 20 22:24:34 2024

Connected to an idle instance.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1369579520 bytes

Fixed Size 2288200 bytes

Variable Size 436209080 bytes

Database Buffers 922746880 bytes

Redo Buffers 8335360 bytes

Database mounted.

SQL> alter database open;

Database altered.

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

SOURCE READ WRITE

Wednesday, April 17, 2024

Pl/Sql script to generate n number of datafile in oracle database.

we have scenario ,used to add 100 plus datafiles to a tablespace and we dont need to create it manually,I have created pl/sql script to generate n number of datafiles for this table space.

This is really helped us.

DECLARE

v_tablespace_name VARCHAR2(30) := 'USER'; -- Specify your tablespace name

v_datafile_prefix VARCHAR2(50) := '/path/to/datafile'; -- Specify the base path for datafiles

v_datafile_size_mb NUMBER := 100; -- Specify the size of each datafile in MB

v_num_files NUMBER := 100; -- Specify the number of datafiles to add

v_sql VARCHAR2(1000);

BEGIN

FOR i IN 1..v_num_files LOOP

-- Generate SQL to add datafile

v_sql := 'ALTER TABLESPACE ' || v_tablespace_name ||

' ADD DATAFILE ''' || v_datafile_prefix || i || '.dbf''' ||

' SIZE ' || v_datafile_size_mb || 'M AUTOEXTEND OFF NEXT 100M MAXSIZE UNLIMITED;';

-- Output SQL statement

DBMS_OUTPUT.PUT_LINE(v_sql);

END LOOP;

END;

Friday, December 1, 2023

ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration],

issue:

ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], [] error reported on oracle database 64 bit 19.16.0.0

Root cause:

looks like oradism (file located under cd $ORACLE_HOME/bin) permission issue.

Solution:

1) check if the below parameter set to _highest_priority_processes=VKTM in DB level ,if not set

alter system set _highest_priority_processes=VKTM scope=spfile;

2) check cd $ORACLE_HOME/bin oradism and make sure it has Sticky bit set,if not set the sticky bit and reboot the DB.

cd $ORACLE_HOME/bin ls -lrt oradism (see the sticky bit)

-rwxr-x--- 1 oracle oinstall 147848 Apr 17 2019 oradism >>>>>>>>>>>>>>>>>> wrong one

-rwsr-x--- 1 root oinstall 147848 Apr 17 2019 oradism >>>>>>>>>>>>>>>>>>>> Correct one

Tuesday, July 18, 2023

script to find what are the users having CREATE privilege's on AWS Redshift database

script to find what are the users having CREATE privilege's on AWS Redshift database:

SELECT u.usename AS username,

nsp.nspname AS schema_name,

has_schema_privilege(u.usename, nsp.nspname, 'CREATE') AS has_create_privilege

FROM pg_user u

CROSS JOIN pg_namespace nsp

WHERE nsp.nspname NOT LIKE 'pg_%' AND nsp.nspname not in ('information_schema','public') and u.usename not in('admin')

AND has_schema_privilege(u.usename, nsp.nspname, 'CREATE') = true

ORDER BY u.usename, nsp.nspname;

Tuesday, January 3, 2023

How to migrate the data between AWS Redshift clusters ? or steps to configure the datashare in aws Redshift cluster?

pre-request:

******************

get the cluster_name_space of source & Target cluster.

[source_cluster_name_space]==>source_DB

[target_cluster_name_space]==>Target_DB

source_cluster (Producer)

**********************

create datashare Data_share_copy_source_2_target publicaccessible=false; --create Datashare

alter datashare Data_share_copy_source_2_target add schema schema_name; --- add schema to migrate the tables

alter datashare Data_share_copy_source_2_target set includenew=true for schema schema_name;--add future object

alter datashare Data_share_copy_source_2_target add all tables in schema schema_name;--current objects

grant usage on datashare Data_share_copy_source_2_target to namespace '[target_cluster_name_space]';

Target_cluster (consumer)

********************

--create new datashare to import the data to current/target cluster

create database import_DS_target from datashare Data_share_copy_source_2_target of namespace '[source_cluster_name_space]';

--copy the data from imported Datashare to target DB tables

Move data from source to Target:

***************************

create the empty table1 with same structure on target DB and insert the data.

insert into schema_name.table1 select * from Data_share_copy_source_2_target.schema_name.table1

Monday, November 14, 2022

ORA-00800 and ORA-700 in oracle database 19.16.0.0

Issue:

we have recently build new oracle database with version 19.16.0.0 and alert log reported the below 2 errors.

Errors in file /oracle/DB_name/diag/rdbms/DB_name/DB_name/trace/DB_name_vktm_60713.trc (incident=54058):

ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], [] (Doc ID 2718971.1)

Incident details in: /oracle/DB_name/diag/rdbms/DB_name/DB_name/incident/incdir_54058/DB_name_vktm_60713_i54058.trc

2022-11-09T12:21:15.626799+00:00

Error attempting to elevate VKTM's priority: no further priority changes will be attempted for this process

VKTM started with pid=5, OS id=60713

Root cause and solution:

ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM] (Doc ID 2718971.1)I

In the DB_name DB system, it seems "$ORACLE_HOME/bin/oradism" file permissions and ownership are not as per the oracle recommendation. It should be owned by root:oinstall and setups bit set. Will inform to System admin to set the ownership and permission.

$ ls -latr $ORACLE_HOME/bin/oradism

-rwsr-x--- 1 root oinstall 147848 Apr 17 2019 oradism >>>>>>>>>>>>>>>>>>>>>>>> Correct one

Need run from root user:

# chmod u+s oradism

************************************************************

Issue:

PGA_AGGREGATE_TARGET specified is high

Errors in file /oracle/DB_name/diag/rdbms/DB_name/DB_name/trace/DB_name_ora_60307.trc (incident=48015):

ORA-00700: soft internal error, arguments: [pga physmem limit], [3221225472], [3033848422], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/DB_name/diag/rdbms/DB_name/DB_name/incident/incdir_48015/DB_name_ora_60307_i48015.trc

LICENSE_MAX_SESSION = 0

Oracle Recommendation :

ORA-700 [sms physmem limit] / [pga physmem limit] Errors while Starting the Database (Doc ID 2610312.1)

The issue is caused by overall memory configuration, i.e. the SGA TARGET + PGA LIMIT total is greater than system's memory limit. Here SGA TARGET + PGA memory allocated is around 92 % of total physical memory. We have changed “pga_aggregate_target” memory value as per recommendation. Please see below details for reference. We will check the alert log after a DB bounce to confirm the alerts.

/oracle/DB_name/diag/rdbms/DB_name/DB_name/incident/incdir_48015/DB_name_ora_60307_i48015.trc

----- Beginning of Customized Incident Dump(s) -----

WARNING: PGA_AGGREGATE_TARGET (3072 MB) is too high for

the amount of physical memory (15531 MB) and

SGA size (8192 MB) - it should be less than 2893 MB.

Thumb rule to setup PGA_AGGREGATE_TARGET:

(Doc ID 2610312.1)

Total memory = 100%

Reserved for OS = 20%

Out of the remaining 80%

PGA_AGGREGATE_TARGET = 50% of 80%

SGA_TARGET = 50% of 80% of total memory

***********************************************************

PGA_AGGREGATE_TARGET = 25% of 85% total memory 3

PGA_AGGREGATE_LIMIT = 50% of 85% total memory 6

SGA_TARGET = 50% of 85% total memory

***********************************************************