@@exhydra369 1. How to run the DB's with 4 hours gap in primary DB and secondary DB. 2. How to add checkpoint and if you add checkpoint what happened? 3. What is the use of red log files in standby, what the role plays in standby. 4. In prod temp. File is added but it will not replicted in standby, why? 5. My redo is over size then DB size what happen?
There is no concrete answer for this but it depends and quite complex. Generally, joining tables needs more work than independent table which means more cost. Also it depends on the number of records in driving and driven table, how the data is distributed in these tables, fragmentations, purity of statistics etc..
can you help me fix these errors for Oracle 19c & sql server 19 when I go through the database configuration and creation wizard for Primavera 20, it reaches the step of creating pubuser and privuser in both cases, oracle and msql server, then i get error messages but different from each other, in Oracle I get error run sql script orppm_creat_users.sql ORA-65096 while, In sql server database, i get creating the sql server tablespaces for p6 ppm error exectue sql script ssppm_itit_db.sql Can you help me solve this problem?
just try this and startup again ps -ef|grep ora|awk '{print $2}'|xargs -i kill -9 {} note that if you are in production dont do this as you are killing the key background processes because of memory contention.If still issue persist then try increasing the shm to bigger value or modify your /etc/sysctl.conf parameters to oracle recommended kernel values.Thanks!!
Hi friend, Thanks for this video, it has solved my error. I am getting error as below could you please help me in below. ORA-01081: cannot start already-running ORACLE - shut it down first