Home » Oracle

ORACLE ARCHITECTURE

INSTALLING ORACLE 11.2.0.4 ON X86 64 BIT LINUX RHEL – REQUIREMENTS? (FROM AND BY ORACLE) APPLIES TO: Oracle Database – Standard Edition – Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Oracle Database – Enterprise Edition – Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Linux

ORACLE TRINITY

ORACLE TRINITY How Oracle manages the security to database not in terms of user loggings? I call this the Oracle Trinity. The great potential energy is stored in the parameter file that enabled the trinity become active. Oracle depends on

ORACLE WAIT INTERFACE

ORACLE WAIT INTERFACE OWI-v7 script by Srinivas Maddali (NOTE: This script is evolving continuously) DROP TABLE system.session_event_history; create table system.session_event_history(sid,serial#,username,osuser,paddr,process,logon_time,type,event,total_waits,total_timeouts,time_waited,average_wait,max_wait,logoff_timestamp)asselect a.sid,b.serial#,b.username,b.osuser,b.paddr,b.process,b.logon_time,b.type,a.event,a.total_waits,a.total_timeouts,a.time_waited,a.average_wait,a.max_wait,sysdate logoff_timefrom v$session_event a,v$session bwhere a.sid=b.sidand b.username=login_userand b.sid=(select sid from v$mystat where rownum <2> and 1=2/ TRUNCATE TABLE system.session_event_history; DROP

ORADIM

ORADIM  This is a big and voluminous area with large documentation and case studies on the metalink. There are documented and undocumented utilities provided by Oracle. Documented Utilities There are some exclusive utilities that are available for Windows platform. They

Scroll to Top