PROBLEM: ARCHIVE process get hang on Primary Database The problem has been that the standby hardware have some faulty backpane. This has caused processes in the standby to go into what is called as “D” state where the processes gets stuck in a kernel call. So the RFS processes on the standby are getting hung […]
Articles Tagged: Oracle 18c
Oracle 18c: How to load data in Oracle Autonomous Data Warehouse Cloud
This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS Loading Data into Autonomous Data Warehouse Cloud Database Data […]
Oracle Exadata Database Machine and Cloud Service 2017 Certified Implementation Specialist
Hi Readers Finally I’ve successfully passed 1Z0-338, Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials. It was almost more than 2 months that I’ve been preparing for this. The Exam contains 71 questions related to Exadata and Cloud Services. To earn this certification you need to get 63% marks. This was the result of the […]
Read the Trace file from SQL Plus
Find trace file in Oracle The following script returns the path to the trace file that the current session writes. It returns the path whether or not tracing is enabled. SQL> SELECT s.sid, 2 s.serial#, 3 pa.value || ‘\’ || LOWER(SYS_CONTEXT(‘userenv’,’instance_name’)) || 4 ‘_ora_’ || p.spid || ‘.trc’ AS trace_file 5 FROM v$session s, 6 v$process p, 7 v$parameter […]
Oracle Fixed Views
Oracle maintains a set of virtual tables that record current database activity. These tables are called dynamic performance tables. This post was written by Sriram Sanka in his blog. Why the term “Fixed”? Because They are fixed ..One cannot perform any DML , DDL or any operation other than “SELECT“,that’s why these views/Tables are known […]
Oracle Database Gateway for MySQL
An organization have lot of choices to choose from the RDBMS world. Oracle Database, Microsoft SQL Server, IBM DB2,PostgreSQL, MySQL are few of them. Most of the organizations out there do have a mix of all these which are used to store their data and in course of time it is inevitable that they would […]
How To Move AUD$ Table To Another Tablespace Using DBMS_AUDIT_MGMT
Auditing is always about accountability, and is frequently done to protect and preserve privacy for the information stored in databases. Concern about privacy policies and practices has been rising steadily with the ubiquitous use of databases in businesses and on the Internet. Oracle Database provides a depth of auditing that readily enables system administrators to […]
Oracle Database Gateway for PostgreSQL
An organization have lot of choices to choose from the RDBMS world. Oracle Database, Microsoft SQL Server, IBM DB2,PostgreSQL, MySQL are few of them. Most of the organizations out there do have a mix of all these which are used to store their data and in course of time it is inevitable that they would […]
Oracle 18c: RMAN New Features
This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez Before starting to read, if you want to access others Oracle RMAN Cloud Articles, you can go here: #6 Oracle Cloud (DBaaS): Migrating Databases to Oracle Cloud Using RMAN Backup #11 Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using […]
Oracle 18c: Data Warehousing New Features
This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS Data Warehousing will be the focus of […]