Oracle Database Administration Examples, Tutorials and Articles

Recover Archive from Oracle Database backup

Published by

Introduction

How to restore archive from Oracle Rman Backups

Examples:
[applmgrr@apps10 bin]$ ./rman target /

Recovery Manager: Release 11.1.0.7.0 - Production on Sun Jan 6 14:40:36 2013

Copyright (c) 1982, 2007, Oracle. All ...

Automatic SGA changes in 11.2

Published by

zargon

In version 9.2 Oracle changed the way the SGA allocates memory by implementing subpools; each subpool contains all of the necessary memory structures so this allows sessions to access shared areas without incurring the latching waits earlier releases experienced. Unfortunately version 9.2.0.1 through ...

Oracle RAC Database manual creation

Published by

basavraju

Creating Database manually under oracle RAC

Login into node1 as oracle user and set environment as follows

Code :

[oracle@node1 ~]$ . oraenv
ORACLE_SID = [oracle] ? test1
ORACLE_HOME = [/home/oracle] ? /orasoft/10g

Create the directory structure to ...

1 Comment

Monitoring of Flashback Database with Data Dictionary Views

Published by

UnixGuru

Monitoring of Flashback Database with Data Dictionary Views

V$FLASHBACK_DATABASE_LOG, GV$FLASHBACK_DATABASE_LOG (for RAC) - displays information about the flashback data. Use this view to help estimate the amount of flashback space required for the current workload.
V$FLASHBACK_DATABASE_STAT,

...

How to Convert from Oracle Standard Edition to Enterprise Edition

Published by

orafan

Recently I needed to change a standard edition database to Enterprise Edition. Here are the steps I followed from documentation

Since the same "SQL.BSQ" script is used to create the database for each version, the databases are internally almost identical. The conversion process ...

Gather Schema Statistics

Published by

tyro

DBMS_STATS.GATHER_SCHEMA_STATS

In Oracle Database when there is something called Cost Based Optimizer (CBO) which other than doing many things also does query optimization. That is it determines the best or optimum method to run a query. Now when large changes to the data or database ...

1 Comment

Get DDL from EXPDP dumpfile.

Published by

Arju

With parameter sqlfile=file_name you can easily get DDL from dumpfile.
Following is the steps.

1.Create directory where dump resides.

Code :

create directory d as 'E:';

2.Now perform impdp. Note that no actual rows will be imported. Only you will get the file includes ...

1 Comment

Effect of O7_DICTIONARY_ACCESSIBILITY

Published by

Arju

Let's see current value of O7_DICTIONARY_ACCESSIBILITY .

Code :

SQL> show parameter O7_
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
O7_DICTIONARY_ACCESSIBILITY          boolean

...

1 Comment

Oracle DBA Basic Terms for Beginners

Published by

tyro

Oracle DBA Basic Terms for Beginners

In order to become a fully fledged DBA, you need to have an understanding of the fundamental concepts. This article aims to provide the basics of what a DBA is and what a DBA does in their daily role.

The Database Administrator takes ...

2 Comments

AIX Pocket Reference

Published by

simply_dba

Aix Command list in alphabetical order. ...

3 Comments

Oracle Database Administration Examples, Tutorials and Articles

Article Categories