Videos uploaded by user “SkillBuilders”
Oracle SQL Tuning - How to Read Execution Plans (Explain Plan)
In this free tutorial you will learn how to generate and read (interpret) an execution plan in Oracle Databases. See more FREE Oracle Tuning tutorials at http://skillbuilders.com/free-oracle-tutorials. Understanding what the Oracle Database does with your SQL is essential to tuning - and the execution plan is the key. Oracle Certified Master DBA John Watson will provide a brief introduction (4 minutes) - which includes John's tuning methodology, then demonstrate EXPLAIN PLAN, SQL*Plus AUTOTRACE and DBMS_XPLAN.DISPLAY_CURSOR. In the tutorial, John will teach you: - How to read an execution plan - Find the 1st step in the plan - Decipher the order of the steps in the plan - That EXPLAIN PLAN can be very misleading Prerequisites: To get the most from this tutorial, you should: 1 Know how to code SQL 2 Be familiar with SQL*Plus 3 Know - in very general terms - what an execution plan is. 4 Have a basic understanding of the Library Cache (this is where Oracle Database stores parsed SQL statements) 5 Have a basic understanding of the Cost Based Optimizer (this is the part of the database that parses your SQL, creates an execution plan. Hopefully the correct - most efficient - plan).
Views: 69269 SkillBuilders
How Oracle RAC Cache Fusion Works Part 1 of 6
Learn the mysteries of how Oracle RAC Cache Fusion works. In this lesson you will see the tutorial agenda plus a brief history of Oracle clustering (parallel server) and the problems associated with disk pinging. Cache Fusion is the secret to making Oracle Real Application Clusters (clustering) a scalable database platform. You will learn how cache fusion works, the differences between global cache current and consistent read transfers, the differences between two-way and three-way transfers and the associated wait events. Oracle Ace and author Brian Peasland provides a demonstration of global cache transfers in action by utilizing Oracle Trace. Prerequisites: Knowledge of Oracle Architecture including the concept of an Oracle instance, the buffer cache, how data is moved into the buffer cache and an understanding of wait events. Brian is a certified Oracle ACE who has been in the IT field for over 25 years and has worked as a computer operator, operations analyst, systems administrator, application developer and for more than half of his career as a database administrator. He holds a B.S. in Computer Science and a M.S. in Computer Science, specializing in database systems. Brian has been a member of SearchOracle.com’s Ask The Experts since 2001 and now contributes articles to the site. He regularly contributes to the My Oracle Support and Oracle Technet communities. He can be followed on Twitter on @BPeaslandDBA and maintains a blog at http://www.peasland.net. Brian is the author of “Oracle RAC Performance Tuning” on Rampant TechPress.
Views: 7599 SkillBuilders
How to Convert a Non-Partitioned Table to Partitioned using Oracle Database 12c R2
Oracle Database 12c Release 2 New Feature! Learn how to convert a non-partitioned table to a partitioned table - Online! This new method - using ALTER TABLE MODIFY - is much simpler than DBMS_REDEFINITION. In this free tutorial from SkillBuilders and Oracle Certified Master DBA John Watson you'll see a demonstration of converting the table and the impact on the underlying table and indexes. See all our free Oracle Database Tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 3980 SkillBuilders
How to use Oracle SQL ROLLUP and CUBE
Learn how the Oracle Database SQL extensions ROLLUP and CUBE provide additional aggregations for your data warehouse data.
Views: 2950 SkillBuilders
Stop Rebuilding Global Indexes! Oracle 12c Global Index Maintenance
Stop rebuilding Global Indexes! Stop worrying about invalidating Global Indexes! Oracle 11g gave us "UPDATE GLOBAL INDEXES". 12c provides a huge improvement: orphaned_entries! In this tutorial, Oracle Certified Master John Watson demonstrates how 11g and 12c handle Global Index maintenance with orphaned entries and overnight maintenance job PMO_DEFERRED_GIDX_MAINT_JOB.
Views: 2796 SkillBuilders
How Oracle RAC Cache Fusion Really Works Part 5 of 6
Oracle ACE Brian Peasland demonstrates 2-Way vs 3-Way Block Transfers including a description of master, holders and requestors.
Views: 1785 SkillBuilders
What is Oracle ACFS - Lesson 1 - Intro to ASM Clustered File System
What is Oracle ASM Clustered File System? In lesson 1, Oracle Certified Master DBA John Watson reveals the somewhat confusing licensing history of ACFS and why Oracle uses it as the default file system for Oracle Database Appliances. Watch all free lessons in this tutorial at The white paper referenced in this video can be found at http://www.oracle.com/technetwork/database/database-appliance/overview/asm-acfs-migration-2379319.pdf Another helpful paper can be found at http://www.oracle.com/technetwork/database/database-technologies/cloud-storage/benefits-of-oracle-acfs-2379064.pdf.
Views: 4023 SkillBuilders
Groovy & Grails Tutorial - Part 1 - What is Groovy
Learn Groovy programming and the Grails platform! Groovy is part of the new generation of dynamic languages for the JVM. Watch the complete 54 minute FREE tutorial at http://skillbuilders.com/Groovy-Free-Tutorials?id=21&w=groovy-grails-free-tutorials. It's not intended to replace Java, but rather to make it easier, more flexible, and more powerful. Groovy is what Java would have been like had it been designed in the 21st Century. Groovy dramatically simplifies Java development, and also brings modern language concepts like builders, closures, and metaprogramming to existing Java systems. The purpose of this free tutorial is to demonstrate both how Groovy makes Java development quicker and easier, and also to show some of Groovy's more advanced features. The capabilities illustrated will include: Groovy beans Optional typing Easy access and processing XML data Unit and functional testing of both Groovy and Java code Simplified file and directory handling Templating Ant builders, Swing builders, and XML builders
Views: 31879 SkillBuilders
How to use the Oracle SQL PIVOT Clause
PIVOT allows you to "flip a table on its side", i.e. Columns to Rows / Rows to Columns. Previously we did this with DECODE or CASE. As of Oracle 11g, Oracle Database includes the PIVOT clause (and UNPIVOT). Oracle expert Geoff Wiland from SkillBuilders will demonstrate PIVOT, UNPIVOT, including the use of aggregate functions.
Views: 11920 SkillBuilders
How Oracle RAC Cache Fusion Works Part 2 of 6
Learn how Oracle RAC Cache Fusion really works. Presenter Brian Peasland demonstrates, with v$statname, v$sesstat and Oracle trace (dbms_monitor.session_trace_enable) cache fusion in action. Free Scripts used in this tutorial are downloadable here http://skillbuilders.com/How-Oracle-RAC-Cache-Fusion-Works
Views: 3974 SkillBuilders
SQL Tuning How to Tune Joins - Lesson 1
How do you tune SQL Joins? Start with the most important ingredient - the join order! In this free tutorial by Oracle Certified Master DBA John Watson of SkillBuilders.com you will learn what is the best join order and how to get the optimal join order. Watch all Lessons, FREE, at http://skillbuilders.com/tuning-joins-optimal-join-order.
Views: 3509 SkillBuilders
How Oracle RAC Cache Fusion Works Part 3 of 6
Learn How Oracle RAC Cache Fusion Works Really Works. Download Free Scripts at http://skillbuilders.com/How-Oracle-RAC-Cache-Fusion-Works. A continuation of the cache fusion demonstration, with a detailed look at session statistics and the raw trace file contents. You will learn about the "gc" wait events (Global Cache) including 'gc current block 2-way' and 'gc cr multi block request'.
Views: 3332 SkillBuilders
Web Development with Ruby On Rails
The Ruby on Rails framework gives you the tools you need to develop web applications faster. In this webinar, you'll learn about the basic components of the Rails framework and see how to create and test a very simple web application that you can build upon. By the end you'll have an idea of how you can leverage Ruby on Rails in your work. Want to learn more? Check out our online classes! SkillBuilders.com/Ruby Audience: Programmers, Developers, anybody interested in Ruby on Rails. Language: English
Views: 129370 SkillBuilders
SQL Tuning with Oracle Database 12c Histograms
Learn the new 12c options for creating histograms. See all free video tutorials at http://www.skillbuilders.com/free-oracle-tutorials. In this free tutorial, Oracle Certified Master DBA John Watson demonstrates what histograms do (provide correct cardinality), the difference between histogram types (Frequency and Height Balanced). You will also learn the importance of the auto sample size algorithm in 12c and the new "Hybrid" and "Top Frequency" type histograms.
Views: 3989 SkillBuilders
Oracle 12c SQL Tuning - Adaptive Execution Plans
Learn an Oracle Database 12c new performance feature - Adaptive SQL Plans. During execution, Oracle Database can switch the SQL to a new plan. A very powerful corrective measure! But if you don't know about it , how can you possibly tune SQL in Oracle Database 12c? Time to learn 12c!
Views: 5740 SkillBuilders
SQL Tuning for Beginners 2 - Review Challenge
In Part 2, Oracle Certified Master reviews the tuning challenge presented at the end of part 1. John uses Autotrace to demonstrate which query performs the best.
Views: 2934 SkillBuilders
What is Oracle ACFS - Lesson 4 - Format ACFS and Mount the File System
Lesson 4 of 4 - The basics of Oracle ACFS...What is it and how to configure the basics of ASM Clustered File System. Oracle Certified Master John Watson demonstrates....
Views: 1538 SkillBuilders
How Cache Fusion Really Works Part 4 of 6
Cache Fusion is the secret to making Oracle RAC a scalable database platform. This video is a continuation of the analysis of the raw trace file, the Global Cache Wait Event and the difference between Current Blocks and Consistent Read Blocks. See all lessons in this tutorial, Free, at http://skillbuilders.com/How-Oracle-RAC-Cache-Fusion-Works. Created by Brian Peasland, author of "Oracle RAC Performance Tuning" http://amzn.com/0986119415.
Views: 1957 SkillBuilders
What is Oracle Stretched RAC Clusters? aka Geo-Cluster, Extended Distance Cluster
Learn why a "stretched cluster" (also called extended distance clusters) for your Oracle Database can be better than RAC, Data Guard and Streams, and can provide a zero downtime, zero data loss environment. Stretched clusters can even be built on Oracle Standard Edition, saving money on licensing costs. Presented by John Watson, Certified Oracle Master DBA and SkillBuilders.
Views: 5209 SkillBuilders
Oracle SQL Tuning Re-Optimizing Execution Plans with Cardinality Feedback
Cardinality feedback, introduced with Oracle Database 11g, has been significantly enhanced with 12c. Cardinality feedback allows the CBO to learn from a cardinality estimate mistake and re-optimize the execution plan. Learn more in this free SQL Tuning tutorial. See all free Oracle Database tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 3278 SkillBuilders
Four Steps to Oracle SQL Tuning  - A Methodolgy
Learn a predictable and repeatable methodology for tuning Oracle SQL statements. Just four steps that you should always follow when tuning an SQL statement. (Note this video does not contain examples of how to apply the four steps, just what the steps are.) Oracle Certified Master John Watson presents. John concludes with a brief overview of how SkillBuilders SQL tuning course provides the information you need to apply the four steps. Learn more about SkillBuilders SQL Tuning course http://skillbuilders.com/oracle-sql-tuning-training 1. What is Oracle doing? (explain plan, trace) 2. Why is Oracle doing it that way? (analyze the execution plan) 3. Is there a better way? Test! 4. If there's a better way, push the CBO towards the better way.
Views: 15402 SkillBuilders
Oracle Database SQL Tuning with Direct and Indirect Reads
Oracle Database SQL Tuning tutorial. Learn what direct and indirect reads are and what impact they have on tuning SQL in Oracle Database. In this free tutorial from www.SkillBuilders.com, Oracle Master DBA John Watson will explain and demonstrate what direct / indirect reads are, pros and cons, why they can cause instability in the performance of your SQL (unpredictable response time), why stored outlines, SQL plan baselines and hints usually don't help. Perhaps most importantly, John will tell you what you can do about it. Intended Audience: Experience Oracle DBA's, developers and anyone with Oracle SQL tuning experience.
Views: 1734 SkillBuilders
SQL Tuning for Beginners Part 1 - Tuning Methodology and Basic Optimization Concepts
Get started with Oracle SQL Tuning! Designed for developers, DBA's and Analysts who are new to SQL Tuning, this free tutorial introduces a tuning methodology, basic tuning concepts. Part 2 provides a demonstration of explain plan and autotrace for getting an execution plan. Watch Part 2 and 3 - **FREE** - at http://www.skillbuilders.com/oracle-sql-tuning-for-beginners-tutorial. Presented by Dave Anderson and Oracle Certified Master John Watson. Attend 1-day class for beginners, online or on-premise: http://www.skillbuilders.com/oracle-sql-tuning-training-for-beginners
Views: 11028 SkillBuilders
How to Pivot (Flip) Tables with SQL CASE & DECODE
Pivoting tables (columns to rows, rows to columns) is a common data analysis requirement. Learn how to accomplish this with Oracle SQL CASE and DECODE
Views: 2030 SkillBuilders
How to Tune SQL when You Can't Edit the Source Code, Part 1 of 2
Learn Oracle SQL Tuning! How do you add a hint to SQL you can't edit? How do you tune SQL if you don't have access to the source code? Sometimes, Oracle indexes, statistics, stored outlines, profiles or 12c directives will solve a tuning problem. However, as a last resort, you may want to add a hint. In this case DBMS_ADVANCED_REWRITE can be the solution. In this tutorial, Oracle Certified Master DBA John Watson of SkillBuilders demonstrates using DBMS_ADVANCED_REWRITE to change the SQL Oracle executes - without changing the source code!
Views: 1537 SkillBuilders
Mastering Oracle APEX Messages - Lesson 2
In this lesson learn how to create PL/SQL Success messages, dynamic messages and best practices. Visit http://www.skillbuilders.com/how-to-oracle-apex-messages to view all lessons, free.
Views: 3326 SkillBuilders
Introduction to Advanced Ruby Programming Language from SkillBuilders.com/Ruby
Watch the entire FREE tutorial at http://www.SkillBuilders.com/Ruby-Free-Tutorials?id=12&w=web-development-with-ruby-on-rails. "Introduction to Ruby" talks aren't that exciting. Every language has strings, arrays, conditionals, and evaluation, and by now, everyone's sick of "build a CRUD app in 15 minutes" demos. Every language has its own special qualities that set it apart, and this talk focuses what makes the Ruby programming language different and special. We'll cover seven advanced language features and techniques, and we'll demonstrate how we use those to solve everyday problems. We'll talk about message passing, extending core language features, lambdas, and we'll even write a little code that writes code. If you've looked at Ruby and thought "What's the point?" then this talk is for you. Your instructor, Brian P. Hogan is an author, editor, trainer, and web developer who's been building web sites professionally since 1995.
Views: 12035 SkillBuilders
Introduction to Oracle APEX 5 - Module 1 - What is APEX
Get started on your way to being an APEX Developer! In this excerpt from SKillBuilders Introduction to Oracle APEX class, Oracle Certified APEX Expert provides a basic foundation, i.e. answers the question, what is APEX! See all modules in this tutorial, free at http://www.skillbuilders.com/Introduction-to-Oracle-APEX-5-Tutorial
Views: 3328 SkillBuilders
Introduction to Oracle Application Express (APEX)
Oracle Application Express (APEX) is an easy to use platform for developing data-centric web based applications. Although it has been around for years, many people have yet to really discover and utilize its unique strengths. Those new to Apex often have many questions including: What can Apex do for me or my organization? What features are available "out of the box" and can I extend the product if needed? Is is secure and can it scale? This session will answer these questions, and many more, via a high level product overview which will include a live demo.
Views: 33796 SkillBuilders
What is Oracle Exadata Smart Scan (Demonstration)
How does Oracle Exadata Smart Scan work? What is Smart Scan. How to insure Oracle is offloading work to the Storage Tier? Learn this and more in this demonstration by OC Master John Watson of SkillBuilders. See all 11 lessons in this tutorial at http://skillbuilders.com/exadata-tutorials. John Watson: I want to show you very briefly how offload Smart Scan or flow processing can actually function. I'm working here just in the little demonstration Scott schema. I'll enable auto tracing so that we can see the effect on execution plans, which will also show me whether offload processing is indeed possible. So it's a simple query. I'll use a function here to check that to get offloaded as well as the column selection and the row selection and column projection. We'll have a predicate. Right. So there is the statement. It returned these three scalar values, as you would expect. How was this actually executed? There was a select statement, then it was executed, table access full. That's the only way to run that statement given the index on that table because in the middle of this, we see the key word, "storage." That key word tells me that this statement could indeed be offloaded to the storage tier. Furthermore, we see down here in the predicate information, "storage." That key word again tells me that the row filtering could have been done by the storage tier. So what happened is that the storage tier did not return every block of the empty* table to the database buffer cache, where my session would then have had to extract these values. All it returned to the instance was these three scalar values directly into the PGA of my server process. Now, there's also the initcap function there. Was that offloadable or not? There is a view "Read our SQL fm letter data," and that will tell us for each function whether or not it can be offloaded. So, just select its name, whether it's offloadable. Declare offloadable as yes and put in a sort order as well, and we see that in the current release, there are 393 functions that can be offloaded. Which ones? All the typecasting functions, truncations, trims. These are functions that get executed millions of times an hour in many, many environments. Note here two particularly important ones, balloon filters. The offload capability for balloon filters allows us to offload joins or facts to dimension tables. Those two in star schemas can be offloaded. The function I used was, in fact, initcap. Just for completeness, we'll scroll through all of these and we'll see that initcap itself is an offloadable function, and there it is along with many others. There are two classes of function that cannot be offloaded, and those are the aggregation functions and the analytic functions. I mention them just for completeness. There's an architectural issue there because aggregations and analytics potentially require access to all rows in the table. The row might be distributed across a cell. So it's a technical issue why they can't be offloaded, but virtually, all other functions can be offloaded with terrific drops in CPU usage, and combining that with the reduction of data traffic into the instances will give us vast performance improvements.
Views: 4088 SkillBuilders
Oracle SQL Tuning - Explain Plan Lies?
Do you use EXPLAIN PLAN to tune Oracle SQL? Does it always "tell the truth", or does it "lie". (Maybe it's not the whole truth!) In this free tutorial from SkillBuilders' Oracle Certified Master John Watson, you will learn why the execution plan generated by EXPLAIN PLAN can be misleading and what to do about it. After a brief lecture, John demonstrates exactly why. You'll hear about dynamic sampling, adaptive cursor sharing (11g), adaptive execution plans (12c) and of course, bind variables. John demonstrates how bind variables cause misleading execution plans using dbms_xplan.display and dbms_xplan.display_cursor. To get the most from this tutorial, you should have some understanding of hard parse, soft parse, cardinality, histograms. See all SkillBuilders FREE Oracle Database tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 3658 SkillBuilders
Oracle Exadata: Hybrid Columnar Compression (HCC) Introduction
Oracle Exadata Hybrid Columnar Compression Introduction Why is it so powerful? Well, in comparison to Oracle's previous compression options, hybrid columnar compression really does compress. Everything Oracle issued previously didn't compress at all. It did deduplication...Experience shows that virtually all data will be compressed by at least five or six times.
Views: 4025 SkillBuilders
Get Started with Oracle APEX - Architecture
What are the components in an APEX application (e.g. browser, HTTP listener, APEX listener, database) and what is a workspace.
Views: 1166 SkillBuilders
How to Customize Calendars in Oracle APEX 5 Lesson 1 of 3
Watch Oracle Certified Expert Tyson Jouglet demonstrate how to customize calendars in APEX 5 in this free tutorial from SkillBuilders.com. Tyson’s focus in this presentation is how to control the aesthetics of your calendar to provide helpful visual queues for your calendar users. Tyson will be using the new calendar region in APEX 5 for this tutorial. See all 3 lessons, free, at http://skillbuilders.com/how-to-customize-calendars-apex-5.
Views: 11651 SkillBuilders
How to Get Secure Web Services (SSL/HTTPS) and Oracle APEX Working - 4 of 4
After you've created the Access Control List (ACL) and added the digital certificates, test your secure web services call. To watch all 4 FREE lessons visit http://www.skillbuilders.com/how-to-get-oracle-apex-ssl-web-services-working.
Views: 1842 SkillBuilders
Oracle Database 12c Security - Oracle Virtual Private Database (VPD)
Learn how to use Oracle Virtual Private Database (VPD) to secure your data. See all lessons at http://skillbuilders.com/12c-TSDP-Tutorial First, Virtual Private Database. What is it? Answer: It's a declarative technique for enforcing security. Typically, it's based on user application context. That was the first limitation of 8i. Backed with 8i context were session-specific. The context variables were sort in the PGA. That means you simply couldn't use this in a web environment. However, global context, with use of 9i, Virtual Private Database became usable for web applications with connection pooling. But whether you're using it to client server or on a three tier environment, it's declarative technique rather than a programmatic technique. I can go behind the back of the application as a DBA and generate predicates to get appended to all SQLs. Select, insert, update, delete the end users. Issue the SQL and I will generate a predicate that filters the access. It's impossible to bypass. All users will have predicates appended to all their code. It doesn't matter whether they're using SQL Plus, Discoverer, Business Objects, Crystal Reports, eBusiness Suites, whatever they're using, I as DBA can filter their access to roles. The end result, different users see different data sets while running the same code and accessing the same tables, hence, the name Virtual Private Database. Different users will think they're seeing a totally different set of tables, but in fact it's one column database, one set of tables hosting a single application shared by all the users. The mechanism - you can apply VPD to tables, to views, to synonyms, and a declarative technique. Once the technique you write a function that generates the predicate, you associate the function with the table. From then on whenever the user issue SQL against that table the Cost-Based Optimizer rewrites the code. The Cost-Based Optimizer rewrites the user SQL to call the function to generate the predicate. The predicate is then appended to the SQL and it's the modified SQL that is parsed and executed. Let's see how this actually works. I'm working here by the way. This is just a perfectly normal 12.1 database. But what I'm going to demonstrate at this point will in fact work on 11g as well. I'm not going to be using any of the 12c enhancements to VPD for this little demonstration. I'll work in the scott schema. What do we have to do? We write a function to generate the predicate string. Create function. And I'll my function vpdf. The function must conform to a fixed specification. It must take two varchar arguments. One of the arguments is intended to be the schema to which the function will be applied. The other argument is the object within the schema to which the function will be applied. And it must return a varchar2, which is the generated predicate. Let's begin. Within this function you can do just about anything. There are some limitations. It's impossible for the function to query or update the table against which the VPD calls here is going to be applied or we violate the rules of purity that we come across so often with PL/SQL. But apart from that, it can do just about anything - including a number of dreadful side effects can be introduced by writing VPD functions. I'm going to do a very simple one on this one. I'll shall simple return immediately a predicate. What predicate? Ename, which is the ename column from this scott.emp table. Ename should equal sys_context. I'll go to the local context, my user end context, and just extract session user. We can see that John has tested this earlier today and therefore the object already was suggesting and he's just dropping it now and cleaning up the recreate. I hope you realize these really are live demonstrations. I'm not just running scripts. I've created a function. What's that function going to do? It's going to return this value here. Test it. Always test it and see what it's actually going to do. I'll select vpdf. I have to give it a couple of arguments. This one will do for now.
Views: 4770 SkillBuilders
Dynamic Actions In Oracle APEX 4 0
Learn Dynamic Actions in APEX! Watch all our Free Video Tutorials at http://www.SkillBuilders.com/oracle-apex-tutorials Introduced with APEX 4.0, Dynamic Actions have successfully created a declarative interface around the complex event model used by modern browsers. Does this mean that knowledge of JavaScript been rendered useless? In short, no. This session will explore the declarative side of Dynamic Actions to find out exactly what is possible and what is not, but most importantly, it will demonstrate what one would need to know to bridge the gap. Presented by SkillBuilders.
Views: 9166 SkillBuilders
SQL Tuning with Histograms Demonstration Part 3 of 4
Learn how to use Oracle Histograms! Histograms are essential ingredient of Tuning SQL in the Oracle Database. In this part of the tutorial, SkillBuilders' Oracle Certified Master John Watson describes the importance of histograms. Histograms collect essential statistics such as data skew and thus accurately predict how many rows a predicate will select. This impacts critical decisions such as join order, join method and access method. See all free Oracle Database tutorials from SkillBuilders at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 1183 SkillBuilders
How to Get Secure Web Services (SSL/HTTPS) and Oracle APEX Working - 3 of 4
Learn how to get Oracle APEX / Oracle Database to recognize and accept vetted digital certificates. (Part of getting APEX / Oracle Database to work with secure web services (SSL/HTTPS)). To watch all 4 FREE lessons visit http://www.skillbuilders.com/how-to-get-oracle-apex-ssl-web-services-working.
Views: 3282 SkillBuilders
Mastering Oracle APEX Messages - Lesson 6
Learn how to include JavaScript client-side messaging and message theme hooks in Oracle APEX applications. See http://www.skillbuilders.com/how-to-oracle-apex-messages to view all lessons, 100% free.
Views: 1701 SkillBuilders
How to Build Transparent Data Encryption on Oracle Standard Edition
View all our FREE database tutorials at http://skillbuilders.com/free-oracle-tutorials. Oracle Transparent Data Encryption (TDE) is a fantastic built-in security feature with Oracle Database Enterprise Edition. However, in this free tutorial, Oracle Master DBA John Watson will demonstrate a technique for building your own transparent data encryption - on Standard Edition!
Views: 6356 SkillBuilders
12c SQL Performance Features - Baselining in 12c
Learn how to use SQL Plan Management in Oracle Database 12c to prevent SQL performance regression! All free lessons at http://www.skillbuilders.com/free-12c-performance-features-training-2
Views: 1001 SkillBuilders
Oracle SQL Tuning - How to Read Execution Plan Part 1
Learn how to tune SQL. If you're going to tune Oracle SQL statements, you will need to learn how to read an execution plan! See all Free lessons in this tutorial at http://www.skillbuilders.com/sql-tuning-for-beginners-free-tutorial .
Views: 2617 SkillBuilders
Oracle Application Express (APEX) Course Introduction
What's covered in SkillBuilders Oracle APEX course. Free from SkillBuilders.com/APEX.
Views: 22839 SkillBuilders
Oracle SQL Tuning - Equal SQL is not Always Equal
Learn how and why equivalent SQL statements can have a dramatic effect on performance. Certified Master J Watson demonstrates...See all our free Oracle Database tutorials at http://skillbuilders.com/free-oracle-tutorials. The Oracle Database cost-based optimizer (CBO) should recognize equivalent SQL statements and re-write them into the most efficient form. Well, nothing is perfect - not even Oracle Database. Sometimes the way you write your SQL can have a dramatic effect on performance. Presented by John Watson, Oracle Certified Master DBA. Some experience with SQL tuning is expected.
Views: 2070 SkillBuilders
Groovy for Java Developers
See all our Free Groovy tutorials at http://skillbuilders.com/groovy-grails-tutorials. Learn what the Groovy programming language is. Groovy is part of the new generation of dynamic languages for the JVM. It's not intended to replace Java, but rather to make it easier, more flexible, and more powerful. Groovy is what Java would have been like had it been designed in the 21st Century. Groovy dramatically simplifies Java development, and also brings modern language concepts like builders, closures, and metaprogramming to existing Java systems. The purpose of this session is to demonstrate both how Groovy makes Java development quicker and easier, and also to show some of Groovy's more advanced features. The capabilities illustrated will include: Groovy beans Optional typing Easy access and processing XML data Unit and functional testing of both Groovy and Java code Simplified file and directory handling Templating Ant builders, Swing builders, and XML builders From SkillBuilders.com/Groovy
Views: 24490 SkillBuilders
What is Oracle ACFS - Lesson 5 - Replication with Oracle ACFS
Oracle ASM Clustered File system is the next generation file system from Oracle Corp. Besides clustering, it supports replication. In this free tutorial from SkillBuilders and Oracle Certified Master John Watson, John will demonstrate how to configure (and test) ACFS replication. See all 7 lessons in this tutorial, free, at http://www.skillbuilders.com/what-is-oracle-acfs.
Views: 1465 SkillBuilders
Advanced SQL SubQueries in Oracle Database
Learn to code advanced correlated SQL subqueries in the Oracle Database. From SkillBuilders.com/Oracle.
Views: 9434 SkillBuilders
Oracle SQL Tuning - Equal SQL, Part 2 of 5 by John Watson, SkillBuilders.com
Watch Oracle Master John Watson demonstrate why not all equivalent SQL statements are created equal. John demonstrates how SQL statements that produce equivalent result sets can have radically different response times, why this happens and common solutions. All five new video tutorials are available at SkillBuilders.com/Oracle-Tutorials 1. Introduction including the First Demonstration 2. SubQuery Factoring 3. Star Transformations 4. Aggregations 5. Summary Some experience analyzing Oracle execution plans is required to get the most from this tutorial.
Views: 6509 SkillBuilders
How to code PL/SQL BULK Collect by Steven Feuerstein
See all free Oracle tutorials at http://www.skillbuilders.com/oracle-tutorials. In this tutorial, Oracle ACE Director Steven Feuerstein sets the agenda AND introduces 4 techniques for improving the performance of your PL/SQL code.
Views: 2611 SkillBuilders