Home
Search results “Oracle set process parameter”
Why are Kernel parameters critical for Oracle Database
 
16:53
Learn more about Kernel parameters with a case study. It's awesome to see how SHMMAX parameter effects a process on UNIX. Liked it? Subscribe to our channel now !!! Look at the complete blog at www.orskl.com Need training on Oracle DBA? WhatsApp to +919951696808 Training content is at www.orskl.com
Views: 5334 OrSkl Academy
Oracle 11g initialization parameter.mp4
 
36:16
Oracle 11g initialization parameter
Views: 3976 Uday Shankar
Oracle DB 12c - Instance Parameter Change Impact
 
09:41
Oracle DB 12c - Instance Parameter Change Impact Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Change Oracle Parameters   SPFILE
 
02:33
TADM51 - SAP Netweaver as DB Operations - Change Oracle Parameter - Create the SPFILE
Views: 1292 Mohamed Iliyas
Oracle Apps Picking and Shipping end to end scenario
 
47:09
Welcome to Oracle EBS Supply Chain Management Training Channel -------------------------------------------------------------- This channel is dedicated to Oracle EBS R12 Supply Chain Management Training through real life case study. There are over 100 cases of supply chain is discussed and demonstrated through EBS setups and transactions. This is one channel that a beginer and intermediate level person can always like to have as a ready recknor. I have over 4000 subscriber in two of my channel What you will learn ------------------- You get access to following modules of Oracle EBS Supply Chain family. ---------------------------------------------------------------------- Oracle EBS WMS and MSCA Oracle EBS Order Management (R12) Oracle EBS Advance Pricing Oracle EBS Shipping Oracle EBS Inventory Oracle EBS Purchasing Learn To: ------------ Describe and process inbound logistics tasks. Describe warehousing features. Describe and process outbound logistics tasks. Set up and define rules using the rules engine framework. Set up Oracle Order Management Manage exceptions and holds Use key Sales order flows (Quote to Order, Blanket agreement to Order and other 10 such flows) Set up Shipping Execution and basic Pricing functionality Setup configure to order (BOM,Routing, WIP etc.) end to end flow (Model BOM,Option class and options, Option specific routing) Setup basic pricing and integrate with order management. Setting up Shipping Setting up Advance Pricing Setting up Purchasing application and many more...(There are 700 plus videos are available in this channel Benefits to You ---------------- This will allow you to explore all the ares of supply chain management (list of modules listed above). There are playlist so that you can see the grouping of sessions. Excuse me if some of the videos are not captured but you will always find similar videos. This channel has over 700 videos to cover the breadth of the subjects. Most of the sessions are recorded during the live training session. Required Pre-requisite ---------------------- Basic knowledge of Supply chain management concepts and inventory management What is the target audience? ----------------------------- End User of Oracle EBS Supply Chain Management Implementer of Oracle EBS Supply Chain Management Support Staff of Oracle EBS Supply Chain Management Anyone who is enthusiasts to explore career in Oracle WMS Apology as some of the video will require you to increase the computer volume as the sound is little low
Views: 24178 Oracle Apps
Setting kernel parameters in oracle
 
05:18
Linux kernel settings for oracle For more information please visit https://www.koenig-solutions.com/oracle-training-certification-courses.aspx
Views: 283 Koenig Solutions
Shared Server Configuration in Oracle Database - DBArch Video 18
 
08:06
You will learn about the concept of Shared Servers and Dispatchers in an Oracle Database. This is a method of optimizing resources on the Database Server side when a user is connecting from a Thick Client ( application installed on a desktop). 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: 9389 Ramkumar Swaminathan
Oracle - Understanding the tnsnames.ora and listener.ora files
 
12:46
Oracle - Understanding the tnsnames.ora and listener.ora files
Views: 196083 Chris Ostrowski
Parameters for Archiving in an Oracle database - Backup&Reco Video 7
 
09:39
In this video you will learn about the various parameters available to configure archiving of redo log files 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: 4909 Ramkumar Swaminathan
Oracle Database11g tutorials 9 || What is archive log mode and how to enable archive log mode
 
07:23
weblink: www.rebellionrider.com What is archive log mode What is noarchive log mode How to enable archivelog mode in oracle 11g How to enable archivelog mode in oracle 10g This SQL tutorial and Oracle database 11g tutorial for beginners will show what are ARCHIVELOG mode and noarchive log mode and how to enable archivelog mode in oracle database 11g or 10g Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Views: 99630 Manish Sharma
Overview of Parameter files and Manager process in Oracle GoldenGate - GG Video 13
 
03:02
In this video you will understand what is the Manager process and what are the different parameter files in Oracle GoldenGate. 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: 2784 Ramkumar Swaminathan
Report Registration With Parameters in Oracle Applications (11i/R12)
 
01:32:02
This tutorial Explains you "How to Register a Report in Oracle Applications Without Parameters in 11i/R12. Here, We used Developer 2000 to Develop the Report and then we register the .rdf file in Oracle Applications With Parameters which includes Number and Date formats. The Output Will be generated based on the Input Parameters.
Views: 16725 yugandar chandragiri
System Change Number in Oracle Database - SCN - DBArch Video 26
 
02:45
In this video you will understand what is System Change Number in an Oracle Database, and get to know about some of the uses of it. . 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: 6231 Ramkumar Swaminathan
Oracle Database tutorials 1: How to install Oracle Database 11g on windows 7
 
08:54
How To install Oracle Database 11g enterprise edition On windows 7 64 bit. Full installation in Single video. Enjoy SQL and Oracle Database Download Oracle Database 11g from here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Related Tutorial ► Tut 16 How To Uninstall Oracle 11g http://youtu.be/pk-E-QxWe38 ► Tut 25 How To Install Oracle 11g XE r2 http://youtu.be/-13SbeDavwk ► Oracle 12c Tut 1 How To Install Oracle 12c http://youtu.be/T-rCbe1MMG4 ►Oracle 12c Tut 5 How To Uninstall Oracle 12c http://youtu.be/lyN9aJfMlzQ ------------------------------------------------------------------------- ►►►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 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at [email protected] You can help me in getting a good job by connecting with me on my LinkedIn and Endorsing my Skills. 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: 1459253 Manish Sharma
How to enable idle_time parameter for user profiles on Oracle
 
03:01
Typically, malicious users target the inactive sessions to gain access into the database. By reducing the period of time an inactive session stays connected, the probability of that session being a victim of abuse is reduced. Also, setting up idle_time helps to reduce problems of having too many INACTIVE sessions.
Views: 1108 checklist20
قواعد البيانات 7 (Oracle Parameter Files (Oracle DBA 11g Tutorial
 
20:19
Oracle DBA 11g Tutorial parameter files (pfile) (init.ora) server parameter file (spfile) Parameter Values difference between spfile and pfile
Views: 295 Ahmed Ybat
Oracle Database Startup Issues Memory Target Parameter
 
06:44
NewayITSolutions: Oracle Database Startup Issues: Memory Target cannot be used. Learn how easy it is to make $100k and above by becoming an Oracle Database Administrator. Website: https://newayitsolutions.com Subscribe: https://newayitsolutions.com/page Enroll: https://newayitsolutions.com/enroll Youtube: newayitsolutions ------------------------------------------------------------------------------------------------------------------------------------------------------------- Follow on Facebook: https://www.facebook.com/newayitsolutions/ Follow on Twitter: https://twitter.com/Theoracledbaguy Follow on Instagram: https://www.instagram.com/oracledbatrainer/ Financing Available: https://newayitsolutions.com/loan-application School Locations: Atlanta, Maryland, Virginia ------------------------------------------------------------------------------------------------------------------------------------------------------------- Office Contact: 1-866-569-0205 Mobile Contact: 240-244-9935
Views: 3395 NewayITSolutions LLC
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: 3410 OrSkl Academy
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: 22944 Ramkumar Swaminathan
Oracle Architecture in less than 10 minutes
 
09:46
CAPTIONS AVAILABLE - I assume that it's the "I like!" votes that keep this video at or near the top when you search on "oracle". Thank you to all. S. Faroult View on www.konagora.com where Youtube is blocked. Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. A pretty reckless description of what happens when you start Oracle and when you execute a statement. If you're a developer, it could influence how you code. If you're a junior DBA, or would be junior DBA, I hope it will help you make sense of some parts of the "Concepts" manual.
Views: 537696 roughsealtd
Oracle GoldenGate Processes Overview - GG Video 6
 
04:13
This video gives you an overview of the processes ( Extract, Pump and Replicat) used by GoldenGate to replicate data between databases. 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: 10471 Ramkumar Swaminathan
How to Oracle 11gR2 Installation On RHEL-5
 
04:47
ORACLE INSTALLATION FOR RHEL 5:- Set KERNAL PARAMETER:- vi /etc/sysctl.conf kernel.shmmni = 4096 semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default=4194304 net.core.wmem_default=262144 net.core.rmem_max = 16777216 net.core.wmem_max = 16777216 net.ipv4.ipfrag_high_thresh=524288 net.ipv4.ipfrag_low_thresh=393216 net.ipv4.tcp_rmem=4096 524288 16777216 net.ipv4.tcp_wmem=4096 524288 16777216 net.ipv4.tcp_timestamps=0 net.ipv4.tcp_sack=0 net.ipv4.tcp_window_scaling=1 net.core.optmem_max=524287 net.core.netdev_max_backlog=2500 sunrpc.tcp_slot_table_entries=128 sunrpc.udp_slot_table_entries=128 net.ipv4.tcp_mem=16384 16384 16384 fs.aio-max-nr =1048576 fs.file-max=6815744 fs.suid_dumpable =1 kernel.shmmax =536870912 Refreshing Kernal Parameter:- /sbin/sysctl -p SECURITY LIMITS SETTING:- vi /etc/security/limits.conf * soft nproc 2047 * hard nproc 16384 * soft nofile 4096 * hard nofile 65536 * soft stack 10240 PACKAGE INSTALLATION:- rpm -Uvih binutils-2*`uname -p`* rpm -Uvih compat-libstdc++-33*`uname -p`* rpm -Uvih compat-libstdc++-33*i386* rpm -Uvih elfutils-libelf-0*`uname -p`* rpm -Uvih elfutils-libelf-devel-0*`uname -p`* rpm -Uvih gcc-4*`uname -p`* rpm -Uvih gcc-c++-4*`uname -p`* rpm -Uvih glibc-2*`uname -p`* rpm -Uvih glibc-2*i686* rpm -Uvih glibc-common-2*`uname -p`* rpm -Uvih glibc-devel-2*`uname -p`* rpm -Uvih glibc-devel-2*i386* rpm -Uvih glibc-headers-2*`uname -p`* rpm -Uvih ksh-20*`uname -p`* rpm -Uvih libaio-0*`uname -p`* rpm -Uvih libaio-0*i386* rpm -Uvih libaio-devel-0*`uname -p`* rpm -Uvih libaio-devel-0*i386* rpm -Uvih libgcc-4*`uname -p`* rpm -Uvih libgcc-4*i386* rpm -Uvih libstdc++-4*`uname -p`* rpm -Uvih libstdc++-4*i386* rpm -Uvih libstdc++-devel-4*`uname -p`* rpm -Uvih make-3*`uname -p`* rpm -Uvih numactl-devel-0*`uname -p`* rpm -Uvih sysstat-7*`uname -p`* rpm -Uvih unixODBC-2*`uname -p`* rpm -Uvih unixODBC-2*i386* rpm -Uvih unixODBC-devel-2*`uname -p`* rpm -Uvih unixODBC-devel-2*i386* rpm -Uvh binutils-2.* rpm -Uvh elfutils-libelf-0.* rpm -Uvh glibc-2.* rpm -Uvh glibc-common-2.* rpm -Uvh libaio-0.* rpm -Uvh libgcc-4.* rpm -Uvh libstdc++-4.* rpm -Uvh make-3.* rpm -Uvh compat-libstdc++-33* rpm -Uvh elfutils-libelf-devel-* rpm -Uvh glibc-headers* rpm -Uvh glibc-devel-2.* rpm -Uvh libgomp* rpm -Uvh gcc-4.* rpm -Uvh gcc-c++-4.* rpm -Uvh libaio-devel-0.* rpm -Uvh libstdc++-devel-4.* rpm -Uvh unixODBC-2.* rpm -Uvh unixODBC-devel-2.* rpm -Uvh sysstat-7.* Users Set up:- groupadd oinstall groupadd dba groupadd oper groupadd asmadmin useradd -g oinstall -G dba,oper,asmadmin oracle passwd oracle Directories Set Up:- mkdir -p /u01/app/oracle/product/11.2.0.4/db_1/-------------oracle home mkdir -p /u01/app/oracle---------------------------------------------oracle base mkdir -p /u01/app/oraInventory---------------global inventory chown -R oracle:oinstall /u01 chmod -R 775 /u01 For Copying Oracle DB software In Oracle User:- mkdir /u01/software cp -r /run/media/root /* /u01/software/ [[email protected] software]$ ./runInstaller
Views: 248 ALOK SRIVASTAVA
PL/SQL tutorial 41: How To Create PL/SQL Stored Procedure Without Parameters in Oracle Database
 
06:30
RebellionRider.com present you the PL/SQL Tutorial 41 on How To Create PL/SQL Stored Procedure Without Parameters in Oracle Database By Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/create-procedure-1 Previous Tutorial ► PL/SQL Blocks: https://youtu.be/rbarR4_gaH8 ► Introduction To Stored Procedures: https://youtu.be/buaSuEMi4lw ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the "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: 45656 Manish Sharma
Payables | Setting Up and Making Check Payments
 
07:09
This video tutorial applies to Rel 11 through Rel 13. It shows you how to set up and make check payments.
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 290034 Chandra Shekhar Reddy
Oracle Enterprise Manager: Metric Extensions
 
19:49
Metric extensions provide you with the ability to extend Oracle's monitoring capabilities to monitor conditions specific to your IT environment. This provides you with a comprehensive view of your environment. Furthermore, metric extensions allow you to simplify your IT organization's operational processes by leveraging Enterprise Manager as the single central monitoring tool for your entire datacenter instead of relying on other monitoring tools to provide this supplementary monitoring. See Enterprise manager online documentation for more information: http://docs.oracle.com/cd/E73210_01/EMADM/GUID-4FCB90EC-5335-4F92-BFA7-CB1442000353.htm#EMADM10032 ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2016 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.
INV Defining Shortage Parameters, Oracle Applications Training
 
03:32
This video shows the process for establishing shortage parameters in Oracle Applications.
Views: 2390 Larry Sherrod
01.22_Oracle_10gR2_RACDG_1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home(2012_01_12).flv
 
11:32
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 628 Yongcheng Lai
SCPT 5 : Parameter Files in Database
 
20:45
Parameter file. You may want to tune various instance parameters for memory usage, etc., to do this you will have to change Oracle's initialization parameter file. Oracle offers two types of parameter files - INIT.ORA and SPFILE.
Real Time SQL Monitorin Demo in Oracle SQL Developer
 
03:42
See how to watch a query execute in real time using this Oracle Database Tuning Pack feature in Oracle SQL Developer.
Views: 27794 Jeff Smith
Step by Step guide to build data guard in Oracle 11g |Physical standby database Data guard |
 
01:18:25
Step by Step guide to build data guard in Oracle 11g
Views: 114026 Wysheid Wysheid
Passing Parameters to a Page in Visual Builder Cloud Service
 
03:33
How to pass parameters to a VBCS page on the URL address
02.20_Oracle_10gR2_RACDG_2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home(2012_01_13).flv
 
10:46
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 1223 Yongcheng Lai
How to recover controlfile through trace file in ORACLE 11g in HIndi
 
11:53
In this video i'm showing you how to recover controlfile through trace file, without helpt of any backup.
Views: 8712 OCP Technology
Changing Oracle BPM Human Task Parameters
 
12:35
This is an extract from lesson 2 in AVIO's self-paced on-demand Oracle BPM Developer Workshop (A-211v), and it describes how to change human task parameters after the human task has already been created. It also shows the trick on how to update the ADF Data Control for the human task.
Views: 2956 Dan Atwood
02.29_Oracle_10gR2_RACDG_2.29 Configuring the Initialization Parameters(2012_01_13).flv
 
04:45
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 212 Yongcheng Lai
Cross-Product Features | Submitting a Scheduled Process
 
02:00
This video tutorial applies to Rel 11 through Rel 13. It shows you how to submit a scheduled process and view the output.
Oracle SQL Tutorial : pl sql create job in Oracle Scheduler
 
08:09
Oracle SQL Tutorial Job In Oracle : How to Create and Run Job in Oracle Scheduler This video will show you how to Scheduling Jobs with Oracle Scheduler. pl sql create job dbms job scheduler example DBMS_SCHEDULER ---------------------- A job object (job) is a collection of metadata that describes a user-defined task that is scheduled to run one or more times. It is a combination of what needs to be executed (the action) and when (the schedule). CREATE OR REPLACE PROCEDURE myproc AS BEGIN INSERT INTO MYTEST(CREATED_ON) VALUES (sysdate); commit; END myproc; / BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name = ‘My_job’, job_type = ‘STORED_PROCEDURE’, job_action = ‘MYPROC’, start_date = ’07-AUG-16 07.00.00 PM’, repeat_interval = ‘FREQ=SECONDLY;INTERVAL=5', end_date =’20-NOV-18 07.00.00 PM’, auto_drop = FALSE, comments = ‘My new job’); END; / EXEC DBMS_SCHEDULER.ENABLE(‘My_job’); Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond oracle job scheduler
Views: 20314 Tech Query Pond
Migrating Database to Amazon RDS
 
13:06
Amazon RDS is a mature Database as a Service offering from AWS. This screencast will cover the setup and configuration of a MySQL database and how to import data.
Views: 69611 Janakiram MSV
Change Undo Tablespace in Oracle
 
05:17
Si te gusto dale me gusta y suscribete !!
Views: 160 FULL-ORACLE
02.21_Oracle_10gR2_RACDG_2.21 Create TNS Listener Process(2012_01_13).flv
 
02:08
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 337 Yongcheng Lai
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)
Oracle DBA Lite: an introduction to Oracle administration, part 2
 
14:36
CAPTIONS AVAILABLE - Second installment in a series of videos to turn Oracle DBA wannabes into (with a little practice) decent junior DBAs. It's based on the (free) Oracle Express edition but everything that is shown applies to other Oracle editions as well.
Views: 13407 roughsealtd
01.31_Oracle_10gR2_RACDG_1.31 Configuring the Initialization Parameters(2012_01_13).flv
 
04:36
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 108 Yongcheng Lai
Video Session #8 Cashing Out & Process Improvement
 
09:15
Effective Business Processes will increase the value of any company - immediately through increased profits, and potentially by securing higher earnings multiples than industry average. A company with effective processes will be more desirable in the market. This session discusses an approach to prioritizing & improving the processes themselves.
Views: 38 CFO Insight LLC
Oracle DataBase Administration ( DBA ) Online Training @ www.virtualnuggets.com
 
31:18
Company Website: http://www.virtualnuggets.com/ Course URL : http://www.virtualnuggets.com/best-oracle-database-administrator--dba--online-training-institute.html Contact Us : http://www.virtualnuggets.com/contact-us.html Oracle DBA Registration Types: Instructor-Led Regular Online (Limited Persons Per Group) Training Instructor-Led Online On Demand Training ( 1-1 or Corporate Training ) What is Oracle DBA? The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system. DataBase is managed by a system or instance in a relational way by database administrators and their responsibility is to install it , upgrade it and maintain it (proactively make sure its performing as expected and not giving any errors or not giving slow performance and monitor those parameters and take time to correct in-case of any issues) and involved in development and design stage of a particular project where database data is involved, implement the solution which is being approved by various teams, constantly monitors the performance and health of the database management system. Benefits Of Oracle DBA Training at VirtualNuggets™ Scenario Oriented Training Materials and Certification Guidance Access For Hands-On Customized Course Agenda For Oracle DBA Live-Support During Sessions Hours Why Attend VirtualNuggets™ Training ? 100 % Quality Assurance,Class is taught By Certified Working Professional The class is taught by an experienced Oracle Database administrator who will teach you the essentials you need to know to kick-start your DBA career. Our training make you more productive with your Oracle DBA assignments. Our teaching style is entirely hands-on. You'll have access to our desktop screen and will be actively conducting hands-on labs on your desktop. Learning is a continual process. To reinforce the concepts covered in class , alumni will also support through discussion forums.
Views: 54876 Virtual Nuggets
Java JDBC Tutorial - Part 6.1: Calling MySQL Stored Procedures with Java
 
06:18
NEED TO LEARN JAVA - 5 FREE JAVA VIDEO COURSES - CLICK HERE - https://goo.gl/7i95F8 --- View more videos on my "Java JDBC Tutorial" Playlist: http://goo.gl/crT4nS Download Java Source Code: http://www.luv2code.com/?p=1012 Closed-Captioning and English subtitles available. Please SUBSCRIBE to this channel: http://goo.gl/EV6Kwv --- In this video we will learn how to call MySQL Stored Procedures with Java. ---- Follow luv2code: Website: http://www.luv2code.com YouTube: http://goo.gl/EV6Kwv Twitter: http://goo.gl/ALMzLG Facebook: http://goo.gl/8pDRdA --- Join my mailing list: Get advance notice on new tutorials. Emails about 1 per week. - http://www.luv2code.com/joinlist --- Questions or problems? Post them in the comments section below. --- Want to suggest a video? Leave a comment below. I'm always looking for new video ideas. Let me know what video you'd like for me to create. --- Transcript Time - 00:00 Hi, this is Chad (Shod) with luv2code.com. Welcome back to another tutorial on Java JDBC. In this video, we’ll learn how to use stored procedures. We’ll first define what stored procedures are, next we’ll use callable statements. Then we’ll learn how to pass parameters to stored procedures. I’ll actually break this up over 4 different videos. I’ll show each parameter type in a separate video, so in this section we’ll cover IN parameters and then in the follow on sections, I’ll cover IN OUT, OUT and also result sets. Please stay tuned and check out the following videos for this. Time - 00:39 A stored procedure is a group of SQL statements that perform a particular task. They are normally created by a DBA. The stored procedures are created in a SQL language that supported by the native database. Each database has its own language. For example, MySQL has stored procedures language, Oracle uses PL/SQL and Microsoft SQL Server uses Transact SQL. Finally, the stored procedures can also have any combination of input and output parameters. For this tutorial, we’ll use the following table employees. The table has sample data for testing. I have a SQL zip file that’s you can download. It will create the table, add sample data and also set up the stored procedures. You can download it from the link below. Time - 01:22 All right, let’s go and switch over to the MySQL workbench and what I’m going to do is open up that SQL file and run it. This is our JDBC stored procedures directory. I have a subdirectory called SQL, and has this file, table set up that SQL. I’ll open this file, what this file does it basically creates a table as we see here and then it goes through and inserts a lot of sample data. Then, it also goes through and creates all of the stored procedures that we need for this tutorial, right. I’ll just go ahead and select execute and this will run and so now should I have a new table over here called employees and this table also has a collection or this database has a collection of stored procedures for this tutorial series, so get count employees, greet and increase salaries and we’ll go through all these stored procedures during the actual tutorial itself. Time - 02:24 In JDBC, you make use of callable statements to make a call to the stored procedures. There is a special syntax to call stored procedures. You make use of curly braces inside of the string. You also make use of the JDBC keyword call and that’s followed by the name of the stored procedure. In this example, we’re not passing any params, so we’ll just use the open and closed parentheses. Finally, we execute the stored procedure. Let’s talk about the parameters on the next slide. The JDBC API support different types of parameters. You can make use of the IN parameter, INOUT and also the OUT. The stored procedures can also return a result set, during the code examples in this video, I’ll show you how to register different parameters types and also values. Time - 03:09 Let’s start with IN parameters. For this parameter, we’re only passing an input parameter and the parameter is read-only. Our DBA has created a stored procedure on the database. This stored procedure will increase the salary for everyone in the department, which is kind of cool. The procedure takes two parameters. The first parameter is the department name. The second parameter is the increase amount. For example, we can call this stored procedure and increase the salaries of employees in the engineering department by $10,000. In terms of Java coding, we need to make a call to the stored procedure. First, we prepare a callable statement, since the stored procedure takes two parameters, we’ll make use of our question mark place orders for the parameters. [snip] ... See Transcripts tab
Views: 87756 luv2code
Supply Chain training | Supply Chain - oracle online trainings
 
00:51
Supply Chain training retailer's ability to fulfill its brand promise depends on effective store and direct.Register today for supply chain online training. Reach us: Email : [email protected] Contact : +91 8121 020 111 Supply Chain Training Course Content Introduction to the Supply Chain Overview of the Course Course Objectives Course Agenda Overview of the demand Define the demand forecasting Describe the role of demand forecasting in the retail planning process List the challenges to successful demand forecasting Explain how the RDF overcomes forecasting challenges Describe how the RDF may be integrated with the other applications Business Process Flow Describe the steps in the RDF primary workflow List the various methods of the forecast approval Name the two additional tools provided for analysing demand forecasts for accuracy Navigate through the RDF steps using the RDF workflow Login & Task flow Start the RDF Client Describe process of the RDF login process Select the RDF Domain Explain the RDF Task flow Pane Pre-processing Data for Forecasting Define data pre-processing Describe at least 3 pre-processing methods Explain why pre-processing data may be necessary to create accurate the demand forecasts Explain the impact of the Clear & No Filtering pre-processing Method Forecasting Methods Smoothing Exponential Regression Analysis Bayesian Analysis Prediction Intervals Automatic Method Selection The Source-level Forecasting Promotional Forecasting Setting the Forecast Parameters Identify the functions of an Forecast Administration Task List the Forecast Administration Identify the functions of the Forecast Maintenance Task List the Forecast Maintenance Explain the functions of the key View Parameters Like Item, Sister Store & the Product Cloning Describe the function of the Like-Item, Sister Store Task List the views found in the Like-Item, Sister Store Task Describe the key parameters found in the Like-Item, Sister-Store Views Describe the Product/Location Cloning Task List the views found in the Product/Location Cloning Task Describe the key parameters found in the Product/Location Cloning Views Generating the Forecasts Explain the steps in manually generating a demand forecast Explain the process of the generating a demand forecast through the nightly batch run Approving & Deleting Forecasts Differentiate between the different methods of approving the forecast List the possible Views in the Forecast Explain the purpose of the key parameters in the Forecast Approval Views Describe the tools used for the deleting a forecast Promote Describe the features & functionality of the (Optional) Promote solution Explain the difference between promotional & the statistical forecasting Use the Promotional Forecasting tools within RDF Curve Describe the business function of the Curve module Set the Curve parameters Explain the process of creating a custom Spread Profile using the Curve Tasks & Views Grade Describe the features & functionality of the Grade solution Identify the methods for creating the clusters Describe the each method in the detail Forecast Analysis Tools Explain the function & purpose of the Forecast Analysis tools Explain the function of the Views found in an Interactive Forecasting Task Explain the function of the Views found in an Forecast Scorecard Task Exporting Forecasts & RDF Integration Describe the process of the exporting demand forecasts Explain how to demand forecasts are used by other planning applications Explain how to demand forecasts are used by execution applications Review of the course Recap the RDF course content Create, run, & review a sample Demand Forecast
Views: 11 Oracle Trainings
Stored procedures in sql server   Part 18
 
20:11
In this video we will learn 1. What is a stored procedure 2. Stored Procedure example 3. Creating a stored procedure with parameters 4. Altering SP 5. Viewing the text of the SP 6. Dropping the SP 7. Encrypting stored procedure Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-part-18.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-18-stored-procedures.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 784918 kudvenkat
Debugging sql server stored procedures
 
15:11
debugging in ssms debugging t-sql code t sql debug stored procedure sql server management studio debug stored procedure how to debug t sql debug in sql server management studio In this video we will discuss how to debug stored procedures in SQL Server. Setting up the Debugger in SSMS : If you have connected to SQL Server using (local) or . (period), and when you start the debugger you will get the following error Unable to start T-SQL Debugging. Could not connect to computer. To fix this error, use the computer name to connect to the SQL Server instead of using (local) or . For the examples in this video we will be using the following stored procedure. Create procedure spPrintEvenNumbers @Target int as Begin Declare @StartNumber int Set @StartNumber = 1 while(@StartNumber [ @Target) Begin If(@StartNumber%2 = 0) Begin Print @StartNumber End Set @StartNumber = @StartNumber + 1 End Print 'Finished printing even numbers till ' + RTRIM(@Target) End Connect to SQL Server using your computer name, and then execute the above code to create the stored procedure. At this point, open a New Query window. Copy and paste the following T-SQL code to execute the stored procedure. DECLARE @TargetNumber INT SET @TargetNumber = 10 EXECUTE spPrintEvenNumbers @TargetNumber Print 'Done' Starting the Debugger in SSMS : There are 2 ways to start the debugger 1. In SSMS, click on the Debug Menu and select Start Debugging 2. Use the keyboard shortcut ALT + F5 At this point you should have the debugger running. The line that is about to be executed is marked with an yellow arrow Step Over, Step into and Step Out in SSMS : You can find the keyboard shortcuts in the Debug menu in SSMS. Let us understand what Step Over, Step into and Step Out does when debugging the following piece of code 1. There is no difference when you STEP INTO (F11) or STEP OVER (F10) the code on LINE 2 2. On LINE 3, we are calling a Stored Procedure. On this statement if we press F10 (STEP OVER), it won't give us the opportunity to debug the stored procedure code. To be able to debug the stored procedure code you will have to STEP INTO it by pressing F11. 3. If the debugger is in the stored procedure, and you don't want to debug line by line with in that stored procedure, you can STEP OUT of it by pressing SHIFT + F11. When you do this, the debugger completes the execution of the stored procedure and waits on the next line in the main query, i.e on LINE 4 in this example. To stop debugging : There are 2 ways to stop debugging 1. In SSMS, click on the Debug Menu and select Stop Debugging 2. Use the keyboard shortcut SHIFT + F5 Show Next Statement shows the next statement that the debugger is about to execute. Run to Cursor command executes all the statements in a batch up to the current cursor position Locals Window in SSMS : Displays the current values of variables and parameters If you cannot see the locals window or if you have closed it and if you want to open it, you can do so using the following menu option. Locals window is only available if you are in DEBUG mode. Watch Window in SSMS : Just like Locals window, Watch window is used to watch the values of variables. You can add and remove variables from the watch window. To add a variable to the Watch Window, right click on the variable and select "Add Watch" option from the context menu. Call Stack Window in SSMS : Allows you to navigate up and down the call stack to see what values your application is storing at different levels. It's an invaluable tool for determining why your code is doing what it's doing. Immediate Window in SSMS : Very helpful during debugging to evaluate expressions, and print variable values. To clear immediate window type ]cls and press enter. Breakpoints in SSMS : There are 2 ways to set a breakpoint in SSMS. 1. By clicking on the grey margin on the left hand side in SSMS (to remove click again) 2. By pressing F9 (to remove press F9 again) Enable, Disable or Delete all breakpoints : There are 2 ways to Enable, Disable or Delete all breakpoints 1. From the Debug menu 2. From the Breakpoints window. To view Breakpoints window select Debug =] Windows =] Breakpoints or use the keyboard shortcut ALT + CTRL + B Conditional Breakpoint : Conditional Breakpoints are hit only when the specified condition is met. These are extremely useful when you have some kind of a loop and you want to break, only when the loop variable has a specific value (For example loop varible = 100). How to set a conditional break point in SSMS : 1. Right click on the Breakpoint and select Condition from the context menu 2. In the Breakpoint window specify the condition Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures_28.html
Views: 116730 kudvenkat