. Oracle Backup and Recovery Solutions Purpose of Backup and Recovery: As a backup administrator, your principal duty is to devise, implement, and manage a backup and recovery strategy. In general, the purpose of a backup and recovery strategy is to protect the database against data loss and reconstruct the database after data loss. Typically, …
PID FOR ORADEBUG PID FOR ORADEBUG How to find PID for setospid in oradebug? Doc ID: Note:105395.1 PURPOSE The purpose of this bulletin is to instruct the user how toget the correct pid for the oradebug command: oradebug setospid SCOPE & APPLICATION This bulletin is directed to anyone using oradebug, possiblyto troubleshoot hanging issues. How …
PGA Oracle 12c New Features 08 Srinivas Maddali PGA Size Limit This feature limits the total amount of Program Global Area (PGA) that an instance can allocate, using a parameter called PGA_AGGREGATE_LIMIT. When the instance has allocated the PGA_AGGREGATE_LIMIT amount of PGA, sessions with the highest amount of allocated PGA are stopped until the limit is complied with. …
OVERVIEW Oracle Recovery Manager satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats. A complete high availability and disaster recovery strategy requires dependable data backup, restore, and recovery procedures. Oracle Recovery Manager (RMAN), a command-line and Enterprise Manager-based tool, is the Oracle-preferred method for efficiently backing up and …
ORDBA WIZARD This tool is aimed at enabling Oracle DBA to monitor and perform all the jobs of a DBA including creation of database. This screen is gives all the vital stats that measure performance and information on free space, tablespace and the associated data files, rollback segments, sessions and I/O analysis. It also enables …
ORAPWD orapwd file=password_file_name_with_complete path password=the_password orapwd file=password_file_name_with_complete path password=the_password entries = n n specifies the maximum number of distinct DBAs and OPERs that can be stored in the password file. Oracle’s password file: If the DBA wants to start up an Oracle instance, there must be a way for Oracle to authenticate this DBA if …
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 are 1. ORADIM this utility enable to create windows services for an Oracle Instance for …
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 table system.session_sql_detail; create table system.session_sql_detailasselect a.*,b.sql_textfrom v$session a,v$sql bwhere a.sql_hash_value=b.hash_valueand a.sid=(select sid from v$mystat where …
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 three physical structures after the instance is created using the initialization parameter file. As long …
ORACLE EDITION AND OPTIONS BUY-ABLE Download and check this execell sheet for information Oracle Edition and Options Buy-able
Copyright © 2002-2023 Srinivas Maddali, All rights reserved.