Check hidden parameter in Oracle set lines 200 col name for a50 col value for a40 select ksppinm name , ksppstvl value from x$ksppi a, x$ksppsv b where a.indx=b.indx and substr(ksppinm,1,1) = ‘_’;
All posts by Skant Gupta
KST tracing in Oracle
KST tracing is an in-memory tracing feature for Oracle RDBMS Database Server, this is similar to on-disk (KSD) tracing except it is stored in SGA. For on-disk tracing, we have many events like 10046 (sql_trace), 10053 (sql_optimizer), etc. Different to these on-disk tracing, KST tracing use a cyclic buffer in the SGA and we won’t […]
Oracle 18c: “Oracle 18c and its impact on DBAs”
This article was written by Skant Gupta and Joel Perez in Oracle OTN. 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 “DBAs will be fired.. ? It’s the end of DBAs because of the […]
Exadata x7-2 with Cell Storage 18c
Continuing to raise the bar for enterprise-class database platforms, today Oracle announced the next-generation Oracle Exadata X7 with significant hardware and software enhancements in overall performance, storage capacity, network bandwidth, and automation. Exadata x7-2 delivers extreme performance and reliability to run the largest, most business-critical database workloads. Oracle Exadata is an Engineered System designed to be the […]
Creating and Deleting Database backupsets on Oracle Cloud DBAAS
This article was written by Skant Gupta and Joel Perez in Oracle OTN. By backing up your Oracle Database Cloud Service database deployments, you can protect the software, configuration and database against loss if a failure occurs. By restoring from a backup, you can restore the deployment’s software, configuration, and database to their state at the time of the backup. […]
Basic about Docker in the Oracle
Oracle announced that it is collaborating with Docker to release its flagship databases, middleware and developer tools into the Docker Store marketplace via the Docker Certification Program. Together, Oracle and Docker enable developers to quickly build cloud-native applications using Docker Enterprise Edition as their container platform and Oracle’s databases and developer tools immediately available as […]
Migrating Databases to Oracle Cloud Using RMAN Backup
This article was written by Skant Gupta and Joel Perez in Oracle OTN. This method is based on the traditional backup/restore/recover database. It has been one of the methods most effective to migrate/move an Oracle Database from one host to another host or even in the same host. The advantages of this method are several, one of them is that […]
Oracle Cloud (DBaaS): Move PDB with exporting the TDE master Key in Oracle 12.2
This article was written by Skant Gupta and Joel Perez in Oracle OTN. Security is one of the main issues that customers think at the time of moving or having the databases, applications and more into the Cloud. Security has many layers, areas, sections and more. When we work with databases “On-Prem”, security in many […]
RMAN Configure Backup Optimization Features with Example
RMAN backup optimization is another feature to minimize backup size. Enabling this feature, RMAN BACKUP will skip backup of files that comes in certain condition or exactly identical to the file already backup up. As the name indicates the feature is for optimizing the RMAN backups. When you turn on this backup optimization parameter, RMAN […]
Oracle Cloud (DBaaS): Using dbaascli Utility for Reinstating 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 Operations on Oracle Data Guard using the dbaascli utility. You can read it here: Oracle Cloud (DBaaS): Using dbaascli Utility for Switchover & Failover Operations on Oracle Data Guard Now in this this article we […]