How to install Oracle Client step by step

Hi friends, in this article we are going to learn how to install oracle client on Linux environment step by step. Software used in this article VMWare 11 Redhat Linux 6 Oracle 11G Oracle 11G Client Download Oracle 11g Client software Click here Unzip the Client Software Using the below command unzip the oracle client … Read more How to install Oracle Client step by step

Share this
Share

Best 3 Ways to Convert DOC to PDF

DOC to PDF conversion is one of the most frequent types of document conversion used by millions of people. From everyday business use to personal agendas, understanding how to convert DOC to PDF starts with the right program. What follows are two software conversion programs followed by an online-only version that are considered some of … Read more Best 3 Ways to Convert DOC to PDF

Share this
Share

How to change text to speech voice in android

Hello friends, in this article we are going to learn how to use text to speech voice in android studio step by step. In this example, we are going with the new project, if you want you can use this code in your existing project. So let’s start the new project. Use text to speech … Read more How to change text to speech voice in android

Share this
Share

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

How to Use GIF file in Android Studio

Hi Friends, In this article, we are going to learn how to use GIF files in Android Studio step by step. So lets, start the Android Studio and create a new project with empty Activity and start the Use GIF file in Android Studio. How to add GIF in Android Project? Step 1. After creating … Read more How to Use GIF file in Android Studio

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

How to check RMAN backup status and timings

How to check RMAN backup status and timings

Hello friends, in this article we learn how to check RMAN backup status and timings on the target database. Using the following command you will get the details about currently running RMAN and ARCHIVE backup. Click Here for YouTube Query to check RMAN backup status col STATUS format a10 col hrs format 999.99 select SESSION_KEY, … Read more How to check RMAN backup status and timings

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
Share