SQL>select current_scn from v$database; 7705798324 SQL> select timestamp_to_scn(to_timestamp(’24/09/2012 14:24:54′,’DD/MM/YYYY HH24:MI:SS’)) as scn from dual; SCN ———- 7705798324 SQL> SQL> select scn_to_timestamp(7705798324) as timestamp from dual; 24-SEP-12 02.24.52.000000000 PM Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or […]
Monthly Archives: November 2017
Export backup with date and time
Data Pump Export (hereinafter referred to as Export for ease of reading) is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set can be imported only by the Data Pump Import utility. The dump file set can be imported on the […]
Undo Segments are corrupted
Database is shutdown and can’t start it, asking for Undo recovery while dropping Undo tablespace Dropping a Undo tablespace give message The UNDOTBS for our RMAN Catalog database was dropped. Any attempts to switch to a newly created UNDOTBS or removing the old UNDOTBS failed with the following error: ORA-01548: active rollback segment Or Undo […]
ARCH wait on SENDREQ
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 […]
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 […]
ORA-00059:maximum number of DB_FILES exceeded
By default in every Oracle Database, you can have up to 200 total data files (.DBF files) in each Oracle Database instance as indicated by the value of the parameter “db_files” (you can check the value by running “show parameter db_files” in your database. If you need to create more data files than what the […]
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 […]