DigiHulk

Ads

Install ORACLE on SOLARIS - STEP by STEP

Labels: oracle, solaris

Newer Post Older Post Home

Popular Posts

Control File all section TRACE ..

To take trace of control file .. alter session set events 'immediate trace name controlf level 9'; Trace file c:\app\vishwakarm...
CREATE DATABASE SCRIPT DESCRIPTION SCRIPT

CREATE DATABASE SCRIPT DESCRIPTION SCRIPT:- CREATE DATABASE mynewdb USER SYS IDENTIFIED BY sys_password USER SYSTEM IDENTIFIED BY sys...
Duplicate database using OEM (Background commands)

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 19 22:15:16 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. SQL> S...
What happen when db_recovery_file_dest_size of 1048576 bytes is 100.00% used.

SQL> show parameter db_recovery NAME TYPE VALUE ------------------------------------ --------...
AUTO START DATABASE ON BOOTING

AUTO START DATABASE ON BOOTING STEP:-1 First make the entry in oratab as “Y” ,to which we want to start our database autostart . -MAK...
All session events in ORACLE DATABASE

SQL> select distinct(event) from v$session_event; EVENT ---------------------------------------------------------------- os threa...
How to calculate overall time of a SQL statement.

How to calculate overall time of a SQL statement. SQL> set timing on SQL> set time on 08:48:52 SQL> select count(*) from pk; ...
How to take dump or trace of library cache || internal of library cache

To take trace or dump of library cache, enter following command on sqlplus. alter session set events 'immediate trace name library_c...

Popular Posts

Control File all section TRACE ..

To take trace of control file .. alter session set events 'immediate trace name controlf level 9'; Trace file c:\app\vishwakarm...
CREATE DATABASE SCRIPT DESCRIPTION SCRIPT

CREATE DATABASE SCRIPT DESCRIPTION SCRIPT:- CREATE DATABASE mynewdb USER SYS IDENTIFIED BY sys_password USER SYSTEM IDENTIFIED BY sys...
Duplicate database using OEM (Background commands)

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 19 22:15:16 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. SQL> S...
What happen when db_recovery_file_dest_size of 1048576 bytes is 100.00% used.

SQL> show parameter db_recovery NAME TYPE VALUE ------------------------------------ --------...
AUTO START DATABASE ON BOOTING

AUTO START DATABASE ON BOOTING STEP:-1 First make the entry in oratab as “Y” ,to which we want to start our database autostart . -MAK...
All session events in ORACLE DATABASE

SQL> select distinct(event) from v$session_event; EVENT ---------------------------------------------------------------- os threa...
How to calculate overall time of a SQL statement.

How to calculate overall time of a SQL statement. SQL> set timing on SQL> set time on 08:48:52 SQL> select count(*) from pk; ...
How to take dump or trace of library cache || internal of library cache

To take trace or dump of library cache, enter following command on sqlplus. alter session set events 'immediate trace name library_c...
Install ORACLE on SOLARIS - STEP by STEP
Sar linux all command and output

[root@localhost /]# sar Linux 2.6.18-308.el5 (localhost.localdomain) 03/14/2017 12:00:01 AM CPU %user %nice %system...

Facebook Like Box

DigiHulk

Labels

linux (1) oracle (4) oracle internals (2) sar (1) solaris (1)

DigiHulk. Awesome Inc. theme. Theme images by fpm. Powered by Blogger.