Oracle Parameters for RIDW

Insight didn't provide the document for installing Oracle, you can google the document for that.
I checked /sbin/sysctl, the parameters as follows:
kernel.shmall=2097152
kernel.shmmax=2147483648
kernel.shmmni=4096
kernel.sem=250 32000 100 128
fs.file-max=65536
net.ipv4.ip_local_port_range=1024 65000
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
Also for /etc/security/limits.conf, the parameters as follows:
racle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

Hello all,

Would anyone be able to point me to documentation that specify what should be Oracle parameters for RIDW? I would need at least the following:

processes
sg_max_size
shared_pool_size
open_cursors

We have 200 connected and 20 active users environment.

Thanks!

We would like to understand the minimum level database privileges that need to be provided on Insight schema users so that Insight application is operational.

Please let us know the answers for the below

1. What db and schema privs do the insight users need for installation?

2. What db and schema privs do the insight users need for operation (post install)

Our Data Engineering team say it's ok to run with elevated privs for installation phase but not operational stage as it is violating Organizational standards.

Hence, we would like to know the necessary privileges for Insight schema users.

Thanks,
Dinesh

Hello all,

Would anyone be able to point me to documentation that specify what should be Oracle parameters for RIDW...

SGA_MAX_SIZE
PGA_AGGREGATE_TARGET