How to check active session in Oracle database

Hello friends, in this article we are going to discuss how to find the details currently active user session with details in Oracle Database. Find Active session To finding active session in oracle, we need to connect with sys user and run the below query using v$session view. select sid,serial#,username,osuser,machine,program,module from v$session where status=’ACTIVE’ Columns … Read more How to check active session in Oracle database

Share this
Share

DBMS_SCHEDULER Job Run Every Hour Example

Hi Friends, In this example, I’m going to show you how to create a job in Oracle to run every hour using the DBMS_SCHEDULER package. Step 1. Create a Job Using DBMS_SCHEDULER.CREATE_JOB The following PL/SQL code will schedule a job that will start on 15th August 2020 at 5:00 AM India time to run every hour on … Read more DBMS_SCHEDULER Job Run Every Hour Example

Share this
Share

Export Backup with Date and Time

Hello friends, in this article we are going to discussed how to take export backup with date and time, so follow me step by step. In Oracle the EXPORT dump file name including Date and Time. If you are taking export backup using EXP command the use below formats to generate dump file name with … Read more Export Backup with Date and Time

Share this
Share

Querying Tablespace Usage

Querying Tablespace Usage

If you are an Oracle DBA then you know the importance of tablespaces in the oracle database. In Oracle Database the tablespace management is important and Oracle DBA will need to do quite frequently. So here is a query that providing the tablespace uses details. Query to check the tablespace usage The following query will … Read more Querying Tablespace Usage

Share this
Share

AWR vs ADDM vs ASH

AWR vs ADDM vs ASH

Hello friends, in this article we are going to discuss with you what is the difference between AWR (Automatic Workload Repository), ADDM (Automatic Database Diagnostic Monitor), and ASH (Active Session History). Through this short description, you will get a basic idea about all of them. AWR vs ADDM vs ASH? Visit on My YouTube: Click Here Let’s understand about AWR vs ADDM vs ASH AWR – Automatic … Read more AWR vs ADDM vs ASH

Share this
Share

Resize Oracle datafiles down to the minimum without facing ORA-03297

Hi, Today we are going to discuss how to reduce datafile size without facing “ORA-03297”. As we know the data-files stored our data and they are growing daily basis. suppose your data-files have grown in the past but now you want to reclaim as much space as possible, because you are short on filesystem space … Read more Resize Oracle datafiles down to the minimum without facing ORA-03297

Share this
Share

How to Convert Physical Standby To Snapshot Standby?

Convert Physical Standby To Snapshot Standby

Hello friends, In this article, we are going to discuss how to convert physical standby to snapshot standby database manually. What is snapshot Standby? As you know the standby database is a copy of the primary database. so Oracle snapshot standby database allows us to use the available data on the physical standby database. suppose … Read more How to Convert Physical Standby To Snapshot Standby?

Share this
Share

Oracle 19c RPM based Installation

Oracle 19c RPM based Installation

Hello, friends in this article we going to Install Oracle 19c RPM based on Oracle Linux 7 64-bit and the article based on a server installation with a 2GB swap, please follow all the steps carefully. If you have Unbreakable Linux Network (ULN) access, so as per oracle documentation you can install it using the … Read more Oracle 19c RPM based Installation

Share this
Share

Oracle Database 19c Installation on Oracle Linux 7

oracle 19c installation on linux

Hello, friends in this article we are going to discuss Oracle database 19c (64-bit) Installation on Oracle Linux 7. Using this article we are going to Install Oracle 19c server based with a 2GB swap. Software I used in this article VMware Oracle Linux 7 (64-bit) Oracle Database 19c (19.3, 64-bit) Download Database Software You … Read more Oracle Database 19c Installation on Oracle Linux 7

Share this
Share
Share