Oracle Corp. today announced the general availability of its new Bare Metal Cloud Services, which the company is billing as the next generation of its Infrastructure-as-a-Service (IaaS). The new IaaS product provides a “bare metal” cloud — servers with no Oracle software running on them — in a virtualized network environment that delivers high performance Database-as-a-Service […]
All posts by Skant Gupta
MAX_STRING_SIZE Parameter In Oracle 12c
This parameter was introduced in Oracle 12c. MAX_STRING_SIZE controls the maximum size of string size in Oracle database. Either we can set it to STANDARD or.EXTENDED The default value is STANDARD MAX_STRING_SIZE = STANDARD means the maximum size of strings is 4000 bytes for VARCHAR2 and NVARCHAR2 MAX_STRING_SIZE = EXTENDED means maximum size can be upto 32767 byte . We can change the value of MAX_STRING_SIZE from STANDARD to EXTENDED. But not from EXTENDED to STANDARD. With MAX_STRING_SIZE set to STANDARD , […]
Oracle Cloud (DBaaS): Using dbaascli Utility for Switchover & Failover Operations on Oracle Data Guard
This article was written by Skant Gupta and Joel Perez in Oracle OTN. At the last part of this article we performed Switchover, Failover & Reinstate Operations on Oracle Data Guard using the DBCS Console. You can read it here: Oracle Cloud (DBaaS): Switchover, Failover & Reinstate Operations on Oracle Data Guard using DBCS Console […]
Oracle Licenses
Despite reams of legalese and countless blog/forum posts, basic Oracle RDBMS licensing still remains a mystery to many. While I won’t even begin to discuss components like Oracle Apps, hopefully this post may help you attain a basic understanding of Oracle, what you can license, and what it costs. Editions The first and most important […]
Oracle Cloud (DBaaS): How to become OCP & OCM Cloud!!!
This article was written by Skant Gupta and Joel Perez in Oracle OTN. Hi everyone If you are reading this article could be for several reasons..: 1.- Perhaps you have asked me or asked to my colleague Skant Gupta the typical question “How to become OCP & OCM Cloud?” 2.- Perhaps you have found this […]
Oracle Cloud (DBaaS): Switchover, Failover & Reinstate Operations on Oracle Data Guard using DBCS Console
This article was written by Skant Gupta and Joel Perez in Oracle OTN. At the last part of this article we configure the oracle data guard in database cloud service. Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS ) Now in this this article we will show the necessary steps to […]
Using the Remote Diagnostic Agent (RDA)
The Remote Diagnostic Agent (RDA) is an Oracle-provided diagnostic tool that captures data about your database environment and packages it into a web page report. When submitting a Service Request to Oracle Support, you will often be asked to run the Remote Diagnostic Agent (RDA) and upload the results. This allows the support analyst to review […]
Methods for viewing SQL Execution Plans
Using Autotrace SQL> set autotrace traceonly explain SQL> select ename from emp where sal > 500; Execution Plan ———————————————————- Plan hash value: 2872589290 ————————————————————————- | Id | Operation | Name | Rows | Bytes |Cost (%CPU)| Time | ————————————————————————- | 0 | SELECT STATEMENT | | 1 | 25 | 2 (0)| 00:00:01 | |* […]
FAR SYNC in Oracle 12C Database
Oracle introduced a new feature for DataGuard called Far Sync. This configuration is design to support synchronous redo transport between primary and standby database which are far apart. In usual configuration synchronous redo transport between data centre in Europe and US is possible but inefficient from the primary database performance perspective. Every commit has to be written […]
Importing just 1 view via impdp
Hi, Struggling the right syntax in Unix environment for importing a lost view, here is the proper way: impdp user/password@database directory=dir_dump dumpfile=dump.dmp logfile=imp_MY_VIEW.log INCLUDE=VIEW:\”= \’MY_VIEW\’\” job_name=imp_MY_VIEW