Oracle Parameters for RIDW
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! |
3 answers
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, |
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, SGA_MAX_SIZE PGA_AGGREGATE_TARGET |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.