DATABASE

LREG Background Process in oracle

Prior to 12c, PMON process used to handle the instance registration with listner, From oracle 12c, a new background process called lreg takes care of this instance registration, Which reduces the load from pmon process.

Basically, LREG process does below things. 1. Registers instance information with the listener. 2. It is a critical background […]

Find the active transactions in oracle database

Below script can be used to find the active transactions in the oracle database.

How to change http port of EM dbconsole

By default , when we setup enterprise Manager database console(dbconsole), 1158 port will be configured. But we can change this port easily using emca utility. In the below example, we will change the port from 1158 to 7100 1. Check the current dbconsole details:

Currently the port is 1158 . https://prodb:1158/em/console/aboutApplication 2. Invoke emca […]

How to generate AWR report in oracle

The Automatic Workload Repository (AWR) collects and maintains statistics of the database. We can generate awr report for a particular time frame in the past using the script awrrpt.sql ( located under $ORACLE_HOME/rdbms/admin) script – @$ORACLE_HOME/rdbms/admin/awrrpt.sql

For rac databases, the script awrrpt.sql script need to be run again each instance.   For NON-SYSDBA USERS, […]

Compile Invalid objects in oracle

Objects in the database can become invalid, if there are any changes to the dependent objects. Even patch and upgrade can also make the object invalid. Compiling the invalid objects can make them valid if they are eligible.   Below is the query to find the invalid objects currently present in the database.

1. […]

Load data from excel sheet to oracle table

  In this article, we will explain different methods to load data from excel sheet into Oracle database. Below are the methods that can be used. SQL DEVELOPER  SQLCL utility  TOAD SQLLOADER Here we will explain how to do this with SQL developer and SQLCL utility. USING SQLDEVELOPER TOOL: SQL developer is a free tool […]

Force logging in oracle

What is force logging: If force logging is enabled, all the database changes will be logged in redo log files, even for nologging operations.The above means that if FORCE LOGGING is enabled at a higher level, the NOLOGGING at a lower level has no effect. That means that even for a nologging table redo information […]

resumable_timeout parameter in oracle database

resumable_timeout is an initialization parameter introduced in Oracle 9i.  This parameter defines the duration in seconds, for which the statements will be suspended if there is no space available in the tablespace for that operation. Once we add space to that tablespace, those transactions will resume their operation. Let’s see the below example:

The […]

Schedule expdp job in dbms_scheduler

We usually schedule expdp jobs in a standard shell script.  But the same can be achieved using dbms_scheduler utility also. Below are steps for scheduling expdp job. Here we will schedule a full expdp backup of the database, which will run daily at 11:30 HRS. 1. First, prepare the parfile

2. Now create the […]

Scheduler jobs in oracle

To schedule a job at a particular time in the database, first we need to create a schedule, then a program and then job. 1. Create a schedule A schedule defines the start date, end time and repeat interval details

2. Create a program: A program defines the name and type of the procedure, […]

Page 2 of 612345...Last »
Skip to toolbar