Search results “In memory table oracle” for the 2011
Oracle Database 12c demos: In-Memory Column Store Architecture Overview
The demonstration provides an overview of the architecture of the In-Memory Column Store feature introduced in Oracle Database 12c Release 1 patchset 1.
Oracle Database 12c demos: In-Memory Column Store Queries
The demonstration illustrates how queries on in-memory objects and columns data populated within the IM column store execute. The demo also shows how fast the queries execute against the In-Memory column store compared to the buffer cache.
In-Memory in Oracle Database 12c
In-Memory is a new feature in Oracle Database 12c. This features allows you to store columns, tables, partitions and materialized views in memory in a columnar format, rather than the typical row format.
Views: 192 Koenig Solutions
Oracle Database In-Memory Performance Demo
Demonstration of Oracle Database In-Memory from Oracle's Real World Performance Team.
Full DB In-Memory Caching
This is the first of two demonstrations about In-Memory caching new features, introduced in Oracle Database This one illustrates the Full Database In-memory Caching feature enabling an entire database to be cached in memory when the database size is smaller than the buffer cache size. Caching and running a database from memory leads to huge performance benefits. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Oracle Database 12c demos: In-Memory Column Store Columns
The demonstration illustrates how columns are handled by in-memory objects in the IM column store.
#2-  Error ORA-01034: ORACLE not available  ORA-27101: shared memory realm does not exist
Question: I am getting the errors ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist. Cause: Oracle was not started up. SOLUTION : START UP DATABASE. #3- Error ORA 01045 user lacks CREATE SESSION privilege HD https://www.youtube.com/watch?v=pLqASraIMxM
Views: 6296 Houssine Formation
flashback in Oracle | Oracle SQL Tutorial Videos | Mr.Vijay Kumar
flashback in Oracle | Oracle SQL Tutorial Videos | Mr.Vijay Kumar ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 💡 Visit Our Website for Classroom Training: https://nareshit.in/oracle-training/ 💡 For Online Training: https://nareshit.com/oracle-online-training/ #Oracle #Training #CourseVideos -------------------------- 💡 About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations -------------------------- 💡 Our Online Training Features: 🎈 Training with Real-Time Experts 🎈 Industry Specific Scenario’s 🎈 Flexible Timings 🎈 Soft Copy of Material 🎈 Share Videos of each and every session. -------------------------- 💡 Please write back to us at 📧 [email protected]/ 📧 [email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999 -------------------------- 💡 Check The Below Links ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/+NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitek ► Follow us on Linkedin: https://goo.gl/CRBZ5F ► Follow us on Instagram: https://goo.gl/3UXYK3
Views: 15994 Naresh i Technologies
Oracle Database 12c demos: In-Memory Column Store Priority
The demonstration illustrates how inmemory priority can be set on objects to define when column data population should take place in the IM column store.
Oracle DB - Memory Architecture
Oracle DB - Memory Architecture Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Oracle TimesTen In-Memory Database
See how Oracle TimesTen In-Memory Database delivers predictable microsecond response time and rock solid reliability for existing Oracle Database applications and new ones.
Views: 18667 Oracle Video
Oracle DBA Justin - How to re-create the special table dual in an Oracle database # 1 of 2
How to re-create the special table dual in an Oracle database
Views: 2876 jbleistein11
Oracle Database 12c demos: In-Memory Column Store Compression
The demonstration illustrates how inmemory compression of inmemory objects populated in the IM column store can influence either query performance or storage savings in IM column store.
Oracle Database and Instance Components - DBArch Video 3
In this video you will learn about the Relationship between and Oracle Instance and an Oracle Database. You will know about the various components of an Instance ( SGA and Background Processes) and the various files of the Database and how they interact. 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: 36104 Ramkumar Swaminathan
Oracle Database Architecture | Oracle Memory Structures
Oracle Database Architecture | Oracle Memory Structures ___________________________________________________________
Views: 60 Hansdsome hunk
SSMA for Oracle 7.0 — What’s New — Using In-Memory OLTP in SQL Server 2016
The new version of SQL Server Migration Assistant (SSMA) 7.0 now supports direct migration of Oracle Database 12c In-Memory tables to SQL Server 2016 In-Memory tables.
Relationships of Physical and Logical Storage structures in an Oracle Database - DBArch Video 22
In this video you will understand the Relationships between the Physical files and Logical Components - Tablespace, Segments, Extents and Oracle Blocks in an Oracle Database . 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: 14941 Ramkumar Swaminathan
Oracle Database 12c: Easy Top N and Pagination Queries
Pagination queries using the row limiting clause to fetch N rows or a percentage of rows in a table. For more information, see [Limiting SQL Rows](http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DWHSG9188), [row_limiting_clause](http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF55636).
Views: 3557 OracleDBVision
SQL: Delete Vs Truncate Vs Drop
In this tutorial, you'll learn the difference between delete/drop and truncate. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 69251 radhikaravikumar
Oracle Database In-Memory & The Optimizer - DBIM Workshop part 4
Oracle Database In-Memory introduces a new in-memory only columnar format and a new set of SQL execution optimizations such as SIMD processing, column elimination, storage indexes and In-Memory aggregation. The Oracle Optimizer is fully aware of the new In-Memory functionality and has adapted its cost model to allow existing query workloads to take full advantage of in-memory columnar tables. This 45 minute session provides an overview of what has changed with the Optimizer, shows how to understand the new execution plans, and explains how query workloads benefit from in-memory.
Oracle Database 12c demos: In-Memory Column Store Monitored with Enterprise Manager
The demonstration illustrates how to handle In-Memory Column Store with Enterprise Manager Cloud Control.
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: 5252 Praveen Biyyapu
Oracle Database Tutorial 63 : Introduction to Tablespace In Oracle Database
Introduction to tablespace in oracle database consist Brief intro of tablepsace, type of tablespace, Big and small file tablespace, intro of Data files in oracle By manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/tablespace-introduction-rebellionrider Previous Tutorial ► Indexes https://youtu.be/F5NrQYD4a9g ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 36670 Manish Sharma
Complex Reports Run Faster using Oracle Database In-Memory
Die Mobiliar discusses the simplicity of setup and performance benefits or Oracle Database In-Memory for complex reporting.
Oracle memory structures
Oracle database Administration 11g workshop 1 course Oracle memory structures Oracle Course In Abu Dhabi
Views: 1360 NH Abu Dhabi
SELECT statement Processing in an Oracle Database - DBArch  Video 7
You will learn from this video how a SELECT statement is processed in an Oracle Database. You will learn about the a Parse, Execute and Fetch phases in a select statement. 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: 31923 Ramkumar Swaminathan
Digital Transformation, Data Warehousing, and Oracle In-Memory
Organizations undergoing digital transformation need information for effective cross-channel and cross-product analysis to steer that transformation. In this 2 Minute Tech Tip Emiel van Bockel and Rene Kuipers discuss how they provide that information to their customers via a data warehousing environment that includes Oracle Exadata and Exalytics, and the amazing results they’ve achieved with the introduction of Oracle In-Memory.
Views: 86 ArchBeat Archive
Oracle Database In-Memory Demo By Juan Loaiza
Oracle Database In-Memory is one of the key new features in Oracle Database 12c. This 20 minute video demonstration walks you through everything you need to know about Oracle Database In-Memory and how it can improve the performance of analytical queries.
Views: 1107 Maria Colgan
TIBCO Spotfire - Import Data Table from a Data Connection
When establishing a data connection, you have the option to keep the data external, in-database, or import each data table for in-memory analysis. Try Spotfire for free today: http://spotfire.tibco.com/trial For more great resources like this head over to our Learning Resources page: http://spotfire.tibco.com/learn Want some help? Head over to the TIBCO Community: http://community.tibco.com/products/spotfire
Views: 11788 TIBCO Spotfire
High Performance Bulk Data Loading
What is the best way to get data into an Oracle database? This session covers how to bulk load data quickly into an Oracle database. It will help developers avoid common gotchas that will limit performance, and it gives insight into how to make sure the solution will be database AND DBA-friendly! Example SQL is used to demonstrate the solution, and links to working examples will be provided.
Oracle Database Tutorial - Oracle Instance Memory Pool - Part I
This video tutorial on Oracle database provides brief details about Oracle Instance memory pool. You can visit Oracle Database related videos here: https://www.youtube.com/watch?v=cDqlT7O8H0Q&list=PLRt-r4QiDOMfMmVU-8145pLcBxIdvAt8f&index=1 Website: http://guru4technoworld.wix.com/technoguru Facebook : https://www.facebook.com/a2zoftech/ Website: www.dronatechnoworld.com
Views: 103 Sandip M
In-Memory OLTP Memory Optimized Table Variables Vs Disk Based Table Variable in SQL Server
Refer to http://www.sqlvideo.com/AllVideos/Memory-Optimized-Table-Variables-Vs-Disk-Based-Table-Variable for additional details. This SQL Server Video includes demos. You have the possibility to practice the hands-on examples while watching the video. SQLTest Tool (http://www.sqltest.org) simulates the hands-on labs for you, no registration necessary.
Views: 3780 SQLWorkshops
Oracle Database In-Memory in Action
Join three of the brightest minds in the industry: Cary Millsap, Kerry Osborne, and Tanel Poder, for a one-hour webinar as they discuss the revolutionary technology of Oracle Database In-Memory, an in-memory column store that does not slow down the OLTP components and is compatible with all existing applications. Try out Red Gate's Deployment Suite for Oracle: http://www.red-gate.com/products/oracle-development/deployment-suite-for-oracle/
Views: 2881 Redgate Videos
SAP UI5 HANA vs Oracle APEX In Memory
Juergen Schuster an independent consultant talks about his decision to train on SAP HANA and UI5, along with his subsequent choice on should he stick with Oracle APEX and the Oracle Database 12c In-Memory option or not, even though it meant leaving money on the table. #LetsWreckThisTogether #ORCLAPEX
Views: 628 Todd Trichler
Oracle Database In-Memory Configuration, Population & Querying - DBIM workshop part2
Underlying Oracle Database In-Memory is a unique in-memory dual format that avoids the trade-offs inherent in single-format databases and enables both superfast analytics and online transaction processing (OLTP). This session explains how the In-Memory column is allocated, when and how data is populated into it, and provides details on the key performance enhancing features that come with it including in-memory data compression, scans, joins aggregations and storage indexes. We will also demonstrate how to monitor and manage the In-Memory column store via new v$ performance views and data dictionary tables.
Oracle Database 12c: Enhanced Optimizer Statistics with Tom Kyte
Tom Kyte discusses enhanced optimizer statistics followed by a demo of on-load statistics gathering in Oracle Database 12c. "Online Statistics Gathering for Bulk Loads" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL344 "Histograms" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL366 "CREATE TABLE ... AS SELECT" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DWHSG8317 "CREATE TABLE" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF01402
Views: 8175 OracleDBVision
MNG7: PL/SQL Runtime Memory Management (PL/SQL Channel)
Explore the different kinds of memory used by Oracle generally and the PL/SQL runtime engine specifically, including the SGA (System Global Area), PGA (Process Global Area) and UGA (User Global Area). The video also offers techniques for analyzing memory consumption by your programs. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Oracle 02 - 오라클 Table Space, User, Process, Memory 구조
서버개발자와 데이터분석가가 알아야 할 오라클 강의 두번째 시간으로 오라클의 테이블스페이스, 유저(스키마), 오라클 프로세스, 오라클의 메모리 구조등에 대한 강의 영상입니다. * Slide: https://docs.google.com/presentation/d/1V5uUu-Ym05sIQ0WS0e0-f2X5V3VFLWkkbsgrNyTl454/edit?usp=sharing
Oracle DB 12c - Table Enhancements
Oracle DB 12c - Table Enhancements Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Configure Memory with EM Express 12c
This video shows you how to configure memory settings for an Oracle Database 12c using EM Express. You view memory settings and then use the SGA Advisor to determine how to improve your memory configuration. Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Difference Between Row Level Storage(Oracle) and Column Level Storage (Vertica)
With changing Needs New technologies are coming in market even the ways to store data is changing, The video gives a very high level overview of the differences btw Columnar and Row Based storage database
Views: 6974 Tech Coach
Oracle Database 12c: Simplifying Effective Date Range Queries with Temporal Validity
Fewer mistakes, less typing - in 12c you can define effective date ranges for your table date columns. Chris Saxon provides a quick demo in this week's episode.
ActivePivot and Oracle: Accelerating In-Memory Computing
Antoine Chambille, Head of Research and Developement, ActiveViam (formerly Quartet FS), presents how Java 9 and the new SPARC processors with Software In Silicon take the ActivePivot In-Memory platform to the next level.
Views: 316 Oracle
Benefits of Common Table Expressions
On this episode of Joes 2 Pros SQL server unlocked series we present a topic for anyone who has ever been exposed to SQL Server, Common Table Expressions. A CTE is memory resident table. You are pulling from that query and giving it a name. This table adds enhancements to the old tables. It allows you to open up to new people without having an increased security risk. This is extremely beneficial for anyone who is exposed to SQL Server as keeping your content safe is a top concern for most organizations. In this video, he will take you through a very real example from a department store quarterly reporting. He wants to do a seasonal reporting from all the departments of a store excluding snow sports and cooking. He shows you how to make the code more simple and reduce human error. Having CTE knowledge will be greatly beneficial to you in your everyday career. Please be sure to follow along our blog series. Stay tuned next week to learn more about Dynamic SQL. To learn more about he benefits of common table expressions view our course Developer 2012 Volume 2 Video 10.1. See more at: http://www.joes2pros.com/joes2pros/courses Full Blog: http://joes2prosblog.social27.com/
Oracle DBA - Database and Instance
http://oracledbazerotopro.com This tutorial explains database and instance.
Views: 76536 HandsonERP
Oracle Database 12c: Improved Defaults
Tom Kyte and Chuck Murray describe several improvements to default behavior in Oracle Database 12c: defaults based on sequences, default on NULL, Identity type columns, and metadata-only defaults. For more information: "CREATE TABLE" statement in Oracle® Database SQL Language Reference http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF01402 "ALTER TABLE" statement in Oracle® Database SQL Language Reference http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF01001 "Identity Columns" in Oracle® Database Migration Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DRDAA109
Views: 2207 OracleDBVision
How to Install Oracle! !! Database Training
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)