LOCAL=NO & LOCAL=YES in Oracle

LOCAL = NO: non-local connection, namely a network connection. Listener connect to the server. Client application through the client listener listener sends a request to the server, the server listens received in connection with the database, perform related operations, the results returned to the client. This is the process by listening. So you need to […]

Read More

Oracle Database Maximum Availability Certified Expert

Hi Readers Finally I’ve successfully achieved  Oracle Database Maximum Availability Certified Expert. It was almost more than 6 months that I’ve been preparing for this. To achieve this certification, we must complete ALL the three certifications: Oracle Database 12c Administrator Certified Professional Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administration Oracle Certified Expert, Oracle Database […]

Read More

Archive log delete input and delete all input

Archive log mode :  This mode created backup of all transactions that have occurred in the database , so that you can recover your database to any point in time. These logs consumes space in respective destination. To utilize storage , we can remove archive log with RMAN command delete input or delete all input […]

Read More

check os process id of your session from sql prompt.

 Check os process id of your session from sql prompt. select p.spid, s.username, s.status, s.server, to_char(s.logon_time,’DD-MON-YY HH24:MI’) from v$process p, v$session s where p.addr = s.paddr and s.status=’ACTIVE’;  SPID USERNAME STATUS SERVER ———————— —————————— ——– ——— TO_CHAR(S.LOGON_TIME,’DD-MON-YYHH24:MI’) ————————————————————————— 18658 TEST1 ACTIVE DEDICATED 08-JAN-18 15:07 18664 TEST1 ACTIVE DEDICATED 08-JAN-18 15:07 23691 TEST1 ACTIVE DEDICATED 08-JAN-18 […]

Read More

Oracle DBaaS Monitor In Oracle Cloud

Oracle DBaaS Monitor provides monitoring and management of the Oracle database and listener on Oracle Database Cloud Service. DBaaS Monitor provides quick and easy access to a variety of information about the database instance running on a database deployment: Overall, how much storage is allocated to tablespaces, and how much of that storage is used For […]

Read More