Binnary Ajay Kumar – Page 8

Protected: How to kill Long Running Query using scripts.

6 years ago by Binnary Ajay KumarOracle DB Admin

There is no excerpt because this is a protected post.

Oracle: Scheduler Jobs in Oracle Database-2

6 years ago by Binnary Ajay KumarOracle DB Admin

Oracle: Scheduler Jobs in Oracle Database-2 In this article we will learn how to create jobs with different options in dbms_scheduler. Before reading this article please check previous article. Oracle: Scheduler Jobs in Oracle Database Lets check options available in create_job procedure Use desc dbms_scheduler… Read More

Oracle: Scheduler Jobs in Oracle Database

6 years ago by Binnary Ajay KumarOracle DB Admin

Oracle: Scheduler jobs in Oracle Database. In this article we will learn how to create jobs and schedule the jobs. You create one or more jobs using the DBMS_SCHEDULER.CREATE_JOB. You must have the CREATE JOB privilege to create a job in your own schema, and the CREATE ANY JOB privilege to create a… Read More

RENAMING INSTANCE

6 years ago by Binnary Ajay KumarOracle DB Admin

RENAMING INSTANCE In this article we will learn how to rename a oracle instance. Step 1 : Check instance information

SYS>>select instance_name from v$instance;
Inst-Name
----------
primary

SYS>>select instance_name from v$instance;

Inst-Name

----------

primary

My instance name is primary. No i want to convert Primary to PROD. Step 2 : Shutdown the database

SYS>>shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS>>exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SYS>>shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS>>exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Step 3 : Change… Read More

Renaming the Oracle Database.

6 years ago by Binnary Ajay KumarOracle DB Admin

Renaming the Oracle Database. In this article we will learn how to rename a oracle database using trace controlfile . RENAMING DATABASE : Step 1 : Check the database name

SYS>>select name from v$database;
NAME
----------------------------------------
PRIMARY

SYS>>select name from v$database;

NAME

----------------------------------------

PRIMARY

My Old Database name is PRIMARY Step 2 : Create a trace control file… Read More

Controlfile Multiplexing and De-Multiplexing In Oracle12c

6 years ago by Binnary Ajay KumarOracle DB Admin

Controlfile Multiplexing and De-Multiplexing In Oracle12c In this article we will learn what controlfile contains,How to perform controlfile Multiplexing and De-Multiplexing . Control file : Controlfile is a Physical file. Controlfile is a small binary file which contains the current physical structure of database. Control… Read More

Different Block Size of ORACLE

6 years ago by Binnary Ajay KumarOracle DB Admin

Different Block Size of ORACLE Oracle 9i supports tablespaces with different block sizes. This allows large tables and indexes to have a larger block size than smaller objects. It also means that tablespaces can be transported between databases with differing block sizes. The database is… Read More

Storage Management in Oracle -3

6 years ago by Binnary Ajay KumarOracle DB Admin

Storage Management in Oracle -3 In article we will learn creating tablespaces with storage parameters(DEMO). Before reading this article please check previous articles. Storage Management in Oracle -2 Demo On Storage Management : To view information about storage management use DBA_TABLESPACES or V$TABLESPACE

SYS>> desc dba_tablespaceselect TABLESPACE_NAME,EXTENT_MANAGEMENT,INITIAL_EXTENT,NEXT_EXTENT,MIN_EXTENTS,MAX_EXTENTS,PCT_INCREASE from dba_tablespaces;
TS-Name    Extent-Man   Init-Ext   Next-Ext    Min-Ext    Max-Ext    Pct-Inc
---------- ---------- ---------- ---------- ---------- ---------- ----------
SYSTEM     DICTIONARY      16384      16384          1        505         50
SYSAUX     LOCAL           65536                     1 2147483645
UNDOTBS1   LOCAL           65536                     1 2147483645
TEMP       LOCAL         1048576    1048576          1                     0
USERDATA   LOCAL           65536                     1 2147483645
TEST       LOCAL           65536                     1 2147483645

6 rows selected.

SYS>> desc dba_tablespaceselect TABLESPACE_NAME,EXTENT_MANAGEMENT,INITIAL_EXTENT,NEXT_EXTENT,MIN_EXTENTS,MAX_EXTENTS,PCT_INCREASE from dba_tablespaces;

TS-Name Extent-Man Init-Ext Next-Ext Min-Ext Max-Ext Pct-Inc

---------- ---------- ---------- ---------- ---------- ---------- ----------

SYSTEM DICTIONARY 16384 16384 1 505 50

SYSAUX LOCAL 65536 1 2147483645

UNDOTBS1 LOCAL 65536 1 2147483645

TEMP LOCAL 1048576 1048576 1 0

USERDATA LOCAL 65536 1 2147483645

TEST LOCAL 65536 1 2147483645

6 rows selected.

Note… Read More

Storage Management in Oracle -2

6 years ago by Binnary Ajay KumarOracle DB Admin

Storage Management in Oracle -2 In this article we will learn about Storage Parameters . Before reading this article please go through with previous article. Storage Management in Oracle -1 Storage Hierarchy Summary In summary, the hierarchy of storage in Oracle is as follows: 1.… Read More

Storage Management in Oracle -1

6 years ago by Binnary Ajay KumarOracle DB Admin

Storage Management in Oracle -1 In this article we will learn about Storage Management . A Database is a collection of Logical and Physical Phases.In Logical phase we have DB objects. A Tablespace is a logical storage container in Oracle that comes at the top… Read More