Home
Search results “Size log buffer oracle”
Redo Logs in an Oracle Database - DBArch Video 11
 
08:54
This video explains the concepts of Redo Log Groups and Files in an Oracle Database. You will understand how Oracle Instance uses Redo Buffers and Logwriter to keep the redo in Redo Logs. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 20261 Ramkumar Swaminathan
Tutoriel Oracle DBA1 (24) : Le composant mémoire Log Buffer.
 
08:06
Bonjour, Abonnez-vous à Sybaway : http://goo.gl/dBJO13 Plus de tutoriels : http://goo.gl/Ut31RF Facebook : http://goo.gl/DC7AIA Twitter : http://goo.gl/PUrQga Sybaway
Views: 2136 Abdessamad HALLAL
Arquitetura-Oracle- Log Buffer
 
02:31
Este vídeo ilustra o funcionamento do mecanismo de Redo Log Buffer.
Views: 485 DBA Maker
Table size ,Number of records,Disk usage in SQL Database,clear logs,cache
 
06:51
This clip will show you how to check each Table size, Number of records, Disk usage in SQL Database. You can see how to write the query to get details of all tables in terms of size, records, space utilization and free space on disk for tables. http://daynamicsaxaptatutorials.blogspot.com This is axapta ERP blog for Technical and functional fields and includes Microsoft Dynamics Axapta tutorials and Dynamics Axapta Coverage. This blog also contains x++ code help for Ax developer and solution of technical and functional daily issues. This blog is specific for Microsoft dynamics programming. Enterprise portal, SharePoint services, business connectors and Enterprise Resource Planning applications and sql database.It will help to get Microsoft Business Solutions.
Views: 955 Santosh kumar Singh
Arquitetura-Oracle- Log Buffer
 
02:26
Aula exemplo para 2014...
Views: 197 Marcio Guimaraes
How to find block sizes of all Oracle Database files
 
14:02
Block size of control files and redo log files are not same as default block size of your oracle database. Understand the level of control we got to alter these block sizes from one of my real time activity. Many more interesting blogs at : www.orskl.com/blog Looking for Oracle DBA training: www.orskl.com/training WhatsApp: +919951696808
Views: 3348 OrSkl Academy
How to reszie the redolog file
 
14:15
In this video i'm going to demonstrate you how to resize the redolog file step by step, this is only one method to resize the redolog file.
Views: 2508 OCP Technology
How to choose the proper Size for online redo log files using redo log advisor.
 
01:25
This Video is about ow to set the optimum size of the Online redo log files, Using Redo log advisor in Oracle database Credits: OMS workload Pic: https://www.databasejournal.com/features/oracle/article.php/3882876/Monitoring-Oracle-Database-11g-R2-with-Oracle-Enterprise-Manager.htm Music: https://www.bensound.com
Views: 47 ORA-600
What are Data Blocks - DBArch Video 28
 
03:29
In this video you will learn about an Oracle Database block, what are the possible sizes and how it impacts the tables. Also you will learn about setting up multiple block sizes and how to configure the Buffer Cache for a database with multiple block sizes . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 3756 Ramkumar Swaminathan
Data Buffering for Data Logging
 
07:30
How to setup data logging so there is no data loss on a network or database engine failure.
Why should we configure limits.conf for Oracle database
 
21:16
Real time example - As Oracle DBA, you must have installed Oracle database software on UNIX platforms. But why did you configure limits.conf file ? This blog will help you understand with a real time example. Want Oracle DBA training? check www.orskl.com/training Whatsapp: +919951696808
Views: 1715 OrSkl Academy
oracle sga memory tuning oracle database buffer  cache
 
05:34
oracle system global area description brief description of components of oracle sga memory oracle system global area oracle database buffer cache oracle shared area memory
Will huge Consistent Reads floods BUFFER CACHE?
 
12:13
Video Blog on Oracle Real Time Activity regarding CACHE chains in BUFFER CACHE on Consistent Read operations. Looking for Oracle DBA training? WhatsApp/Contact: +919951696808 More training options at www.orskl.com/training
Views: 2106 OrSkl Academy
ORACLE -  Managing Undo and Flashback
 
06:49
Tugas UTS Mata Kuliah Manajemen Basis Data 2016 S1 Sistem Informasi Telkom University
3 values you should know when tuning the SQL statement
 
12:26
Are you tuning an SQL statement, these 3 values might help you tune better
Views: 2916 OrSkl Academy
Oracle DBA - Dataguard Realtime
 
14:14
Understand Redo/Archive shipping at Network and process level in Dataguard. Find us @ facebook : https://www.facebook.com/orsklacademy For training on Oracle DBA please visit - www.orskl.com
Views: 17888 OrSkl Academy
HOW TO INCREASE DECREASE MEMORY TARGET IN ORACLE 11G
 
04:55
How to increase/decrease memory_target in 11g ====================================================== oracle 10g --sga_target (parameter new in 10g) oracle 11g --memory_target (parameter new in 11g) How to check whether the parameter is static or dynamic? ========================================================= select name, value, issys_modifiable from v$parameter where name like '%&parameter%' ; if issys_modifiable=false --- parameter is static (database bounce required) if issys_modifiable=immediate --- parameter is dynamic (database bounce not required) (note: consider using spfile) sql commands ================ show parameter memory; alter system set memory_target=350m scope=spfile; alter system set memory_max_target=350m scope=spfile;
Views: 5253 Praveen Biyyapu
How to Export and import oracle 10g database .rm
 
03:55
طريقة استيراد و تصدير قاعدة بيانات من أوراكل
Views: 78773 MahmoudRFarra
What exactly is PLAN TABLE in Oracle Database #Performance #Tuning
 
16:00
Running an EXPLAIN PLAN to generate EXECUTION PLAN in oracle database is possible with PLAN_TABLE. But this video will give you much more insights of what is this PLAN_TABLE. Learn how is PLAN_TABLE called as global temporary table. Need Oracle database training? WhatsApp to +919951696808 visit www.orskl.com/training
Views: 3147 OrSkl Academy
Save putty logs, change putty colour and font size
 
03:55
Oracle Concepts : Save putty logs, change putty background color and font size.
Views: 2668 Oracle Conepts
Oracle 11g Multiplexing Your Online Redo Log Files
 
04:04
In this tutorial i'm going to show you how to do Multiplexing Your Online Redo Log Files in Oracle 11g using command mode.
Views: 1562 OCP Technology
Database Tutorial  69 - SGA System Global Area of an Oracle Database - Oracle DBA Tutorial
 
08:01
Database Tutorial 69 - SGA System Global Area of an Oracle Database - Oracle DBA Tutorial SGA - System Global Area
Views: 12999 Sam Dhanasekaran
How to increase the scroll buffer size in PuTTY
 
02:39
• PuTTY doesn't allow you to scroll up very far. It becomes annoying when running programs having lots of input you might need to scroll through and review. • One command that can sometimes produce a lot of output is Is- the command to list a directory contents. • Type Is -- I/ to list the contents of the root directory. Press Enter to execute a shell command. • Type the command shown to list the contents of all directories contained by home directory. Scroll up. The command we just typed. Output of previous command will be shown above. • Scroll up. You can reach top of scrollbar and still can't see first command we typed; it's just barely out of range. • Increase size of scroll buffer. Close this session and re-open PuTTY to configuration window. Select session from the list and then click Load button. • Go to Window button. Enter higher value for Lines of scrollback. • Go to Session category. Click on Save button after filling options. • Log in normally and once logged in, test out new scroll buffer size. Type command from before several times. End each line with shell comment as shown. • Watch size of scrollbar. First command will be displayed and change will work.
Views: 12360 kvchosting
Oracle Database Administration-  REDO LOG FILE MANAGEMENT PART II
 
32:43
Oracle Database Administration- REDO LOG FILE MANAGEMENT PART II
Views: 26 SooCloudy
1 technique to be safe and not sorry as Oracle DBA
 
12:33
As an Oracle DBA, be safe with your data - scripts, docs, white papers and other references
Views: 2206 OrSkl Academy
How Oracle database does instance recovery after failures
 
12:53
A real time activity to demonstrate how Oracle database performs automatic instance recovery after a failure. This video blog will take a real example to prove the concepts in reality. Need DBA training? Whatsapp : +919951696808 More blogs at https://www.orskl.com
Views: 2091 OrSkl Academy
What is the Buffer Pool
 
01:18
What is the Buffer Pool ?
Views: 6735 SQLServer Work
Trace session details with USER process and SERVER process ID
 
13:43
Oracle database user session tracing.
Views: 7669 OrSkl Academy
Change Undo Tablespace in Oracle
 
05:17
Si te gusto dale me gusta y suscribete !!
Views: 152 FULL-ORACLE
Dataguard   Real time apply
 
14:10
Understand what is Real time apply in Oracle Dataguard
Views: 7938 OrSkl Academy
How to run VBScript programs !! Database Training Training ! Infotek-SolutionInc
 
02:26
For Complete Database Training Details Visit: http://www.qaonlinetraining.com http://infotek-solutions.com/ Delivery Method: Instructor led classroom and Online Training supported by world class Learning management system which automate all flow of lectures, videos, assignments, forums, quizzes and interview process. Class Schedule: Week-ends and Weekdays Contact Us: 571-437-0652, Mail Us: [email protected] Training Locations at : Ashburn / Fairfax / Maryland Office Address: 12801 Worldgate Dr #500, Herndon, VA 20170 Overview of Oracle DBA Training Oracle as a flexible, complex & robust RDBMS The evolution of hardware and the relation to Oracle Different DBA job roles (VP of DBA, developer DBA, production DBA, database babysitter) The changing job role of the Oracle DBA Environment management (network, CPU, disk and RAM) Instance management (managing SGA regions) Oracle table and index management Instance Architecture Instance vs. database Components of an instance Creating the OFA file structure ($DBA, bdump, udump, pfile) Oracle Instance Internals SGA vs. PGA Background processes Interfaces with server and disk I/O subsystem Using SQL*Plus for DBA management Connecting and executing SQL Using the “as sysdba” syntax Overview of SQL*Plus DBA commands (startup, etc.) Control file, UNDO and REDO management Explaining the use of control files Listing the Contents of the control File File locations for control Files Obtaining Control File Information Listing control file contents Displaying and Creating Undo segments Altering Undo Segments Determining the Number and Size of Undo segments Understanding flashback technology Troubleshooting Undo – snapshot too old Redo log concepts for recovery Online redo log (log_buffer) online redo logs and archived redo logs Oracle ARCH and LGWR background processes Redo log dictionary queries Redo log switch frequency and performance Multiplexing the Online Redo Log Files Archiving the Oracle Redo Logs Recovery using the redo log files User and privilege management The three security methods (VPD, Grant security/role-based security, grant execute) Creating New Database Users Using pre-spawned Oracle connections Auditing User activity Identifying System and Object Privileges Granting and Revoking Privileges Creating and Modifying Roles Displaying user security Information from the Data Dictionary Overview of instance management Parameter files (init.ora, listener.ora, tnsnames.ora) Rules for sizing SGA components Automated Oracle memory management (AMM) Initialization file management Creating the init.ora file Using spfile Displaying init.ora values with v$parameter Oracle*Net configuration Creating the listener.ora file Creating the tnsnames.ora file Data buffer configuration & sizing Inside the Oracle data buffers Using the KEEP pool Monitoring buffer effectiveness Using multiple blocksizes (multiple buffer pools) Shared pool and PGA configuration & Sizing Shared pool concepts and components Understanding the library cache Relieving shared pool contention Overview of PGA for sorting and hash joins Using sort_area_size, hash_area_size and pga_aggregate_target Troubleshooting network connectivity Verifying network connectivity with ping and tnsping Testing database links Oracle tables, views and materialized views Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables) Oracle Views Oracle materialized views Oracle indexes Types of Oracle indexes (b-tree, bitmap, bitmap join index) Creating B*-Tree, bitmap and function-based Indexes Function-based indexes Finding indexing opportunities Index maintenance Oracle constraints Costs & benefits of constraints Types of Oracle indexes constraints (check, not null, unique, PK, FK) Cascading constraints Schema, File & tablespace management Describing the relationship between data files, tablespaces and table Understanding Oracle segments Creating Tablespaces – using the autoextend option Changing the Size of Tablespaces – alter database datafile command Defining a TEMP tablespace Changing the default storage Settings for a tablespace Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists). Monitoring Chained rows (fetch continued rows) Monitoring Insert and Update performance (pctused, APPEND) Database Maintenance Reason for reorgs – chained rows, imbalanced freelists Reorganizing Tables using Export and Import Using CTAS to reorganize data Index rebuilding Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) Oracle DBA Utilities Data pump (Imp and exp utilities) SQL*Loader LogMiner Flashback DataGuard Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
How configure oracle 11g In Archivelog Mode & No archvielog Mode On Redhat
 
16:45
The following are the steps required to enable archive log mode on an Oracle 10g or 11g database. Verify the database log mode. [email protected] sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 8 12:02:52 2010 Copyright 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 25 Current log sequence 27 SQL The log mode is No Archive Mode. Note that Archive destination is USE_DB_RECOVERY_FILE_DEST. You can determine the path by looking at the parameter RECOVERY_FILE_DEST. SQL show parameter recovery_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/flash_recovery _area db_recovery_file_dest_size big integer 3852M SQL By default, archive logs will be written to the flash recovery area. If you do not want to write archive logs to the flash recovery area you can set the parameter LOG_ARCHIVE_DEST_n to the location in which you wish to write archive logs. SQL alter system set log_archive_dest_1='LOCATION=/u02/app/oracle/oradata/orcl/arch' scope = both; System altered. SQL archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 25 Current log sequence 27 SQL Now we shutdown the database and bring it backup in mount mode. SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount ORACLE instance started. Total System Global Area 849530880 bytes Fixed Size 1339824 bytes Variable Size 511708752 bytes Database Buffers 331350016 bytes Redo Buffers 5132288 bytes Database mounted. SQL Lastly all that is needed it set archive log mode and open the database. SQL alter database archivelog; Database altered. SQL alter database open; Database altered. SQL archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 25 Next log sequence to archive 27 Current log sequence 27 SQL We can now see that archive log mode is enabled. Notice that Automatic archive is enabled as well. In Oracle 9i an earlier another parameter needed to be set in order to enable automatic archiving. This in no longer the case in 10g and 11g as automatic archiving is enabled when the database is placed in archive log mode. You can switch to the log file to see that an archive is written to archive log location. SQL alter system switch logfile; System altered. SQL host [email protected] ~$ ls /u02/app/oracle/oradata/orcl/arch 1_27_711369564.dbf [email protected] ~$ exit exit SQL The following are the steps required to disable archive log mode on an Oracle 10g or 11g database. Verify the database log mode. [email protected] ~$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 8 12:54:05 2010 Copyright c 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 26 Next log sequence to archive 28 Current log sequence 28 he Database log mode is Archive mode. Next we shut down the database and bring up back up in mount mode. SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount ORACLE instance started. Total System Global Area 849530880 bytes Fixed Size 1339824 bytes Variable Size 511708752 bytes Database Buffers 331350016 bytes Redo Buffers 5132288 bytes Database mounted. SQL All that is left is to disable archive log mode and open the database. SQL alter database noarchivelog; Database altered. SQL alter database open; Database altered. SQL archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 26 Current log sequence 28 SQL
Views: 206 Md Arshad
Interesting fact on reading data from GV$ views in RAC
 
11:05
How data is fetched from GV$ views in oracle RAC
Views: 890 OrSkl Academy
Can you really flush Oracle SHARED POOL
 
11:21
This video will explain what happens in reality when you issue ALTER SYSTEM FLUSH SHARED_POOL. A step by step case study will give you the answers by the end of this video session. Oracle DBA training: Need some training on Performance tuning? - Whatsapp +919951696808 Look for more contents on training at: www.orskl.com/training
Views: 3002 OrSkl Academy
Oracle 11gR2 RAC DEMO
 
16:43
Demonstration on Oracle 11gR2 RAC training.
Views: 2106 OrSkl Academy
How to Install Oracle! !! Database Training
 
01:50
For Complete Database Training Details Visit: http://www.qaonlinetraining.com http://infotek-solutions.com/ Delivery Method: Instructor led classroom and Online Training supported by world class Learning management system which automate all flow of lectures, videos, assignments, forums, quizzes and interview process. Class Schedule: Week-ends and Weekdays Contact Us: 571-437-0652, Mail Us: [email protected] Training Locations at : Ashburn / Fairfax / Maryland Office Address: 12801 Worldgate Dr #500, Herndon, VA 20170 Overview of Oracle DBA Training Oracle as a flexible, complex & robust RDBMS The evolution of hardware and the relation to Oracle Different DBA job roles (VP of DBA, developer DBA, production DBA, database babysitter) The changing job role of the Oracle DBA Environment management (network, CPU, disk and RAM) Instance management (managing SGA regions) Oracle table and index management Instance Architecture Instance vs. database Components of an instance Creating the OFA file structure ($DBA, bdump, udump, pfile) Oracle Instance Internals SGA vs. PGA Background processes Interfaces with server and disk I/O subsystem Using SQL*Plus for DBA management Connecting and executing SQL Using the “as sysdba” syntax Overview of SQL*Plus DBA commands (startup, etc.) Control file, UNDO and REDO management Explaining the use of control files Listing the Contents of the control File File locations for control Files Obtaining Control File Information Listing control file contents Displaying and Creating Undo segments Altering Undo Segments Determining the Number and Size of Undo segments Understanding flashback technology Troubleshooting Undo – snapshot too old Redo log concepts for recovery Online redo log (log_buffer) online redo logs and archived redo logs Oracle ARCH and LGWR background processes Redo log dictionary queries Redo log switch frequency and performance Multiplexing the Online Redo Log Files Archiving the Oracle Redo Logs Recovery using the redo log files User and privilege management The three security methods (VPD, Grant security/role-based security, grant execute) Creating New Database Users Using pre-spawned Oracle connections Auditing User activity Identifying System and Object Privileges Granting and Revoking Privileges Creating and Modifying Roles Displaying user security Information from the Data Dictionary Overview of instance management Parameter files (init.ora, listener.ora, tnsnames.ora) Rules for sizing SGA components Automated Oracle memory management (AMM) Initialization file management Creating the init.ora file Using spfile Displaying init.ora values with v$parameter Oracle*Net configuration Creating the listener.ora file Creating the tnsnames.ora file Data buffer configuration & sizing Inside the Oracle data buffers Using the KEEP pool Monitoring buffer effectiveness Using multiple blocksizes (multiple buffer pools) Shared pool and PGA configuration & Sizing Shared pool concepts and components Understanding the library cache Relieving shared pool contention Overview of PGA for sorting and hash joins Using sort_area_size, hash_area_size and pga_aggregate_target Troubleshooting network connectivity Verifying network connectivity with ping and tnsping Testing database links Oracle tables, views and materialized views Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables) Oracle Views Oracle materialized views Oracle indexes Types of Oracle indexes (b-tree, bitmap, bitmap join index) Creating B*-Tree, bitmap and function-based Indexes Function-based indexes Finding indexing opportunities Index maintenance Oracle constraints Costs & benefits of constraints Types of Oracle indexes constraints (check, not null, unique, PK, FK) Cascading constraints Schema, File & tablespace management Describing the relationship between data files, tablespaces and table Understanding Oracle segments Creating Tablespaces – using the autoextend option Changing the Size of Tablespaces – alter database datafile command Defining a TEMP tablespace Changing the default storage Settings for a tablespace Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists). Monitoring Chained rows (fetch continued rows) Monitoring Insert and Update performance (pctused, APPEND) Database Maintenance Reason for reorgs – chained rows, imbalanced freelists Reorganizing Tables using Export and Import Using CTAS to reorganize data Index rebuilding Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) Oracle DBA Utilities Data pump (Imp and exp utilities) SQL*Loader LogMiner Flashback DataGuard Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
size of a database
 
04:10
Views: 250 Chris Morris
Oracle Code Boston: Keynotes: Grand Ballroom A/B
 
01:51:09
https://developer.oracle.com/code/boston-april-2018
Views: 446 Oracle Developers
DB2 Performance Myth Buster 2 - How Increasing Bufferpool Size will not increase LOAD Performance
 
09:09
How Increasing Bufferpool Size will not increase LOAD Utility Performance Look for Direct I/O. Happy Learning & Sharing
Views: 627 DB2-LUW-ACADEMY
0302 Transaction Log
 
05:56
Views: 9383 solubletech
Making Real Time CPU Utilization Monitoring Script - Tech Arkit
 
25:00
How to Monitor CPU Utilization using Shell Script and Get an Email Alert When CPU Usage is HIGH. Making Real Time CPU Utilization Monitoring Script - Tech Arkit Facebook Page: https://www.facebook.com/Linuxarkit/ LinkedIn Profile: https://www.linkedin.com/in/ravi-kumar-94530121 Google Plus: https://plus.google.com/u/0/+RedhatEnterpriseLinuxStepbyStepGuide Twitter: https://twitter.com/aravikumar48 RSS Feed: https://feedburner.google.com/fb/a/mailverify?uri=arkit Reddit: https://www.reddit.com/user/aravikumar48/ Tumblr: https://www.tumblr.com/blog/aravikumar48
Views: 2382 Tech Arkit
DBMS - Sparse vs. Dense Index
 
03:55
DBMS - Sparse vs. Dense Index Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Arnab Chakraborty, Tutorials Point India Private Limited
Reclaiming free space from innodb tables
 
06:05
Reclaiming free space from innodb tables
Views: 168 Ask Guru
Locks   Blocks   Deadlocks
 
08:49
Understanding Locks, Blocks and dead locks in oracle database.
Views: 3925 OrSkl Academy
Quick Tip - Debug.Log
 
00:49
This tip shows you a quick way to find objects in the inspector that are giving you issues and get the most out of your logging
Views: 782 Jason Storey
How to Setup Mysql on your machine
 
03:11
For Complete Database Training Details Visit: http://www.qaonlinetraining.com http://infotek-solutions.com/ Delivery Method: Instructor led classroom and Online Training supported by world class Learning management system which automate all flow of lectures, videos, assignments, forums, quizzes and interview process. Class Schedule: Week-ends and Weekdays Contact Us: 571-437-0652, Mail Us: [email protected] Training Locations at : Ashburn / Fairfax / Maryland Office Address: 12801 Worldgate Dr #500, Herndon, VA 20170 Overview of Oracle DBA Training Oracle as a flexible, complex & robust RDBMS The evolution of hardware and the relation to Oracle Different DBA job roles (VP of DBA, developer DBA, production DBA, database babysitter) The changing job role of the Oracle DBA Environment management (network, CPU, disk and RAM) Instance management (managing SGA regions) Oracle table and index management Instance Architecture Instance vs. database Components of an instance Creating the OFA file structure ($DBA, bdump, udump, pfile) Oracle Instance Internals SGA vs. PGA Background processes Interfaces with server and disk I/O subsystem Using SQL*Plus for DBA management Connecting and executing SQL Using the “as sysdba” syntax Overview of SQL*Plus DBA commands (startup, etc.) Control file, UNDO and REDO management Explaining the use of control files Listing the Contents of the control File File locations for control Files Obtaining Control File Information Listing control file contents Displaying and Creating Undo segments Altering Undo Segments Determining the Number and Size of Undo segments Understanding flashback technology Troubleshooting Undo – snapshot too old Redo log concepts for recovery Online redo log (log_buffer) online redo logs and archived redo logs Oracle ARCH and LGWR background processes Redo log dictionary queries Redo log switch frequency and performance Multiplexing the Online Redo Log Files Archiving the Oracle Redo Logs Recovery using the redo log files User and privilege management The three security methods (VPD, Grant security/role-based security, grant execute) Creating New Database Users Using pre-spawned Oracle connections Auditing User activity Identifying System and Object Privileges Granting and Revoking Privileges Creating and Modifying Roles Displaying user security Information from the Data Dictionary Overview of instance management Parameter files (init.ora, listener.ora, tnsnames.ora) Rules for sizing SGA components Automated Oracle memory management (AMM) Initialization file management Creating the init.ora file Using spfile Displaying init.ora values with v$parameter Oracle*Net configuration Creating the listener.ora file Creating the tnsnames.ora file Data buffer configuration & sizing Inside the Oracle data buffers Using the KEEP pool Monitoring buffer effectiveness Using multiple blocksizes (multiple buffer pools) Shared pool and PGA configuration & Sizing Shared pool concepts and components Understanding the library cache Relieving shared pool contention Overview of PGA for sorting and hash joins Using sort_area_size, hash_area_size and pga_aggregate_target Troubleshooting network connectivity Verifying network connectivity with ping and tnsping Testing database links Oracle tables, views and materialized views Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables) Oracle Views Oracle materialized views Oracle indexes Types of Oracle indexes (b-tree, bitmap, bitmap join index) Creating B*-Tree, bitmap and function-based Indexes Function-based indexes Finding indexing opportunities Index maintenance Oracle constraints Costs & benefits of constraints Types of Oracle indexes constraints (check, not null, unique, PK, FK) Cascading constraints Schema, File & tablespace management Describing the relationship between data files, tablespaces and table Understanding Oracle segments Creating Tablespaces – using the autoextend option Changing the Size of Tablespaces – alter database datafile command Defining a TEMP tablespace Changing the default storage Settings for a tablespace Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists). Monitoring Chained rows (fetch continued rows) Monitoring Insert and Update performance (pctused, APPEND) Database Maintenance Reason for reorgs – chained rows, imbalanced freelists Reorganizing Tables using Export and Import Using CTAS to reorganize data Index rebuilding Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) Oracle DBA Utilities Data pump (Imp and exp utilities) SQL*Loader LogMiner Flashback DataGuard Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)