In this post, we will talk about one of the useful things that administrator often has to use. The topic is How To Get environment variables of running process in Linux. Let’s first start with what is environment variable and then find out How To Check Environment Variables for a Running Process in different flavours of Unix […]
How to Get environment variables of running process in Linux Read More »
Oracle Provides Automatic Managed Backup Service on ExaCS Machine. Oracle completely managed the Backup of the database on the customer’s behalf. It stores the backup in DBaaS tenancy, not the customer tenancy. We have two options in the backup object storage and recovery service. Here in this article , we are talking about object storage
How to configure Automatic Managed Backup on ExaCS Read More »
We often need to perform reorganization of the tables. We have to do offline by taking the system down and it consumes a lot of time. we can perform an Online table redefinition using DBMS_REDEFINITION. This feature is available from 9i. How Oracle internally achieve this Online table redefinition There are some Restrictions Tables with
Online table redefinition using DBMS_REDEFINITION Read More »
We often need to find and delete duplicate rows from the Oracle table due to many reasons in the database. We need to delete to clear off the data issues often. There are many ways to delete duplicate rows but keep the original.I will be showing off a few faster methods to achieve it in
delete duplicate rows from Oracle Read More »
In this post, we will discuss how to drop the Oracle database. The below procedure drops the spfile also but it does not touch Oracle Home. You may want to backup the spfile before dropping the database sqlplus / as sysdba startup mount (If database not started) create pfile=’/tmp/pfile.ora’ from spfile; Dropping an Oracle database
How to drop the oracle database Read More »
Cutover phase of adop is downtime phase of Online patching cycle. We should ensure no user access is there in that period as application processes are restarted.Before running the cutover command, ensure you are ready to commit to application of the selected patches. Once cutover is complete, it is not possible to revert to
what happens in cutover phase of adop in R12.2 Read More »
