|
|
| Welcome ExamGuru.net, Your Portal for IT Certifications providing the Actual Exam Questions to thousands. For over
a year now, ExamGuru.net has become the world leader in providing the most up-to-date exam questions and answers for the hottest certification exams. You get
the actual questions and answers that have been rigorously tested by international experts and many customers have made perfect scores on their exams after a
few ours of reading the files. This MEGA pack includes all major Certifications like Microsoft, Oracle, CISCO, Sun, Checkpoint, Citrix, A+, CISSP, IBM, Linux, Lotus Notes, CIW and many more. | ||||||||||||||||||||||||
site-map |
site-map 2 | site-map 3 | site-map 4 Certification
Site Map
Site Map
Site Map
Partner Sites: Free MCSE Exam Guides | Free Oracle 10g OCP | Free Cisco Braindumps | Cisco CCNA Practice Tests, Braindumps | Free Comptia A+ Pracitce Tests | Free MCSE Exam Simulators | Free Interview Questions | Free MCSE Braindumps | Free Java Interview Questions | Free .net Interview Questions | Free IT Training & Boot Camp | Free Financial Advice | Designer Perfumes at Wholesale Prices | Comptial A+ Network+ Server+ Linux+ Practice Tests | Comptial A+ Network+ Server+ Linux+ Practice Tests | Free Torrents, eboks, PDF, Study Notes, Exam Cram, actual tests, training materials, videos, bootcamps, practice tests, self test software, mock tests, guaranteed pass, objectives, sample questions, certification reviews, forums, preperation, distance learning, for dummies, crack, latest labs, news groups, upgrades, university, website, at home learning, syllabus, tutorial, pass at first try, cert number, course, resources, dump, testking, and more
site-map |
Cisco Exam List |
Microsoft Exam List | Oracle Exam List
Cisco
Study Guides |
Cheap
Study Guides | Brand
name Perfumes | Cheap
Travel Website Design, Developed & SEO by InternetWiz Copyright © 2004 ExamGuru, Inc. All Rights Reserved.
Microsoft Training and Certification. Online magazine for IT professionals with independent editorial and a community environment. Resources for Microsoft
certification tracks include books, exam notes, training centers and courses, bootcamps, and study websites. Offers free online practice tests for the most
popular Microsoft exams. Practice exams for MCSE core four. Offers free MCSD/MCAD study resources, links and notes. Provides the insight of one test-taker
into various Microsoft exams. Practice questions and answers with explanations for Microsoft MCP, MCSA and MCSE exams. An MCSE, under the pen name Firepower,
links to dozens of articles related to Microsoft exam topics. Links and original commentary are categorized by exam. Collection of MCSE information,
resources and practice tests. Collection of resources and study guides to help you prepare with MCSE ceritifcation. Provides exam notes for MCDBA database
certification exams. Provides exam notes for MCDBA database certification exams. Offers online training for Microsoft certifications. Offers newsletters,
forums, Questions of the Day, arcade games and study recommendations for those pursuing Microsoft certifications. Latest independent information on the MCP
program. Free resources for MCSE, MCSA, MCSD, and MCDBA, including practice exams. Offers free practice exams for the MCSE core examinations. How To Achieve
Your MCSE Without Spending Thousands Of Dollars. ccna boot camp | ccna forums | ccna braindump | ccnp practice exams | ccna test questions | ccna cheat sheets | ccie lab tips | ccna brain dumps | ccna study | resume ccie | ccna router - Cisco Certification Exam Preparation. exam prep questions, practice tests, and study material for the Cisco exams. Providing Cisco training, Cisco certification, CCNA, CCNP, CCDA and CCDP. Online internetworking community offering training, white papers, lab scenarios, discussion forums, and career advice for Cisco Certification candidates - www.examguru.net Remote online Cisco lab for CCNA/CCNP/CCSP and CCIE certifications. Training tool for Cisco certification exams that creates a virtual lab environment for practice with IOS. Provides CD-ROMS, videos and test software for CCNA, CCNP, and CCIE. Offers network training for certification programs like CCIE, CCNP and CCNA. Provides CCIE level practice labs, training classes, and bootcamps. CCNA quick overview study notes. Provides CCIE lab rack rental and lab scenarios. Provides online access to a remote router lab for Cisco CCNA/CCNP self-training. Offers a software for simulating a router. free CCNA router simulation lab for Cisco IOS practice. Products for CCNA, CCNP, CCDA, and CCDP. Free courses available. Offers online training on Cisco certification exams. Provides information such as salary surveys and exam reviews on Cisco products and Cisco certification programs. Provides training on Cisco certification programs in America - USA. Providers of Cisco certification training seminars. Online network lab rental. Train for the CCNA or CCNP certifications on Cisco router hardware and software.Offers tutorials, practices exams, and learning forums for Cisco exams. Provides online lab resources to help prepare for Cisco certifications. Exam Simulator providing five mock tests on CCNA. Discussion on routing and switching part of the CCNP certification. Online internetworking community offering training, white papers, lab scenarios, discussion forums, and career advice for candidates. CCNA Practice Tests Free CCNA exams and tests, practice questions. CCNA Study Resources Free CCNA study guides and tutorials, exam crams, sites offering free online training. Cisco's CCNA Resources CCNA resources on the Cisco Certification site. Building, Netorking, Routing, Switching, Designing Cisco CCNA Networks Resources Cisco CCNA Certification info, tools, tips and tricks, technical support notes, cofiguring firewall forums, blogs. Free Cisco CCNA Books, ebooks, Online CCNA Online libraries - books, ebboks, notes, pdf files, braindumps and reference materials. Read it for free! Cisco CCNA Jobs, Resumes Cisco CCNA Certification technologies information: Training, Torrents, Lab Preparation, practice tets, actual exam questions and answers. Personal CCNA Pages, Trainig Material Personal pages with useful Cisco CCNA information. Get CCNA Advice 24/7! CCNA related forums, blogs and newsgroups. Virtual community for Cisco certification students Cisco CCNA Interview Questions Cisco CCNA related interview questions, answers, salary information, resume help. Search CCNA jobs in US, UK, and India. ccna boot camp | ccna forums | ccna braindump | ccnp practice exams | ccna test questions | ccna cheat sheets | ccie lab tips | ccna brain dumps | ccna study | resume ccie | ccna router - Cisco Certification Exam Preparation. exam prep questions, practice tests, and study material for the Cisco exams. Providing Cisco training, Cisco certification, CCNA, CCNP, CCDA and CCDP. Online internetworking community offering training, white papers, lab scenarios, discussion forums, and career advice for Cisco Certification candidates - www.examguru.net Remote online Cisco lab for CCNA/CCNP/CCSP and CCIE certifications. Training tool for Cisco certification exams that creates a virtual lab environment for practice with IOS. Provides CD-ROMS, videos and test software for CCNA, CCNP, and CCIE. Offers network training for certification programs like CCIE, CCNP and CCNA. Provides CCIE level practice labs, training classes, and bootcamps. CCNA quick overview study notes. Provides CCIE lab rack rental and lab scenarios. Provides online access to a remote router lab for Cisco CCNA/CCNP self-training. Offers a software for simulating a router. free CCNA router simulation lab for Cisco IOS practice. Products for CCNA, CCNP, CCDA, and CCDP. Free courses available. Offers online training on Cisco certification exams. Provides information such as salary surveys and exam reviews on Cisco products and Cisco certification programs. Provides training on Cisco certification programs in America - USA. Providers of Cisco certification training seminars. Online network lab rental. Train for the CCNA or CCNP certifications on Cisco router hardware and software.Offers tutorials, practices exams, and learning forums for Cisco exams. Provides online lab resources to help prepare for Cisco certifications. Exam Simulator providing five mock tests on CCNA. Discussion on routing and switching part of the CCNP certification. Online internetworking community offering training, white papers, lab scenarios, discussion forums, and career advice for candidates. CCNA Practice Tests Free CCNA exams and tests, practice questions. CCNA Study Resources Free CCNA study guides and tutorials, exam crams, sites offering free online training. Cisco's CCNA Resources CCNA resources on the Cisco Certification site. Building, Netorking, Routing, Switching, Designing Cisco CCNA Networks Resources Cisco CCNA Certification info, tools, tips and tricks, technical support notes, cofiguring firewall forums, blogs. Free Cisco CCNA Books, ebooks, Online CCNA Online libraries - books, ebboks, notes, pdf files, braindumps and reference materials. Read it for free! Cisco CCNA Jobs, Resumes Cisco CCNA Certification technologies information: Training, Torrents, Lab Preparation, practice tets, actual exam questions and answers. Personal CCNA Pages, Trainig Material Personal pages with useful Cisco CCNA information. Get CCNA Advice 24/7! CCNA related forums, blogs and newsgroups. Virtual community for Cisco certification students Cisco CCNA Interview Questions Cisco CCNA related interview questions, answers, salary information, resume help. Search CCNA jobs in US, UK, and India. ccna boot camp | ccna forums | ccna braindump | ccnp practice exams | ccna test questions | ccna cheat sheets | ccie lab tips | ccna brain dumps | ccna study | resume ccie | ccna router - Cisco Certification Exam Preparation. exam prep questions, practice tests, and study material for the Cisco exams. Providing Cisco training, Cisco certification, CCNA, CCNP, CCDA and CCDP. Online internetworking community offering training, white papers, lab scenarios, discussion forums, and career advice for Cisco Certification candidates - www.examguru.net Remote online Cisco lab for CCNA/CCNP/CCSP and CCIE certifications. Training tool for Cisco certification exams that creates a virtual lab environment for practice with IOS. Provides CD-ROMS, videos and test software for CCNA, CCNP, and CCIE. Offers network training for certification programs like CCIE, CCNP and CCNA. Provides CCIE level practice labs, training classes, and bootcamps. CCNA quick overview study notes. Provides CCIE lab rack rental and lab scenarios. Provides online access to a remote router lab for Cisco CCNA/CCNP self-training. Offers a software for simulating a router. free CCNA router simulation lab for Cisco IOS practice. Products for CCNA, CCNP, CCDA, and CCDP. Free courses available. Offers online training on Cisco certification exams. Provides information such as salary surveys and exam reviews on Cisco products and Cisco certification programs. Provides training on Cisco certification programs in America - USA. Providers of Cisco certification training seminars. Online network lab rental. Train for the CCNA or CCNP certifications on Cisco router hardware and software.Offers tutorials, practices exams, and learning forums for Cisco exams. Provides online lab resources to help prepare for Cisco certifications. Exam Simulator providing five mock tests on CCNA. Discussion on routing and switching part of the CCNP certification. Online internetworking community offering training, white papers, lab scenarios, discussion forums, and career advice for candidates. CCNA Practice Tests Free CCNA exams and tests, practice questions. CCNA Study Resources Free CCNA study guides and tutorials, exam crams, sites offering free online training. Cisco's CCNA Resources CCNA resources on the Cisco Certification site. Building, Netorking, Routing, Switching, Designing Cisco CCNA Networks Resources Cisco CCNA Certification info, tools, tips and tricks, technical support notes, cofiguring firewall forums, blogs. Free Cisco CCNA Books, ebooks, Online CCNA Online libraries - books, ebboks, notes, pdf files, braindumps and reference materials. Read it for free! Cisco CCNA Jobs, Resumes Cisco CCNA Certification technologies information: Training, Torrents, Lab Preparation, practice tets, actual exam questions and answers. Personal CCNA Pages, Trainig Material Personal pages with useful Cisco CCNA information. Get CCNA Advice 24/7! CCNA related forums, blogs and newsgroups. Virtual community for Cisco certification students Cisco CCNA Interview Questions Cisco CCNA related interview questions, answers, salary information, resume help. Search CCNA jobs in US, UK, and India. ccna boot camp | ccna forums | ccna braindump | ccnp practice exams | ccna test questions | ccna cheat sheets | ccie lab tips | ccna brain dumps | ccna study | resume ccie | ccna router - Cisco Certification Exam Preparation. exam prep questions, practice tests, and study material for the Cisco exams. Providing Cisco training, Cisco certification, CCNA, CCNP, CCDA and CCDP. Online internetworking community offering training, white papers, lab scenarios, discussion forums, and career advice for Cisco Certification candidates - www.examguru.net Remote online Cisco lab for CCNA/CCNP/CCSP and CCIE certifications. Training tool for Cisco certification exams that creates a virtual lab environment for practice with IOS. Provides CD-ROMS, videos and test software for CCNA, CCNP, and CCIE. Offers network training for certification programs like CCIE, CCNP and CCNA. Provides CCIE level practice labs, training classes, and bootcamps. CCNA quick overview study notes. Provides CCIE lab rack rental and lab scenarios. Provides online access to a remote router lab for Cisco CCNA/CCNP self-training. Offers a software for simulating a router. free CCNA router simulation lab for Cisco IOS practice. Products for CCNA, CCNP, CCDA, and CCDP. Free courses available. Offers online training on Cisco certification exams. Provides information such as salary surveys and exam reviews on Cisco products and Cisco certification programs. Provides training on Cisco certification programs in America - USA. Providers of Cisco certification training seminars. Online network lab rental. Train for the CCNA or CCNP certifications on Cisco router hardware and software.Offers tutorials, practices exams, and learning forums for Cisco exams. Provides online lab resources to help prepare for Cisco certifications. Exam Simulator providing five mock tests on CCNA. Discussion on routing and switching part of the CCNP certification. Online internetworking community offering training, white papers, lab scenarios, discussion forums, and career advice for candidates. CCNA Practice Tests Free CCNA exams and tests, practice questions. CCNA Study Resources Free CCNA study guides and tutorials, exam crams, sites offering free online training. Cisco's CCNA Resources CCNA resources on the Cisco Certification site. Building, Netorking, Routing, Switching, Designing Cisco CCNA Networks Resources Cisco CCNA Certification info, tools, tips and tricks, technical support notes, cofiguring firewall forums, blogs. Free Cisco CCNA Books, ebooks, Online CCNA Online libraries - books, ebboks, notes, pdf files, braindumps and reference materials. Read it for free! Cisco CCNA Jobs, Resumes Cisco CCNA Certification technologies information: Training, Torrents, Lab Preparation, practice tets, actual exam questions and answers. Personal CCNA Pages, Trainig Material Personal pages with useful Cisco CCNA information. Get CCNA Advice 24/7! CCNA related forums, blogs and newsgroups. Virtual community for Cisco certification students Cisco CCNA Interview Questions Cisco CCNA related interview questions, answers, salary information, resume help. Search CCNA jobs in US, UK, and India. 1Z0 122 1Z0 007 install 9i starting 10g Oracle Database Operator oracle information oracle 9i sql uninstalling 10g oracle 10g performance starting 10g oracle 10g developer oracle 9i export 10g developer suite 10g application server 9i personal oracle news oracle database 10g start oracle 9i 10g slow oracle sql training oracle 10g solaris 10 oracle jobs financials jobs oracle 9i java oracle applications training oracle consultant oracle 9i xp oracle 9i database oracle 10g new features 10g client OracleAS 10g Web Administrator oracle 9i on linux oracle 9i odbc oracle utilities 9i driver 9i client linux Hands on IT Training oracle training 10g on linux starting oracle 10g sybase to migration what is oracle 10g oracle forms 9i oracle 10g grid consultants 9i features linux oracle 10g sqlplus 10g 9i oracle financials jobs and sql server oracle 10g system requirements oracle 10g client download 9i client installation 10g database 9i pl sql oracle 10g administration oracle pl sql oracle jobs oracle 9i date financials jobs what is oracle 9i oracle database administrator oracle workflow database tuning 10g system requirements sybase to oracle migration oracle 9i dynamic performance views select from exam certification database tuning Oracle Certified Professional 9i on fedora 1Z0 025 9i functions introduction to oracle 9i 9i export 9i xml 10g release 1 9i personal oracle 10g redhat 9i java oracle 9i client linux download oracle 9i oracle jobs Oracle10g New Features 9i xml 10g jdbc oracle financials jobs oracle 9i reference 1Z0 041 9i oem install 10g 10g solaris oracle 10g replication oracle certification training 9i insert oracle 10g release 10g application server oracle 9i books Oracle grid control installing 10g on windows installing 10g application server 10g release 2 9i date 9i sql reference oracle 10g system requirements application server 9i 1Z0 043 oracle 10g exam 10g forms oracle 10g personal edition oracle 10g system requirements oracle 10g aix uninstalling oracle 10g download 9i oracle 10g install sybase to oracle migration oracle workflow how to install 9i sample questions installing oracle 10g on windows oracle oci oracle consultant 9i white paper 10g sqlplus oracle 9i books oracle 9i performance tuning 10g start 1Z0 035 oracle consultants oracle 9i tutorial 10g sqlplus 10g personal oracle 10g books oracle 10g sqlplus download 9i oracle 9i installation guide 10g standard 10g redhat oracle 9i merge OCM sybase to oracle migration oracle 10g installation 10g sql 9i exam uninstalling oracle 10g jdbc oracle Oracle11i UNIX Oracle Administration oracle consultant oracle 10g xml oracle cbt 10g aix developer jobs 10g slow oracle 8i to oracle 9i 9i database oracle certification oracle 9i downloads 10g database oracle 10g jdbc driver what is oracle 10g 9i insert 10g administration 10g em oracle 10g startup 10g download oracle 10g upgrade database administrator discoverer 10g oracle pl sql oracle financials jobs oracle 10g em 9i complete reference oracle 9i as oracle 9i sql reference oracle 9i features installing 9i oracle 10g patch and sql server jdbc pl sql as 10g Computer Based Training 9i documentation 1Z0 043 install 9i client 8i to 9i what is 9i 10g system requirements 10g client download 9i architecture oracle 10g on suse faq 9i rman guide to 9i oracle application server 9i 10g upgrade orafaq 10g grid databases 9i downloads oracle 9i sql reference sybase to migration oracle 10g personal oracle 9i 10g installing oracle 10g on linux 9i patch oracle 10g performance 9i olap join in 9i Oracle 11i E Business Suite installing oracle 10g 1Z0 035 9i lite 9i xp 9i dynamic performance views select from exam Oracle Certified Professional 10g backup oracle 10g uninstall 10g app server 9i dynamic performance views oracle adapter and sql server Oracle Database Operator application server 10g release 2 start 9i oracle 9i driver oracle database 10g insider solutions 1Z0 122 oracle 9i features 10g exam guide to oracle 9i start 10g 10g jdbc driver Oracle Certified Associate oracle 9i downloads 1Z0 026 10g new features financials jobs 10g oem oracle 9i standby database oracle forms training uninstalling 10g install 9i oracle 10g ocp 9i database oracle developer suite 10g oracle 9i merge oracle 10g application server 9i performance tuning start 9i 9i pl sql oracle 9i reports oracle 9i documentation oracle database 10g insider solutions 10g books 1Z0 140 oracle 10g export oracle 9i installation erp start 9i peoplesoft oracle 1Z0 141 join in 9i Oracle10g oracle application server 10g release 2 9i downloads 9i application server 10g release 2 cbt oracle oracle apps jobs oracle jobs oracle consultant 9i sql oracle 9i xp Oracle Certified Associate 9i database administrator oracle information oracle 9i lite oracle 9i olap 10g app server Oracle 10g ADF J2EE Developer oracle 9i xml oracle 9i odbc driver oracle jobs in Oracle9i J2EE 9i complete reference 10g data types 9i installation guide jobs oracle sybase to migration 9i tutorial 10g new features oracle 10g replication 10g backup oracle 9i listener oracle 9i download oracle financials jobs 9i xml 9i lite oracle jobs 1Z0 123 indexes in oracle 9i oracle 10g create user 10g suse oracle 9i dynamic performance views starting 10g erp oracle oracle 10g backup installing 10g on linux 8i to 9i oracle 10g certification oracle 9i insert sybase to migration oracle 10g new features 1Z0 030 oracle 9i programming oracle 9i xml oracle conversion 10g replication oracle database 10g release 2 oracle linux oracle 10g installation oracle 10g uninstall oracle 9i install reports 10g Oracle 11i Applications DBA oracle interface Oracle 11i Applications Developer download 10g 10g release 1 oracle application server 9i oracle 9i application server oracle database 10g insider solutions oracle 9i database administrator oracle software oracle pl sql 9i new features oracle 9i new features installing oracle 9i oracle 10g hardware requirements 10g new features 9i database administrator 10g upgrade oracle 10g replication 9i 10g oracle 10g 9i 10g windows oracle 10g install oracle 9i patch oracle news oracle 10g backup oracle 10g developer suite oracle 9i listener select from exam certification join in 9i oracle 8i to oracle 9i install oracle 9i oracle 10g sqlplus oracle 10g oem 10g install install 9i client 8i to 9i oracle consultant oracle adapter oracle forms 9i oracle 9i features oracle adapter 10g em oracle 8i to oracle 9i oracle 10g jdbc driver 10g hardware requirements oracle 10g release starting oracle 10g 10g oem install oracle 9i on linux Oracle 11i E Business Suite oracle 9i sql reference oracle 9i patches 8i to 9i install 9i on linux 9i on fedora start 9i 9i client download 9i tuning 10g 10g on linux oracle 10g performance 10g fedora 10g personal 10g export 10g migration oracle 9i windows xp oracle 9i xml 9i data guard oracle 10g system requirements Oracle DBA Advanced Topics 9i date oracle 9i date introduction to 9i oracle 9i standby database client 9i oracle 9i release oracle contract jobs oracle 10g create user application server 9i news oracle interface oracle application server 10g release 2 oracle conversion 9i database administrator 9i performance tuning oracle 9i white paper oracle database 10g insider solutions 9i exam guide to oracle 9i oracle 9i application server database tuning oracle 9i white paper 10g personal edition oracle 10g download Oracle DBA Advanced Topics developer jobs oracle 10g sqlplus 9i complete reference oracle 10g suse 1Z0 007 oracle development and sql server oracle 9i features 10g certification 10g aix Oracle9i JDeveloper oracle 9i downloads 9i books oracle contract jobs 10g create database 9i performance tuning oracle 9i pl sql oracle interface oracle 9i on fedora 10g redhat oracle 9i exam oracle online training oracle financials jobs uninstall 10g 10g xml 10g install oracle 10g personal edition 10g database oracle 9i rman sybase to migration install 9i oracle forms training oracle certification training 9i odbc 9i odbc driver 8i to 9i Oracle 11i Applications DBA introduction to oracle 9i start 10g oracle 9i xp 10g lite oracle contract jobs client 10g 9i books faq Oracle10g oracle 9i sql oracle 9i personal oracle 10g start 1Z0 301 oracle news oracle 10g performance oracle certification training database 10g 1Z0 040 oracle 10g on suse 10g grid oracle 10g replication oracle jobs oracle certification training developer jobs installing 10g on windows 9i driver indexes in oracle 9i database 10g release 2 9i client download 10g import oracle 10g start oracle 9i jdbc driver introduction to oracle 9i 10g oem oracle 9i date oracle 10g oca erp oracle linux ado net oracle 9i as oracle 9i installation guide uninstall 9i oracle 9i sql introduction to oracle 9i 9i dynamic performance views Oracle9i JDeveloper oracle 9i client download oracle 9i programming 10g system requirements oracle 10g solaris 10 9i features 1Z0 042 oracle certification 9i insert 10g mac 8i to 9i Oracle Certified Associate oci oracle 10g migration 1Z0 040 1Z0 025 oracle 9i download oracle 9i patches 9i functions orafaq oracle 10g export oracle information 1Z0 121 oracle 10g app server 10g release 2 starting oracle 10g installing oracle 9i as 10g oracle performance 1Z0 501 database 10g insider solutions oracle software oracle 9i olap oracle 10g certification oracle adapter 10g release 10g fedora oracle 10g client 1Z0 301 9i forms oracle database 10g oracle client 9i oracle 9i database oracle developer jobs erp oracle 10g release 2 9i architecture oracle 10g forms 9i on fedora 10g system requirements 9i functions 9i client linux oracle apps jobs oracle administration oracle 10g features ado net oracle oracle developer jobs in 9i sql oracle 10g asm oracle 10g installation oracle 9i olap 1Z0 032 9i patch oracle 9i case oracle 10g certification utilities start oracle 9i 1Z0 131 pl sql 9i installation oracle 9i rman 9i documentation oracle database 10g insider solutions oracle 9i sqlplus oracle 9i architecture oracle 10g on suse oracle financials jobs oracle 9i replication install oracle 9i client 1Z0 041 9i backup 10g exam 10g developer 10g driver 9i java oracle apps jobs oracle conversion 9i client download 9i dynamic performance views select from exam oracle developer 10g oracle 10g on solaris oracle 9i jdbc driver application oracle 9i pl sql oracle 9i backup 1Z0 042 10g system requirements 1Z0 041 oracle 9i xml 10g patch Oracle 10g Grid Training 10g oem oracle 10g em client 9i Oracle Real Application Clusters RAC Training oracle 9i complete reference oracle 8i to oracle 9i oracle consulting 10g backup Advanced Oracle SQL Tuning oracle 10g patch 9i downloads oracle 10g training oracle 10g standard oracle 10g mac oracle 9i 10g oracle 9i sql 10g jdbc database 10g 9i features Oracle 11i Applications Developer oracle information download 10g oracle 10g forms databases installing 10g 10g uninstall 1Z0 141 join in oracle 9i oracle 9i database 1Z0 040 Oracle grid control Oracle Certified Master 1Z0 024 oracle jobs developer jobs Oracle10g New Features oracle database 10g insider solutions oracle 9i white paper 9i patch oracle workflow uninstall oracle 9i oracle 10g start oracle 10g documentation oracle 9i client download oracle 10g download oracle replication peoplesoft oracle financials jobs 9i merge OracleAS 10g Web Administrator 9i backup installing oracle 9i oracle 10g windows odbc driver join in 9i 9i install oracle 10g personal edition oracle performance installing oracle 9i oracle 10g oca oracle 9i insert 9i forms oracle 10g data types oracle 9i odbc sample questions 10g create user oracle 9i data types oracle 9i installation start 10g sample questions 9i features application server 9i oracle 9i installation indexes in oracle 9i 10g database Oracle 11i E Business Suite installing 10g on windows install oracle 9i oracle financials jobs oracle jobs oracle database tool 10g system requirements oracle 10g asm oracle 10g start 10g release 2 erp oracle 9i client installation online training oracle 10g 9i financials jobs Internet Application Developer 9i application server oracle 9i linux oracle 10g sql oracle 9i new features 9i reports oracle database tuning 1Z0 024 9i book oracle jobs oracle software news database tuning ado net oracle forms 9i oracle 10g on solaris what is 10g Oracle 10g Grid Training 9i xml jobs oracle oracle 10g exam 10g training oracle workflow oracle database tuning oracle 10g database Oracle8i installing 10g on linux Oracle10g New Features oracle 9i lite 9i server oracle jobs oracle 9i personal 9i forms oracle 10g on solaris oracle 9i dynamic performance views oracle 9i application server 9i rman developer jobs 1Z0 041 replication oracle 9i forms 10g create user oracle 10g solaris 10 uninstalling oracle 10g jdbc oracle news oracle 9i sql 10g em 9i tutorial 1Z0 132 odbc driver cbt oracle 8i to 9i oracle 10g release 1 10g ocp oracle 10g exam oracle 9i server 1Z0 141 10g ocp install oracle 10g oracle database 10g release 2 9i sqlplus 1Z0 132 client 10g oracle 9i olap 10g sqlplus Oracle OCP Certification Exam oracle developer suite 10g oracle 9i sql oracle client 10g oracle software 9i data guard oracle jobs 9i tuning 9i windows xp oracle database tuning oracle 10g solaris 9i tuning uninstall oracle 10g 1Z0 027 oracle 10g fedora oracle 9i standby database OCp difference between 9i and 10g installing oracle 10g 9i sql how to install oracle 9i oracle certification oracle workflow Oracle10g New Features oracle 9i tutorial and sql server Oracle 11i System Administrator 10g training what is 9i pl sql consulting 10g on solaris oracle database 10g insider solutions 9i client download installing oracle 10g on linux 9i upgrade 9i programming oracle certification 9i documentation client 9i 9i 10g oracle application oracle 10g jdbc driver 9i client install oracle reports 10g 1Z0 025 oracle 9i windows xp oracle adapter oracle 9i forms Oracle DBA Advanced Topics oracle jobs oracle 10g on suse 9i import 9i xp 10g client oracle 9i client installation 9i sqlplus 1Z0 030 oracle 9i client install oracle 10g startup 9i documentation database administrator oracle financials jobs Oracle9i JDeveloper oracle developer 10g oracle 10g 9i erp oracle 10g patch oracle 10g lite 10g export 9i documentation 10g certification oracle 10g release 1 oracle discoverer 10g oracle 9i reports oracle 10g release 2 oracle applications training oracle 9i case consulting oracle application oracle 9i as oracle 10g certification oracle 10g export oracle consultant 9i install oracle 9i merge guide to oracle 9i 9i 10g client oracle 9i features 10g performance oracle software 9i database administrator 9i rman oracle 9i books 9i odbc driver download 10g developer jobs Oracle10g New Features 10g standard oracle 9i data types 1Z0 121 1Z0 030 10g slow OCA oracle 9i export oracle oci oracle databases Hands on IT Training certification 9i database 9i import oracle 10g app server oracle implementation 1Z0 045 oracle consultants what is oracle 9i 10g jdbc 9i reference start oracle 9i oracle consulting jobs 9i book 9i patch install 9i 10g new features oracle jobs in 1Z0 122 oracle 10g oem oracle 9i dynamic performance views select from exam 10g oca financials jobs oracle forms 9i oracle training oracle interface guide to oracle 9i start oracle 10g 10g 9i 9i books oracle 9i database oracle 10g sqlplus oracle 9i database administrator 9i on fedora 9i book Oracle Database Operator 9i reports oracle 9i programming oracle 9i as Oracle9i J2EE 1Z0 035 oracle certification training oracle implementation uninstall 9i oracle 9i on linux 9i odbc installing 10g 10g OCp oracle database 10g insider solutions 10g fedora oracle 10g on solaris oracle 9i date 9i tutorial oracle 10g data types oracle 9i merge starting 10g Computer Based Training 10g developer suite oracle adapter oracle 9i architecture 10g release 1 orafaq erp oracle oracle 10g import 9i xp 9i client installation install oracle 9i 10g grid 9i backup oracle 9i sqlplus install 9i oracle 9i replication 10g certification how to install oracle 9i 10g installation oracle 9i exam as 10g oracle 10g application server oracle replication oracle 10g create user difference between oracle 9i and 10g 9i replication guide to 9i oracle 10g database installing oracle 10g on linux oracle consultant oracle news 10g slow oracle 10g migration difference between oracle 9i and 10g OCA oracle 9i sql oracle 10g administration orafaq application server 10g release 2 uninstalling oracle 10g oracle database tuning oracle consultant Oracle Database Operator 10g upgrade 9i pl sql oracle 10g oem 9i dynamic performance views and sql server 10g forms 9i lite oracle 10g system requirements oracle utilities 10g performance oracle 10g windows oracle 10g app server 9i download odbc driver 10g forms jobs in oracle installing oracle 10g on windows oracle 10g application server oracle 9i windows xp oracle 10g on solaris oracle 9i as oracle forms 9i oracle administration 9i server oracle jobs in oracle database tuning installing oracle 10g on linux 10g export 9i install oracle 10g redhat oracle 9i export 9i database administrator Oracle RMAN Backup & Recovery Training 9i download oracle consultant 10g forms developer jobs 10g jdbc driver Oracle Auditing oracle 9i application server utilities oracle 10g asm oracle 10g certification reports 10g 9i server jobs oracle 9i xml oracle 10g jdbc driver start oracle 9i financials jobs 9i server 10g import oracle as 10g oracle forms training oracle 9i downloads oracle jobs 9i documentation oracle software Oracle 11i System Administrator 9i reference certification 9i xp 9i sql Oracle11i oracle 9i merge 1Z0 147 9i download 10g import client 9i jobs oracle jdbc Upgrading to Oracle10g 10g system requirements 9i sql oracle certification oracle database 10g release 2 10g sqlplus oracle 10g create database developer jobs 9i installation 1Z0 031 uninstall 9i sample questions oracle 10g release oracle consultant oracle 10g oem oracle 9i application server 10g forms oracle 10g as oracle 10g lite oracle 10g app server oracle 10g oca oracle 10g system requirements erp oracle 9i lite 9i data guard 1Z0 041 10g database installing 10g on windows oracle accounting oracle 10g performance 1Z0 001 oracle 10g client download developer jobs 9i forms oracle workflow 10g create database indexes in 9i download 10g 10g on solaris 10g driver oracle 10g developer oracle 9i tuning indexes in oracle 9i 9i architecture oracle 9i application server oracle apps jobs oracle implementation 9i listener oracle pl sql 10g oracle 9i dataguard oracle 10g download 9i oracle online training database 10g release 2 sample questions oracle 9i dynamic performance views application oracle forms training oracle 9i dynamic performance views select from exam 1Z0 045 oracle 9i dynamic performance views select from exam Oracle RMAN Backup & Recovery Training 9i white paper oracle 10g import how to install 9i 10g fedora 10g on suse jdbc client 9i oracle 9i personal start 10g 10g personal 9i book oracle 9i dynamic performance views select from exam certification 10g slow 9i forms sybase to migration oracle 9i features 9i downloads 10g certification 9i features 9i features Oracle Certified Associate oracle 10g release 2 9i data types 9i release oracle 10g standard 10g xml 9i client installation oracle 10g client download 9i case 10g install oracle 10g slow oracle cbt oracle adapter 10g on suse oracle 10g redhat oracle 9i data guard 10g start download 10g Oracle10g New Features oracle 10g training oracle online training 1Z0 007 online training installing 10g on linux oracle 9i driver download 10g oracle 9i downloads oracle 8i to oracle 9i jdbc uninstall oracle 9i oracle online training cbt oracle oracle 10g administration download oracle 9i OCp news and sql server oracle 10g sql oracle developer jobs 9i installation guide oracle 9i on fedora 8i to 9i jdbc 10g release 2 oracle 9i documentation 10g release 1 10g 9i oracle workflow oracle 9i dynamic performance views 10g documentation oracle 9i reports introduction to oracle 9i Oracle Certified Master OCA oracle conversion 9i database 9i new features Computer Based Training oracle replication 9i oracle client 10g 10g forms oracle news oracle 10g jdbc driver oracle 10g lite oracle 9i xml oracle 9i 10g 10g client developer jobs oci start 10g oracle 9i book Oracle Database Operator forms 9i database tool reports 10g consultants jobs in oracle oracle 9i on fedora 9i dataguard 9i java 9i listener oracle 10g standard Oracle Developer 6i Forms oracle 10g export indexes in oracle 9i oracle 10g as 9i install oracle 9i on linux 10g import oracle 10g create database download oracle 10g application server 10g release 2 oracle 10g installation oracle 10g solaris oracle cbt oracle 10g patch oracle 10g solaris 10g developer 10g 10g solaris 10 9i oem 1Z0 042 orafaq oracle 10g mac 10g release 1 1Z0 147 10g grid oracle conversion 9i patches OracleAS 10g Web Administrator installing oracle 10g on windows 9i sqlplus oracle 9i programming 1Z0 025 oracle 10g backup 1Z0 040 1Z0 040 oracle 10g slow 10g driver difference between 9i and 10g financials jobs installing 10g on windows difference between 9i and 10g oracle 9i system requirements Oracle 11i Applications Developer oracle 9i release 1Z0 140 oracle 10g grid oracle 9i downloads 9i xp oracle administration oracle consulting jobs oracle 9i odbc oracle 10g certification database 10g release 2 1Z0 040 oracle client 9i oracle 9i replication 9i reports 10g windows 9i reports oracle 9i standby database 9i 10g 1Z0 026 9i lite 9i database utilities 10g mac Oracle 11i Applications DBA 1Z0 020 oracle 10g system requirements download 10g 9i sql 10g windows 9i dataguard oracle 9i server 9i features 9i listener uninstall oracle 9i oracle 10g standard oracle conversion 9i books Oracle Administration & Management how to install 9i oracle 9i server install oracle 9i on linux 9i exam 9i standby database oracle news oracle faq 10g patch oracle 9i java sybase to migration oracle 10g personal edition oracle 10g database oracle 9i listener oracle administration oracle 9i client download 10g create user 9i release 9i sql oracle 9i book 10g on linux pl sql indexes in 9i oracle administration 10g slow jobs oracle Oracle Certified Professional oracle 9i performance tuning jobs oracle oracle 9i personal install oracle 10g 10g application server sybase to oracle migration 10g solaris 10g developer certification training oracle 9i rman oracle 9i system requirements 9i programming 1Z0 501 oracle 9i tuning oracle 9i backup oracle 9i upgrade 10g documentation Oracle 11i Applications Developer 1Z0 020 oracle 10g asm 9i standby database oracle 10g aix OracleAS 10g Web Administrator Oracle PL/SQL Programming & Tuning databases 1Z0 140 oracle 9i reports financials jobs 9i database oracle developer jobs in 9i jdbc driver oracle 10g create database oracle 10g client download 1Z0 030 oracle 9i odbc guide to 9i 10g export 8i to 9i oracle developer jobs in oracle 9i install oracle 9i architecture oracle 10g system requirements 10g backup oracle 9i sql reference oracle 9i installation oracle development 9i database administrator oracle 10g certification 9i dataguard install 9i on linux oracle development 1Z0 141 sybase to oracle migration 9i pl sql 10g backup oracle workflow oracle 9i server 9i system requirements 9i merge oracle 9i oem 9i complete reference join in oracle 9i oracle 10g ocp oracle 10g xml installing oracle 10g on linux 9i programming oracle jobs 10g features oracle 9i client download 10g start 10g migration 10g backup 1Z0 132 oracle application server 10g release 2 oracle jobs 9i xp 9i rman oracle client 10g 9i upgrade oracle 9i data guard oracle interface oracle 10g application server oracle 10g documentation oracle 10g personal oracle consulting oracle software oracle and sql server oracle 9i reports oracle 9i as oracle apps jobs Oracle Real Application Clusters RAC Training ado net jobs at oracle oracle 9i features ado net oracle 9i system requirements select from exam certification 10g developer suite 9i odbc oracle 9i client download start 10g what is 9i oracle 9i sqlplus oracle 9i upgrade 1Z0 031 10g sqlplus oracle 10g certification 10g performance 9i on fedora and sql server oracle as 10g oracle implementation 10g create user uninstall 9i oracle sql training oracle developer 10g oracle 9i pl sql oracle adapter oracle adapter installing 10g on windows oracle 9i documentation oracle reports 10g oracle 10g asm 10g fedora 9i client installation oracle developer suite 10g oracle 10g application server 9i programming Upgrading to Oracle10g 9i on linux 9i personal 10g system requirements oracle developer suite 10g oracle 10g application server jdbc oracle 9i downloads oracle 10g suse oracle 10g application server oracle development linux Oracle10g New Features 1Z0 141 oracle 9i driver 9i backup 1Z0 121 oracle linux oracle 10g fedora oracle 10g lite 9i exam oracle discoverer 10g oracle application server 9i 1Z0 122 1Z0 023 1Z0 042 9i listener oracle consulting oracle 10g performance oracle developer suite 10g 9i on linux 10g performance UNIX Oracle Administration select from exam certification oracle 10g mac guide to 9i online training oracle 9i database administrator oracle 9i backup Oracle Real Application Clusters RAC Training 9i client installation oracle 10g developer 9i date certification training oracle 10g windows oracle 10g performance oracle 9i patch uninstall 9i 9i architecture 1Z0 132 1Z0 041 what is oracle 9i 9i functions oracle accounting Oracle Real Application Clusters RAC Training 9i standby database 1Z0 007 jobs oracle 10g aix Education and certification programs for Oracle's database, tools, and applications products. IT training for Oracle DBA, Developer, and Java programming topics. Learn more about Oracle certification at Education Online Search. Search our Oracle exam guides. Oracle9i DBA Certification Boot Camps - $40 includes Oracle 10g. Stimulate your Oracle training with extremely realistic Transcender exams. The Training Camp offers Oracle DBA certification training camps for networking. Increase your earning power. TechSkills' flexible, self-paced Oracle training. Complete oracle DBA certification training package. 24/7 Oracle, DB2, SQL support. A flexible answer to database needs. OCP: Oracle Certification - Ensure your success in OCP (Oracle certification) exam. Get information and links for Oracle certification tracks, including exam preparation, books, practice tests, and links. ... Guide to Oracle Certification. Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Training BootCamp Exam Questions. training tools for Oracle exams are your ticket to certification success. Oracle study guides, exam questions, Oracle prep materials. Try our Oracle ... will prepare you for the questions asked when seeking your Oracle Certification. code, utilities and a user forum. Covers Oracle 8i, 9i and 10G. ... Oracle Certification. Forums. Blog. Blog Aggregator. Industry News. Book Store. Questions and answers about the available Oracle Certification Exams and Tests. ... What official Oracle certification tracks are available? Oracle Certification Training BootCamp Exam Questions ... training tools for Oracle exams are your ticket to certification success. Oracle Braindumps for Certification Training at Blue Braindumps ... Prepare for your Oracle certification today! ... part of more than one Oracle certification. ORACLE DBA Certification Exam - Book Page. ... Oracle Exam & Certification Page. Oracle Certified Professional/DBA .Oracle Certification Training Boot Camp Classes and Courses on Videos and CDS. Learn Oracle with our training curriculum for 8i and 9i for Administration and Developer. Pass Oracle certification exam in first attempt. ... The Oracle Certified Professional (OCP) certification is given by one of the. Oracle Architecture. Startup and Shutdown Instance. Create a Database. Access and Update Data ... Oracle and Oracle Certification Training. Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Assisting Oracle customers and professionals by providing technical discussion, an integrated Oracle directory, job postings, news, and much more. A student entering the Oracle Certification Program must start with this course. ... prepared to take the Oracle Certification exam for the completed track. Oracle Certification Training for Oracle exams buy Exact Questions. Gauranteed Certification with 100% Exact Questions. New Oracle certification being offered. Oracle Training Videos and CD-ROMS Certification... Cisco,Unix,MCSE,Linux, Certification ... The complete Oracle Certification for 8 Certified Database Administration. Oracle 10g Automatic Storage Management, Part 1: Overview : Oracle 10g's new Automatic Storage Management (ASM) features allow an Oracle DBA to take advantage of a robust, flexible, scalable file storage system that any Oracle database instance can access. This article - the first in this series -- provides a high-level overview of the ASM architecture, and should be helpful to any DBA contemplating the adoption of ASM for storing Oracle database files as part of a high-volume storage solution. Database Security and Patches – Part 2 : Part 2 of this series covers the mechanics of installing a patch. RACing ahead with Oracle on VMware - Part 3: Installing Oracle 10g Release 2 Clusterware on a 2-node Windows 2003 Enterprise Edition Server : Part 3 of this series discusses the installation of Clusterware on a 2-node windows 2003 server with VMware. Database Security and Patches – Part 1 : Part 1 of this series provides a review of database security and looks at a well-known security hole in Oracle 9.2.0.1. "RACing ahead with Oracle on VMware Series" - Part II: Oracle RAC and RAW disk setup on Windows 2003 Enterprise Server : Part two of this series continues the discussion of Oracle RAC, how to install the VMware tools and set up RAW disks on Windows 2003 Enterprise Server. "RACing ahead with Oracle on VMware Series" - Part 1: Setting up VMware for Oracle/Intro to Virtualization/Server Consolidation : Part l of this series offers a brief introduction to setting up VMware and the importance of other tools such as VNC, freeNX or NoMachine, PuTTY, etc. Super-Sizing A Database: Oracle 10g Tablespace Enhancements : Oracle 10g's daunting array of new features like extended FLASHBACK technology, Automated Storage Management, and Grid Computing sometimes overshadow the more mundane -- yet no less impressive! - improvements to its logical storage capabilities. This article illustrates several enhancements to Oracle's already robust logical storage structures, including the SYSAUX tablespace, BIGFILE tablespaces, tablespace groups, and tablespace renaming. Reviewing Views : Views are extremely useful for DBAs, developers, and users alike, but are you getting all you can out of what views have to offer? Oracle Performance Tuning – Part 3 : Part 3 of this series focuses on generating bulk data using DataFactory from Quest Software. Just SQL Part VII – Hierarchical Queries : Whether they are called hierarchical structures, trees, or self-referencing tables they often pose quite a challenge to traverse in any simple manner. But Oracle has a solution. Oracle Performance Tuning – Part 2 : There are several relatively easy steps you can take to improve performance. From the user's perspective, one of the most frequently used interfaces with a database involves SQL statements, so getting a handle on them is a good place to start, in terms of being able to see an immediate improvement. Playing With MODELs: Oracle 10g SQL Enhancements, Part 3 : Oracle 10g has extended the already robust features of Structured Query Language (SQL) with a plethora of intriguing new capabilities. This article – the final in this series – reviews the new features that Oracle 10g provides for advanced data modeling and inter-row calculations via the new MODEL clause. Just SQL Part VI – Two Famous Pseudocolumns : A pseudocolumn is a column that looks like a column but really is not a column. What?! Stick around and find out what a pseudocolumn really is. James Koopmann explores two popular pseudocolumns, ROWID and ROWNUM, and their use. Oracle Performance Tuning – Part 1 : Oracle's Tuning Methodology changed when Oracle 9i was released. The approach went from top-down in 8i to that of following principles in 9i/10g. Neither methodology is absolute as each has its advantages and disadvantages. Read on to learn more. Just SQL Part V – Counting with SQL : How many do I have? Do I have at least one? What is the greatest? What is the least? Give me the top 5 rows. These are just some of the types of questions that are often asked when trying to evaluate table data. This article explores how to translate these counting questions into SQL statements. Data Densification, Demystified: Oracle 10g SQL Enhancements, Part 2 : Oracle 10g extends many of the already robust features of Structured Query Language (SQL). This article the first of a series illustrates some of the more intriguing new features of SQL within Oracle, including upgrades to the MERGE command, enhancements to hierarchical query capabilities, and improvements to query and access methods for nested tables. Database Modeling Using Visio : One of Visio's key features is its ability to reverse engineer a database. Part 2 of this series looks at doing exactly that, using the sample schemas Oracle provides. Just SQL Part IV – Joining Tables : As your database grows so will the need to get information from more than one table. This article shows you the different join options and offers some simple examples to raise your familiarity. Making the Case for CASE Tools : Many DBAs find themselves working with someone else's database design. Unless you are involved with building or designing a new application or database from scratch, when else would you have the opportunity to use a CASE tool? One of the points to take away from having read this article is that a CASE tool can also be used after the fact. CASE tools are an invaluable resource for a DBA and knowing how to use one (or more) of them can make your job easier. Just SQL Part III – Where is it? : We do not always want to SELECT everything from a table. The matter of finding the information required is a function of implementing the optional WHERE clause of the SELECT statement. Strong SQL Made Even Stronger: Oracle 10g SQL Enhancements, Part 1 : Oracle 10g extends many of the already robust features of Structured Query Language (SQL). This article the first of a series illustrates some of the more intriguing new features of SQL within Oracle, including upgrades to the MERGE command, enhancements to hierarchical query capabilities, and improvements to query and access methods for nested tables. Oracle on the Web Part 5 – More on HTML DB : The final part of this series looks at some free resources for HTML DB, include training documentation, blogs and news feeds, a free workspace (hosted by Oracle), and a user forum. Just SQL Part II – The Simple SELECT : At the core of most queries is an underlying table structure. Part II of this series discusses how we can issue the most basic of SELECT statements to extract information from a database table. Where Did Oracle Come From? : Often times, we take for granted the functions an RDBMS performs. But where, exactly, did the concept of the relational model come from? Read on to learn the origins of the RDBMS model in general and where and how Oracle came into being. Just SQL Part I : How many of you have asked yourself what is SQL all about? Join James Koopmann as he ventures down the road of understanding SQL and how to take advantage of the language. Oracle 10g PL/SQL Enhancements, Part 2: Utility Players : Oracle 10g has added over fifty new PL/SQL packages and enhanced many of the existing packages, thus expanding the Oracle DBA's toolkit once again. New capabilities include the ability to transfer files between servers, more robust e-mail features, improved compilation utilities, and character conversion utilities. This article - the final one in this series - delves into several new features presented in new and improved versions of Oracle's utility modules and illustrates their usefulness in some real-world situations. Oracle on the Web, Part 4 – Upgrading HTML DB : Hidden away in the depths of your Oracle installation is a valuable resource you can use to get a jump-start on learning how to combine Oracle's strength as a relational database management system and the power of the Internet. Part 4 of this series covers the steps of upgrading to version 1.6 and creating a simple Web service. Education and certification programs for Oracle's database, tools, and applications products. IT training for Cisco, Microsoft, Sun Solaris, Oracle DBA, and Java programming topics. Learn more about Oracle certification at Education Online Search. Search our Oracle exam guides. Oracle9i DBA Certification Boot Camps - $40 includes Oracle 10g. Stimulate your Oracle training with extremely realistic Transcender exams. The Training Camp offers Oracle DBA certification training camps for networking. Increase your earning power. TechSkills' flexible, self-paced Oracle training. Complete oracle DBA certification training package. 24/7 Oracle, DB2, SQL support. A flexible answer to database needs. OCP: Oracle Certification - Ensure your success in OCP (Oracle certification) exam. Get information and links for Oracle certification tracks, including exam preparation, books, practice tests, and links. ... Guide to Oracle Certification. Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Training BootCamp Exam Questions. training tools for Oracle exams are your ticket to certification success. Oracle study guides, exam questions, Oracle prep materials. Try our Oracle ... will prepare you for the questions asked when seeking your Oracle Certification. code, utilities and a user forum. Covers Oracle 8i, 9i and 10G. ... Oracle Certification. Forums. Blog. Blog Aggregator. Industry News. Book Store. Questions and answers about the available Oracle Certification Exams and Tests. ... What official Oracle certification tracks are available? Oracle Certification Training BootCamp Exam Questions ... training tools for Oracle exams are your ticket to certification success. Oracle Braindumps for Certification Training at Blue Braindumps ... Prepare for your Oracle certification today! ... part of more than one Oracle certification. ORACLE DBA Certification Exam - Book Page. ... Oracle Exam & Certification Page. Oracle Certified Professional/DBA .Oracle Certification Training Boot Camp Classes and Courses on Videos and CDS. Learn Oracle with our training curriculum for 8i and 9i for Administration and Developer. Pass Oracle certification exam in first attempt. ... The Oracle Certified Professional (OCP) certification is given by one of the. Oracle Architecture. Startup and Shutdown Instance. Create a Database. Access and Update Data ... Oracle and Oracle Certification Training. Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Assisting Oracle customers and professionals by providing technical discussion, an integrated Oracle directory, job postings, news, and much more. A student entering the Oracle Certification Program must start with this course. ... prepared to take the Oracle Certification exam for the completed track. Oracle Certification Training for Oracle exams buy Exact Questions. Gauranteed Certification with 100% Exact Questions. New Oracle certification being offered. Oracle Training Videos and CD-ROMS Certification... Cisco,Unix,MCSE,Linux, Certification ... The complete Oracle Certification for 8 Certified Database Administration. A View of Creating an Oracle User - Part II : After an Oracle user has been created and schema objects have been built, best practices dictate that you should not run your applications as the schema owner. Here is a shell procedure and methodology to assist you in maintaining this segregation of application user from database schema owner. Oracle on the Web - Part 3 - Using Applications in HTML DB : Continuing our series on Oracle 10g's HTTP Server and HTML DB, part two looks at how the HTTP server has changed with respect to how you get it and how you use it. Part of the process is very easy, and other parts are somewhat confusing. If you were hoping for a clean, "one CD type of install and there it is" situation, the result is a mixed bag. A View of Creating an Oracle User - Part I : Before any schema objects can be created, you must first create a user that will own these objects. This somewhat simple procedure is often overlooked and it can open wide holes in security and portability. Oracle 10g PL/SQL Enhancements, Part 1: DBMS_CRYPTO, DBMS_MONITOR, and DBMS_SERVER_ALERT : With the addition of over fifty new PL/SQL packages as well as enhancements to a majority of existing DBMS packages, Oracle 10g has added a plethora of new tools to every Oracle DBA's tool belt. This article - the first is a series -- explores some of the more intriguing packages and illustrates their usefulness in real-world situations. Oracle on the Web, Part 2 – Oracle 10g's HTTP Server and HTML DB : Continuing our series on Oracle 10g's HTTP Server and HTML DB, part two looks at how the HTTP server has changed with respect to how you get it and how you use it. Part of the process is very easy, and other parts are somewhat confusing. If you were hoping for a clean, "one CD type of install and there it is" situation, the result is a mixed bag. The Globalization of Language in Oracle - Index Requirements : James Koopmann takes a look at indexing requirements when using NLS_SORT <> BINARY and an ORDER BY clause. Using LogMiner - Part 2 - Striking Out : Steve Callan investigates a scenario in which LogMiner may or may not be able to recover data lost through user error. Oracle and Regular Expressions : UNIX comes to Oracle in the form of regular expressions to increase the power of searching. Oracle 10g DataPump, Part 2: Implementation : Oracle 10g's new DataPump is designed as the eventual replacement for the Oracle Import and Export utilities. This article - the second and final in this series - focuses on using the DataPump's features in real-world scenarios, including creation of custom DataPump jobs with DBMS_DATAPUMP. The Globalization of Language in Oracle - And Case-Insensitivity : Learn how to take advantage of globalization techniques to perform case insensitivity in Oracle. Oracle on the Web Part 1 - Exploring Oracle's HTTP Server : Hidden away in the depths of your Oracle installation is a valuable resource you can use to get a jump-start on learning how to combine Oracle's strength as a relational database management system and the power of the Internet. Join Steve Callan as he delves into the Oracle HTTP Server (OHS). The Globalization of Language in Oracle - The NLS_LANG variable : James Koopmann zeros in on the most important variable for implementing a global database in Oracle and some lessons learned. Automatic SQL Tuning using SQL Tuning Advisor : Oracle Database 10g introduces many useful and easy-to-use tuning tools and methodologies. In this article, we will examine one of these new and improved features - SQL Tuning Advisor. Oracle 10g DataPump, Part 1: Overview : Oracle 10g's new DataPump utility is designed as the eventual replacement for the original Oracle Import and Export utilities. This article - the first in a series - provides an overview of the DataPump's suite of tools for extracting, transforming, and loading data within an Oracle database. Doing Data Guard - Part 2 : Part two of this series picks up with step-by-step coverage of preparing your environment for Data Guard. The Globalization of Language in Oracle - The NLS_COMP and NLS_SORT variables : How does Oracle compare and sort data. There is more to it than meets the eye. Collecting Real Time Wait Events : There are two common ways of collecting wait event information: the Oracle extended trace (10046 event) and using V$ views. Learn how to collect wait event information using V$ views. Oracle and Pro*C - Part 1 : Pro*C is another one of those tools or features from Oracle that keeps a low profile, quietly waiting its turn for you to use it when the need arises. Learn where to get Pro*C, and how to configure the environment. The Globalization of Language in Oracle - National Language Support : The previous article of this series looked at external terminology around globalization. This article covers the internal parameters that we will need to become familiar with. Oracle 10g Availability Enhancements, Part 4: LogMiner and Data Guard : Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article - part three of a series - concentrates on the expanded capabilities of the logical Flashback command set. Connecting with Oracle - Ensuring Sufficient Privileges : Be honest now, how many times have you encountered the ORA-01031 error? Without a deeper understanding of the "how do I authenticate thee, let me count the ways?" relationship between the operating system and Oracle, you are doomed to encounter this error time and time again. The Globalization of Language in Oracle - Terminology : With today's exploding world economy, multi-national communication is essential. Databases must not only store different character sets but also present information in a comfortable format and order for individuals from every locale. This series explores how to globalize your databases and communicate effectively across the globe. Collecting Oracle Extended Trace (10046 event) : The most importing thing in collecting trace data is collecting properly scoped data. Learn the pitfalls of doing it wrong and the rewards of doing it right. Doing Data Guard - Part 1 : Oracle Data Guard is a very useful tool to help maintain high availability and to protect your data. It is not uncommon to see 'must have experience with RAC and Data Guard' in job postings. The purpose of this series is to give you a little push to get up and running with Data Guard. Oracle Session Tracing Part VI : Part six of this series discribes how to access and generate reports off of the trace files we generated in Part five, through the use of the TKPROF and trcsess utilities. Oracle 10g Availability Enhancements, Part 3: FLASHBACK Enhancements : Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article - part three of a series - concentrates on the expanded capabilities of the logical Flashback command set. Database Benchmarking : Steve Callan introduces you to what the benchmark tests are, who controls or regulates them, and shows how Oracle compares to other database systems. Oracle Session Tracing Part V : Part five of this series will re-acquaint you with Oracle's tracing mechanism. Read on to learn about creating trace files for TKPROF. Describing Oracle Syntax : Steve Callan offers a brief history on Oracle's syntax. Oracle Session Tracing Part IV : Part 3 of this series examined how to enable tracing of statistics through the DBMS_MONITOR package. This installment focuses on determining which internal Oracle views hold the information to our enabled statistical gathering. Oracle 10g Availability Enhancements, Part 2: Flashback Database : Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article - part two of a series - explores one of the most intriguing new features of Oracle 10g: Flashback Backup and Recovery. Oracle Migration Workbench - Part 5 : Part five of this series looks at issues related to the SQL Server to Oracle migration process. Oracle Session Tracing Part III : Explore how to enable and disable Oracle tracing with the DBMS_MONITOR package in 10g. Oracle Migration Workbench - Part 4 : Part four of this series goes into more detail about SQL Server and how it compares to Oracle. This part of the series also covers the setup and preparation to use Oracle Migration Workbench to migrate the Northwind database from SQL Server to Oracle. Making a Connection from Oracle to SQL Server : SQL Server is gaining popularity and there are many shops that I know of that have this database system within their walls. Learn how to make a connection from Oracle to SQL Server using Oracles heterogeneous Services ODBC agent. Oracle Session Tracing Part II : Part two of this series shows how to set two more very important session environment variables to make tracing more effective. Read on and learn how to set the module and action names. Oracle 10g Availability Enhancements, Part 1: Backup and Recovery Improvements : Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, especially in the arena of disaster recovery. This article - the first in a series - concentrates on several new features available for backup, restoration, and recovery of Oracle databases, especially when using Oracle Recovery Manager (RMAN). Oracle Migration Workbench – Part Three : The end of Part Two of this series, finished with loading data from the MySQL database into the Oracle database/repository. Part Three will go into more detail about the Migration Workbench console and learn how to configure some options. Oracle Session Tracing Part I : This is the first in a series introducing some of the new tracing concepts and options within Oracle. This installment focuses on the new CLIENT_IDENTIFIER environment variable that can be assigned to sessions. Oracle Migration Workbench - Part Two : At the end of Part One, we were at the point where MySQL was ready to be installed. In part two of this series, we will go through some quick setup steps, create a user with some privileges, and load data - using several methods - into a MySQL database. Once the setup of the MySQL database is complete, we will be ready to start using Migration Workbench. Clustering for Indexes : Indexes hold the key for speed when accessing data. To ensure that you are getting to the data as fast as possible you should check to make sure the clustering is suitable for the query type. The Oracle 10g Scheduler, Part 3: Advanced Features : Oracle 10g's new DBMS_SCHEDULER package offers significant advanced features over its predecessor, DBMS_JOB, that any reasonably skilled Oracle DBA can use to insure that sufficient resources will always be available for processing complex business requirements. This article - the final in a three-part series - provides some practical examples of how the new Scheduler can help a DBA to manage and overcome these challenges. Oracle Migration Workbench - Part 1 : By the end of this series, not only will you be familiar with two other widely used and popular database systems, but you will also know how to migrate data from these systems into an Oracle database. Sending e-mail from within Oracle : Sending e-mail from within Oracle can be of great benefit. This article gives you a quick start at sending simple e- mails. Oracle Response Files – Part 2 : Part One of Oracle Response Files covered the basics of using a response file and provided an example of how to install Developer Suite on a Windows PC. In Part Two, we will go into more detail about the components of response files. This part will also discuss some related topics as they pertain to the Oracle Universal Installer and some Windows-analogous installation concepts. Oracle 10g's Undo Advisor : Oracle 10g simplifies the creation of undo records with Undo Advisor. Installation Cookbooks: Deploying Reports on the Web : Last week we discussed making the move from the client-server model of Forms to the 9i/10g Application Server Web-based architecture. This week Steve Callan covers the steps to use Reports-related built-in's in your forms, how to "tell" your forms the name of your report server, how to toss in some JavaScript so an "Exit" button will exit a form and close the browser window, and how to use and configure the in-process report server. The Oracle 10g Scheduler, Part 2: Implementation : Oracle 10g's new DBMS_SCHEDULER package offers significant improvements over DBMS_JOB for scheduling jobs and tasks. This article – the second in a series – provides practical examples of using the Oracle Scheduler's new functionalities, including a discussion of transitioning from DBMS_JOB to DBMS_SCHEDULER. Installation Cookbooks: Deploying Forms on the Web : This installment of the Installation Cookbooks series lays out a deployment framework to address the 'now that I have these things installed, what do I do next?' questions that are appearing with greater frequency on Oracle-related websites, including Oracle's own MetaLink site. DBA Call to Action: Get up and GO : If you aren't moving you will never go anywhere. It is time to dust off your DBA shoes, and start thinking about your future. Oracle Response Files – Part 1 : Oracle's response files can be harnessed and used to your advantage. Learn how to use this untapped resource that can save you time and standardize installation of your Oracle products. Oracle's SPFILE - Part 2 : In part two of this series, Amar Padhi examines practical example of working with the SPFILE. Automate the Sizing of your SGA in Oracle 10g : There are plenty of options available for tweaking the SGA. However, without a complete understanding of what our applications are doing in the background, our ability to guess the appropriate amount of memory to give each of these individual components is not always optimal. Oracle now has methods to determine most of the major parameters all on its own. The Oracle 10g Scheduler, Part 1: Overview : Oracle 10g's new DBMS_SCHEDULER package offers significant improvements over DBMS_JOB for scheduling jobs and tasks. This article - the first in a series - provides an overview of the new functionalities that the Oracle Scheduler provides for DBAs. Connecting with Oracle: The Password Game : Steve Callan reviews the use of Oracle's internal password function and the use of a SQL script for verifying password complexity. Oracle 10g's Redo Logfile Sizing Advisor : Improperly sized redo logs can impede the performance of your database and hamper recovery time in the event of a database crash. Oracle has given us yet another advisory that helps us to properly size redo logs, taking yet another tedious task from us. Oracle Administration - Part 2 : Part one of this series covered some important aspects of Oracle administration (MetaLink and licensing). Part two of this mini-series highlights the Oracle PartnerNetwork (OPN) and Oracle sales/reselling. Oracle's SPFILE - Part 1 : Server Parameter File (SPFILE) is an extension of the initialization parameter storage mechanism, which allows some additional advantages as compared to the simple text based init.ora file. Learn which parameters can be dynamically modified to affect the present instance, and which require the instance to be brought down so that changes can take affect. Introduction to Oracle 10g's New SQLAccess Advisor : If you have ever had a difficult time tuning applications because you can never find the SQL or code behind these applications, Oracle 10g's new SQLAccess Advisor, a new tool from Oracle, is a must. Oracle Administration - Part 1 : This two-part series provides an overview of Oracle administration, including the use and licensing of Oracle's software. True Session Wait Activity in Oracle 10g : Catching a session waiting on a resource used to be hit or miss. James Koopmann examines how Oracle 10g expedites this process. Introduction to Oracle 10g's New SQL Tuning Advisor : Join James Koopmann to learn how Oracle has helped us to alleviate the pain associated with tuning SQL. Watching SQL Execute on Oracle – Part II : Do you have SQL running within your database? Of course you do. This article is the second in a series introducing how to extract more information about the SQL that is executing in your Oracle databases. Watching SQL Execute on Oracle – Part I : Do you have SQL running within your database? Of course you do. This article, first in a series, introduces a method of finding information about the SQL your users are executing in your Oracle databases. Instant Client in Oracle 10g : Wouldn't it be nice if you didn't have to install the full Oracle client software just to get connectivity to an Oracle instance? Well, it's now reality with Oracle's new Instant Client software offering. Executing External Programs From Within Oracle : Finally, Oracle 10g has given us the ability to execute external programs from within Oracle. James Koopmann takes a look at what needs to be done to expose this new feature. Oracle's Sample Schemas: Saying Goodbye to Scott : Did you know that Oracle's "Scott" schema is slated for the bone yard? How many thousands of people have learned SQL, SQL*Plus, and PL/SQL on the back of poor old Scott? Steve Callan introduces the new 'crew'--HR, OE, PM, QS and SH. New Features in Oracle 10g for SQL*Plus and iSQL*Plus : Don't wait for your shop to get an Oracle 10g database up and running. Download the client software and start using these great new features! Decrypting Oracle's DBMS_OBFUSCATION_TOOLKIT : To secure sensitive data, Oracle provides developers with the DBMS_OBFUSCATION_TOOLKIT, an industrial strength version of the DBMS_RANDOM package. You may feel the need of a decoder just to keep track of all the acronyms and to decrypt the errors in Oracle's sample code, but once you see how easy it is to use, you'll be able to take Oracle's code example and modify it for your own use. Connecting with Oracle: Accessing Oracle via Access and Excel : Giving your users the ability to access an Oracle database using either Access or Excel is easy to do. It takes all of three minutes to set up the link or connection. Learn how in Connecting with Oracle, Part 4. Multiple Temporary Tablespaces in Oracle10g : The creation and use of temporary tablespaces has just taken another leap in performance and manageability, which should make us all re-think how we have created and assigned our users to temporary tablespaces. Education and certification programs for Oracle's database, tools, and applications products. IT training for Cisco, Microsoft, Sun Solaris, Oracle DBA, and Java programming topics. Learn more about Oracle certification at Education Online Search. Search our Oracle exam guides. Oracle9i DBA Certification Boot Camps - $40 includes Oracle 10g. Stimulate your Oracle training with extremely realistic Transcender exams. The Training Camp offers Oracle DBA certification training camps for networking. Increase your earning power. TechSkills' flexible, self-paced Oracle training. Complete oracle DBA certification training package. 24/7 Oracle, DB2, SQL support. A flexible answer to database needs. OCP: Oracle Certification - Ensure your success in OCP (Oracle certification) exam. Get information and links for Oracle certification tracks, including exam preparation, books, practice tests, and links. ... Guide to Oracle Certification. Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Training BootCamp Exam Questions. training tools for Oracle exams are your ticket to certification success. Oracle study guides, exam questions, Oracle prep materials. Try our Oracle ... will prepare you for the questions asked when seeking your Oracle Certification. code, utilities and a user forum. Covers Oracle 8i, 9i and 10G. ... Oracle Certification. Forums. Blog. Blog Aggregator. Industry News. Book Store. Questions and answers about the available Oracle Certification Exams and Tests. ... What official Oracle certification tracks are available? Oracle Certification Training BootCamp Exam Questions ... training tools for Oracle exams are your ticket to certification success. Oracle Braindumps for Certification Training at Blue Braindumps ... Prepare for your Oracle certification today! ... part of more than one Oracle certification. ORACLE DBA Certification Exam - Book Page. ... Oracle Exam & Certification Page. Oracle Certified Professional/DBA .Oracle Certification Training Boot Camp Classes and Courses on Videos and CDS. Learn Oracle with our training curriculum for 8i and 9i for Administration and Developer. Pass Oracle certification exam in first attempt. ... The Oracle Certified Professional (OCP) certification is given by one of the. Oracle Architecture. Startup and Shutdown Instance. Create a Database. Access and Update Data ... Oracle and Oracle Certification Training. Oracle8i training from Oracle experts who have real-life experience using Oracle Database products. We can train you for Oracle's certification exams: Oracle10g, Oracle9i. Assisting Oracle customers and professionals by providing technical discussion, an integrated Oracle directory, job postings, news, and much more. A student entering the Oracle Certification Program must start with this course. ... prepared to take the Oracle Certification exam for the completed track. Oracle Certification Training for Oracle exams buy Exact Questions. Gauranteed Certification with 100% Exact Questions. New Oracle certification being offered. Oracle Training Videos and CD-ROMS Certification... Cisco,Unix,MCSE,Linux, Certification ... The complete Oracle Certification for 8 Certified Database Administration. Transferring Operating System Files from within Oracle : As new versions of Oracle are released, we are less likely to access the operating system. The ability to move data files from within Oracle is just one more great hook to the operating system that aids DBAs in their daily tasks. Connecting with Oracle: Oracle Ports : 1521. 1810. 2481. 7778. These are just a few of the port numbers Oracle uses in networking. Everyone knows 1521 is the typical port number used by a listener, but how sacrosanct is that? This article will help clarify some facts about port usage related to Oracle. Installation Cookbook: Installing Oracle Application Server 10g (9.0.4)Forms and Reports Services : Support for versions older than Oracle 9i is coming to an end--users wanting to view data in a database via forms will have to move to Oracle 9i/10g forms. The big show stopper on that process is that you need to have Application Server installed and running to view 9i/10g forms on the web. Learn how to install Application Server and make the connection to your databases. Connecting with Oracle: Finding and Setting a Configuration File Location : You can have a 'good' tnsnames.ora file, but 'reject' its use due to not knowing where it is. You can have a 'bad' tnsnames.ora file in a location you know about, and try to 'accept' its use. Both situations are bad. Fortunately, each is easy to correct. Learn how to set a location for your tnsnames.ora file and where to look for that location. Connecting with Oracle : Steve Callan discusses a common error frequently seen in Oracle Net Services. Learn how to avoid the "ORA-12154: TNS: could not resolve service name" error. Product Review: Thomson Course Technology's Oracle9i Database Performance Tuning : When it comes to IT training, how do you want to spend your hard-earned dollars? There are plenty of options, approaches, and vendors to choose from, so it helps if you have a specific or somewhat focused goal in mind before spending your money. Steve Callan begins his product review series with a look at Thomson's course on performance tuning. Virtual Indexes in Oracle : Oracle's Virtual Indexes have a specific purpose and do not behave like normal indexes. Learn how to create and use these pseudo-indexes. Transitioning to Locally-Managed Tablespaces : Oracle 8.1.6 offered a new format for tablespace storage management – locally-managed tablespaces – that offers significant improvements in tablespace performance and free space management. Oracle 9i Release 2 improved upon segment storage in locally-managed tablespaces with the Automatic Segment Storage Management option. This article delves into the advantages of using locally-managed tablespaces over dictionary-managed tablespaces and suggests practical methods to achieve the transition. Inserting Custom Messages in Oracle Alert/Trace files : Learn how to insert your own customized message into alert log and/or trace files. Oracle's Wrap Utility : With Oracle's wrap utility, you can turn the inner workings of your code into an impenetrable black box, for the most part, to protect your property. Learn how in this article from Steve Callan. Bulk Binds and Collects in PL/SQL - Part 2 : Part 2 of this series continues a discussion of how to work with collections. This installment covers avoiding performance issues when retreiving immense amounts of data in PL/SQL collections. Oracle Performance Tuning - (Otherwise Known as Drowning in a Pool of Confusion) : Steve Callan offers recommendations on two excellent books that plainly and effectively tell you what to look for, and more importantly, how to fix a poorly performing system. Oracle on Windows - Part 3 : Microsoft and Oracle issue strong advisories against manually editing the Windows registry, yet both of them tell you how to do just that. If you have been reluctant to edit your registry because of the horror stories you have heard, then this article will help you overcome some of that trepidation. Using Cursor Variables As Function Arguments on Oracle 9i : Oracle 9i offers the ability to pass data to a PL/SQL function in the form of a cursor variable. When this feature is paired with the concept of the table function, the resulting PL/SQL code increases significantly in flexibility and scalability. This article builds upon the author's previous article on table functions and provides a brief technical explanation of how best to implement this feature. Bulk Binds and Collects in PL/SQL - Part - 1 : This article begins a discussion of how to work with collections. Previous versions of Oracle had limitations for collection usage in regards to SQL statement processing. Bulk Bind and Collect features were introduced to reduce the SQL processing overhead by efficient use of collections in PL/SQL code. Striking Gold with LogMiner - Part 1: Getting Started : Oracle's LogMiner utility has been around for several years now, and it originally appeared as a new feature (as opposed to being an improvement of something else). The purpose of this series is to help demystify some of the procedures, illustrate some examples of using LogMiner, and to recommend cases where LogMiner should be a DBA's primary tool for recovering lost data. Creating NOT NULL Columns in Huge Oracle Tables : Databases are often taxed by applying SQL statements to enormous tables. One such activity is when we add a new NOT NULL column with default value to a huge transaction table. Amar Padhi shares several methods to add a new column with default value, comparing the advantages and disadvantages of each. Surviving a Database Disaster with RMAN Backups : Follow along with this real-world disaster scenario and learn how one company recovered their databases using RMAN backups. Decrypting Oracle's DBMS_OBFUSCATION_TOOLKIT : To secure sensitive data, Oracle provides developers with the DBMS_OBFUSCATION_TOOLKIT, an industrial strength version of the DBMS_RANDOM package. You may feel the need of a decoder just to keep track of all the acronyms and to decrypt the errors in Oracle's sample code, but once you see how easy it is to use, you'll be able to take Oracle's code example and modify it for your own use. Connecting with Oracle: Accessing Oracle via Access and Excel : Giving your users the ability to access an Oracle database using either Access or Excel is easy to do. It takes all of three minutes to set up the link or connection. Learn how in Connecting with Oracle, Part 4. Generating random numbers and strings in Oracle : Generating random numbers or strings is oft-times a necessity. Oracle provides a random number generator that is faster than writing your won random generation logic in PL/SQL, and can generate both character and alphanumeric strings. Perhaps it is time to learn more about the DBMS_RANDOM package. CASTing About For a Solution: Using CAST and Table Functions in PL/SQL : Oracle 8i offered the CAST function, which allows a PL/SQL collection to be processed as if it was a normal table. When CAST is paired with table functions, it becomes even more powerful as a data manipulation toolset. This article provides a brief technical explanation of CAST and table functions as well as some practical, real-world examples of their use in concert. A Practical Guide to Data Warehousing in Oracle, Part 6 : Materialized Views are continually enhanced by Oracle to leverage data warehouse performance and maintainability. This is the first in a mini-series of articles that will introduce the concept, identify some of their uses and describe some potential problems with them. Multiple Temporary Tablespaces in Oracle 10g : The creation and use of temporary tablespaces has just taken another leap in performance and manageability, which should make us all re-think how we have created and assigned our users to temporary tablespaces. So You Want to Become an Oracle DBA? Part 2 - Learning Oracle on your own : The second half of this two-part series on how to become an Oracle DBA in today's almost non-existent DBA job market focuses on inexpensive and effective means of learning Oracle. Oracle Background Processes : With every release of Oracle, background processes have been added or modified. Amar Kumar Padhi takes an in-depth look at these processes that are key to the proper working of the database. Transferring Operating System Files from within Oracle : As new versions of Oracle are released, we are less likely to access the operating system. The ability to move data files from within Oracle is just one more great hook to the operating system that aids DBAs in their daily tasks. A Practical Guide to Data Warehousing in Oracle, Part 5 : Why can a data warehouse be operated successfully and safely without integrity being enforced at the database level? Learn about creating lightweight declarative integrity constraints that avoid much of the unwelcome overhead of maintaining enforced constraints. Oracle's CASE Expression : Faster than a speeding bullet, more powerful than a locomotive... Perhaps not, but Oracle's CASE expression can do all that the DECODE function does, plus a whole lot more. Unwrapping Oracle's DBMS Packages: Understanding Oracle's Random Number Generator : Beginning with later versions of Oracle8, Oracle has provided a means of generating random numbers. This built-in package, DBMS_RANDOM, is fairly simple to use, and can generate random numbers which are generally good enough for the needs of most users. Learn more as Steve Callan unwraps the first DBMS package of this series. Parsing in Oracle : Amar Kumar Padhi discusses the process of parsing, the difference between soft and hard processing, how Oracle deals with identical statements and various methods to reduce hard parsing. Don't Just Do Something, Stand There! Avoiding Junior DBA Mistakes : When an Oracle database suddenly becomes unavailable, the immediate reaction is to do something -- right now! -- to solve the problem, which sometimes makes the problem worse. This article discusses some examples of when it's really best to stop and think before proceeding. Data Modeling, Breaking & Fixing First Normal Form (1NF) : Call by Reference Parameters in PL/SQL (The NOCOPY Hint) The inability to conform to the very basics of data modeling principles often causes enormous problems for data modelers, administrators and the development chain. Of those principles, adhering to 1NF is probably the most broken rule. When the model does not follow 1NF, queries are hard to develop and producing usable data from the model is even harder. This article explores some of the common mistakes and their fixes. Connecting with Oracle: Oracle Ports : 1521. 1810. 2481. 7778. These are just a few of the port numbers Oracle uses in networking. Everyone knows 1521 is the typical port number used by a listener, but how sacrosanct is that? This article will help clarify some facts about port usage related to Oracle. So You Want to Become an Oracle DBA? Part 1 – Getting Close to Oracle : This is the first of a two-part series about how you can become an Oracle DBA in today's almost non-existent DBA job market. Working with VARRAYs in Oracle Part III : The third and final installment of this series examines the performance implications of using VARRAYS. Practical Data Warehousing in Oracle, Part 4 : On a regular OLTP system, one of the perennial sources for doubt and debate is the number, type and configuration of indexes. Dave Aldridge shares some simple principles that can be applied to the business of indexing a data warehouse. Oracle on Windows - Part 2 : Oracle on Windows is easy to use, and even easier to use if you have a good understanding of how the Windows operating system works. With Oracle's new pricing scheme aimed at enticing small businesses to make the switch from the SQL Server arena, you almost cannot afford not to know more about the Oracle and Windows combination. The Mutation error in Oracle Database Triggers : Amar Kumar Padhi discusses the causes of the mutating table error and how to prevent it. Oracle Database Resource Manager, Part 3: Conclusion : Oracle Database Resource Management (DRM) provides tools that allow any Oracle DBA to manage a database server's CPU resources effectively for application user groups and during different resource demand periods. This final article builds upon the concepts in the two previous articles, including the construction of more complex resource plans, monitoring DRM utilization, and general DRM maintenance. Using Oracle's SQL Functions - Part 2 : The second article of this series looks at 11 SQL-related functions commonly used in statistics: count, sum, average, standard deviation, variance and covariance (standard deviation and variance have three each; covariance has two). Working with VARRAYs in Oracle - Part II : Part two of this three part series takes you through the steps on how to abstract the difficulty from using VARRAYs so that developers or end uses can interact with these structures through familiar table insert and select statements. Installation Cookbook: Installing Oracle Application Server 10g (9.0.4)Forms and Reports Services : Support for versions older than Oracle 9i is coming to an end--users wanting to view data in a database via forms will have to move to Oracle 9i/10g forms. The big show stopper on that process is that you need to have Application Server installed and running to view 9i/10g forms on the web. Learn how to install Application Server and make the connection to your databases. Use Oracle's DBMS_APPLICATION_INFO to Prevent Routines from Running Simultaneously : Learn how to use Oracle's DBMS_APPLICATION_INFO to prevent two routines or business processes from running at the same time. Working with VARRAYs in Oracle Part I : James Koopmann presents a three part series designed to take you through the process of creating VARRAYs and dealing with them in Oracle tables. Using Oracle's SQL Functions : Oracle provides quite an array of functions when it comes to manipulating data via SQL. Of particular interest for this new series, are the functions related to numbers. Learn how this relates to your job as a DBA. A Practical Guide to Data Warehousing in Oracle - Part 3 : There are three major advantages of partitioning. Learn what they are in part 3 of A Practical Guide to Data Warehousing in Oracle. Locking Down SQL*Plus Security : Is your data at risk? Users with valid database username/password combos can log into a database from SQL*Plus and view or edit critical data not accessible from an application itself. The question is, how do you prevent users from accessing data via SQL*Plus? Learn how to insert restrictions in the PRODUCT_USER_PROFILE (PUP) table, owned by the SYSTEM user. Oracle Database Resource Manager, Part 2: Resource Plan Management : Oracle Database Resource Management (DRM) provides tools that allow any Oracle DBA to manage a database server's CPU resources effectively for application user groups and during different resource demand periods. This article builds upon the concepts in Part 1 to build and maintain more complex resource plans, assign users to resource consumer groups, and manage users and session utilization of DRM resources. DBA Call to Action: Zeroing in on Performance Problems : Have you ever been asked to help with the evaluation of a database that is not performing optimally? Here is a quick guide to help you if you just do not know where to start. Installation Cookbooks: Installing Oracle9i Developer Suite : Most people can muddle through Oracle product installations on their first one or two attempts. But what happens when you run into the occasional lemon-like installation guide, such as the one for Oracle9i Developer Suite (iDS)? Steve Callan offers a detailed, step-by-step installation cookbook for installing Oracle9i Developer Suite (9.0.2, including a patch) on a Sun Solaris platform. DDL Event Security in Oracle Database : Secure your Oracle database against structural or Data Definition Language (DDL) changes. Storing Word Documents in Oracle : Have you ever wondered about storing documents in your Oracle database but didn't know where to start? Here is a quick introduction to the basics you need to know. Oracle on Windows : Why should you use Oracle on Windows or even bother to learn about it? One reason is, if you change jobs often enough or develop enough applications, sooner or later, you're dealing with Oracle on Windows. Oracle A Practical Guide to Data Warehousing in Oracle, Part 2 : Part 2 of 'A Practical Guide to Data Warehousing' examines the various possible attributes of tables, and seeing what use can made of them in the different table types of a data warehouse. Oracle Optimizer: Moving to and working with CBO - Part 7 : The final installment of this series covers the basics of using Stored Outlines and Oracle Application specific information. The Trigger-Happy DBA - System Triggers : The use of system triggers can greatly expand a DBA's ability to monitor database activity and events. Join Steve Callan as he examines the creation and use of system triggers. Oracle Database Resource Manager, Part 1:Overview : Oracle Database Resource Management (DRM) provides tools that allow any Oracle DBA to manage a database server's CPU resources effectively for application user groups and during different resource demand periods. This article provides a brief overview of how DRM works and then delves into the preparations necessary to implement a simple DRM configuration. Manipulating Oracle Files with UTL_FILE : Take hold of your alert log with the use of a few new subprograms in the UTL_FILE package. Installation Cookbooks: Installing Oracle Forms & Reports 6i : More often than not, the DBA owns everything related to Oracle, whether or not the DBA has anything to do with that 'other' Oracle stuff. It's time to shake off the narrow-minded view about what a DBA does and expand your knowledge of Oracle's installation process. DBA Call to Action: New Year Resolutions : James Koopmann looks at ways to plan your New Year resolutions around your current DBA roles and responsibilities. Installation Cookbooks: Installing Oracle9i : In his new series, Installation Cookbooks, Steve Callan lays out a methodology for installing Oracle products on UNIX-based systems (primarily using Solaris). The Trigger-Happy DBA - Part 2 : What a form trigger can do, and has in common with the "pure" development type of trigger, is generate the ORA-04091 mutating table error. Learn how to work your way around this error by taking your DML elsewhere. Oracle Optimizer: Moving to and working with CBO - Part 6 : Previous installments of this series have covered how the Cost Based Optimizer works and behaves. In part 6 of the series, learn how to assist the optimizer to do its job properly. CONFIGURE This! Taking Advantage of Oracle 9i Recovery Manager (RMAN) Features During Backups : Oracle Recovery Manager (RMAN) features have been expanded significantly in Oracle 9i. This article discusses several of these new features and includes examples on how to implement them to make any Oracle DBA's backup, restoration, and disaster recovery plans more effective. Oracle Technical Interview Questions Answered – Part 2 : James Koopmann provides more answers to the questions raised in his popular article "Technical Interview Questions." Oracle Technical Interview Questions Answered – Part 1 : James Koopmann responds to readers by providing answers to the questions raised in his popular article 'Technical Interview Questions.' The Trigger-Happy DBA : Triggers can be an effective tool to manage and control data, and to enforce business rules and logic. Some of the more commonly used areas include auditing, enforcement of business rules, and behind the scenes DML-related operations. This first article in the series focuses on DML triggers. Practical Data Warehousing in Oracle, Part I : Enemy Number One--the disk subsystem. Nothing will cripple a data warehouse more effectively than a failure to manage your i/o requirement vs. your i/o capacity. Take a different look at disk capacity. Oracle Optimizer: Moving to and working with CBO - Part 5 : This month in Moving to and working with CBO, Amar Kumar Padhi examines the data skewness problem and the use of the Monitoring option for updating statistics on the fly. Oracle Label Security, Part 4: Conclusion : Oracle Label Security (OLS) offers a powerful implementation of row-based security that is perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. This concluding article wraps up this series with a discussion of some advanced OLS features as well as mechanisms for maintaining an existing OLS security policy. Oracle9iR2 Segment Level Statistics : Oracle's Segment Level Statistics gives you the power to make decisions on the configuration of structures within Oracle as well as to application code. Learn how to fine tune memory structures and access methodologies using Oracle's Segment Level Statistics. Connecting with Oracle: Finding and Setting a Configuration File Location : You can have a 'good' tnsnames.ora file, but 'reject' its use due to not knowing where it is. You can have a 'bad' tnsnames.ora file in a location you know about, and try to 'accept' its use. Both situations are bad. Fortunately, each is easy to correct. Learn how to set a location for your tnsnames.ora file and where to look for that location. Oracle9iR2 Shared Pool Advisory : Learn how to get the most out of your Oracle database using the Shared Pool Advisory. A Practical Guide to Data Warehousing in Oracle: Series Introduction : Making the mental leap from OLTP to data warehousing is a daunting prospect. This series of articles is intended to be a reference to answer both questions you have and those that you don't even suspect you need answsers to. As an introduction to the series, Dave Aldridge discusses a few high-level differences between OLTP and Data Warehousing systems. Oracle: Preventing Corruption Before it's Too Late - Part 2 : Marin Komadina discusses Oracle data-block corruption, describing several features of Oracle that may be used at an early stage to detect database corruption. Part 2 of this series explores Oracle soft and bug corruption. Oracle Optimizer: Moving to and working with CBO - Part 4 : Part 4 of the Oracle Optimizer series covers the various facilities available for generating statistics in Oracle database. Connecting with Oracle : Steve Callan discusses a common error frequently seen in Oracle Net Services. Learn how to avoid the "ORA-12154: TNS: could not resolve service name" error. Oracle Label Security, Part 3: Administration : Oracle Label Security (OLS) offers a powerful implementation of row-based security that is perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. Previous articles presented a brief overview of how these features work, and how these features can be implemented in any Oracle database. This article discusses how Oracle Label Security policies can be administered when data or users change. Oracle's Default TEMPORARY Tablespaces : Using the SYSTEM tablespace as a temporary tablespace is to be frowned upon, yet Oracle still lets us assign it as such. James Koopmann explores a better way. Oracle Technical Interview : Uncertain about the technical interview process? James Koopmann offers 65 technical questions to get you up to speed for that technical interview. Preventing Corruption Before it's Too Late: Part 1 : Marin Komadina discusses Oracle data-block corruption, describing several features of Oracle that may be used at an early stage to detect database corruption. Oracle Optimizer: Moving to and working with CBO - Part 3 : In this months installment of "Oracle Optimizer and how to move to CBO," Amar Padhi covers the Initialization parameters and Hidden or Internal Oracle parameters that influence the Optimizer in choosing execution plans. DBA Call to Action: Oracle Database Integrity : James Koopmann offers a refresher on database integrity, and why it's important. Oracle Label Security, Part 2: Implementation : Oracle Label Security (OLS) offers a powerful implementation of row-based security that is perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. A previous article presented a brief overview of how these features work; this article presents how a reasonably skilled Oracle DBA can configure a database for OLS, install an OLS security policy, implement security for users, and impose row-level security for data. Oracle Time Zone : Just when you thought you knew where you were, Oracle has implemented time zones to totally zone us out. Join James Koopmann while he figures out where on this great planet we are. A Comparison of Oracle 9i with DB2 v8.1 : Alexander Chigrik compares Oracle 9i with DB2 Universal Database v.8.1 regarding price, platforms supported, features, and product limits. What's In A Name - Naming and Idenifying Oracle Databases and Instances : Identification of the database you are currently working on can sometimes be somewhat confusing. James Koopmann examines the parameters that need to be set and at the same time explains ways of determining to which database and instance you are working and connected. Oracle Label Security, Part 1: Overview : Oracle Label Security (OLS) is a relatively new feature of Oracle 9i. It offers a powerful implementation of row- based security that's perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. This article presents a high-level view of this new set of features in preparation for implementation by any reasonably skilled Oracle DBA. Deleting Historical Data on Oracle Databases : Archiving historical database data is an important, complex and in most cases forgotten task of database projects. Marin Komadina examines the problem of deleting historical data and presents some practical tips on how to execute and check the deleting performance. ETL Prototype using Oracle Warehouse Builder – Part 3 : Nandeep Nagarkar shares his views on choosing the Oracle Warehouse Builder as a tool in an Oracle data warehouse life cycle management project, along with quick steps to get started with a simple "prototype." Oracle Optimizer: Moving to and working with CBO - Part 2 : In this months installment of 'Oracle Optimizer: Moving to and working with CBO,' Amar Padhi covers the Initialization parameters and Hidden or Internal Oracle parameters that influence the Optimizer in choosing execution plans. Tracking Data Access Patterns in Oracle : Performance in Oracle is directly related to the SQL workload that is submitted. Often it is not the change in the SQL that degrades performance but instead is the access path to that data. This article will help you understand when new access paths have been introduced in your environment. Oracle PL/SQL Built For Speed : Everyone is looking for an edge. With PL/SQL that edge is compiling the PL/SQL code into native code. James Koopmann shows you how to setup and compile your PL/SQL procedures and packages. Excel Document Management with the Oracle iFS (Internet File System) : Marin Komadina explains one of the lesser-known methods of controling information chaos using Oracle iFS. Learn how Excel documents can be securely stored and retrieved from the Oracle database using iFS. Automating ETL using Oracle warehouse Builder – OWB architecture : In part 2 of the Oracle Warehouse Builder series, Nandeep discusses the Oracle Warehouse Builder architecture, its compliance with industry standards and is technical suitability for use in DW projects. Oracle Safety Blankets: Insulating Your Applications Against Database Changes : Changes to Oracle database objects can wreak unexpected havoc on the applications that depend on them, especially when the database objects are invalidated even for a brief period. This article discusses some techniques that any DBA can put into practice to limit the impact of database object changes on dependent applications. Oracle Optimizer: Moving to and working with CBO : Learn about the Oracle Optimizer and various efficient ways of moving to Cost Based Optimizer. Part 1 of a five part series. A Comparison of Oracle's DATE and TIMESTAMP Datatypes : If you want to store date and time information in Oracle, you really only have two different options for the column's datatype. Join James Koopmann as he examines the DATE and TIMESTAMP datatypes Oh Danny Boy, The DBMS_PIPES Are Calling : Oracle pipes have been around for a long time but just how many use this powerful mechanism? James Koopmann explores this feature, reminding us all that it is not dead yet. The Road from Oracle8i to Oracle9i Certification : Follow along with James Koopmann as he travels the road from Oracle8i to Oracle 9i certification. Automating ETL using Oracle warehouse Builder – Part 1 : Prototyping is one of the best-suggested approaches in mitigating the adverse effects of unforeseen problems in the data warehouse development cycle. In this series, Nandeep Nagarkar focuses on prototyping the ETL stage of the data warehouse life cycle using Oracle WareHouse Builder. It All Depends on the CONTEXT: Using the SYS_CONTEXT Function : The SYS_CONTEXT function is the recommended replacement method for obtaining information about users and environment variables instead of the deprecated USERENV function. This versatile function has been expanded in Oracle 9i to provide a plethora of information about the Oracle database and its processes as well as its users and sessions. Understanding Oracle's Locally Managed Tablespaces : Locally Managed Tablespace (LMT), one of the key features in Oracle databases, has been available since Oracle 8i. Amar Padhi offers some scenarios of note for systems that are already using LMTs or planning to shift to LMTs. Using Oracle Locks to Manage Data Concurrency and Consistency : Ever wonder what prevents the same data from being modified by two or more users at the same time? Learn how Oracle manages data concurrency and consistency by using Locks. Returning Rows Through a Table Function in Oracle : James Koopmann introduces Oracle's Table Function. Learn how to call a table function within the FROM clause of a SQL statement and have it return a result set that mimics what we would normally expect from a traditional SQL SELECT statement. Document Management with Oracle Text : Powerful procedures for handling image, audio, video and the text data in various formats are incorporated in the Oracle database kernel code. Marin Komadina looks at the ins and outs of the feature originally known as ConText, then interMedia Text, and finally Oracle Text. Disk Sorts - A Subtle Threat to Database Performance : Disk sorts are a near-silent performance vampire that can rob a database of good response times. Intelligently diagnosing the presence of disk sorts and then doing what you can to reduce or eliminate them altogether, you can remove this subtle threat to your database's performance. Altering Oracle's SQL*Plus Help Facility : Everyone needs a little help now and then. James Koopmann finds new ways to provide information to users of SQL*Plus through the Help Facility. So You Want to Use Oracle's SPFILE : Oracle's traditional method of storing parameters in the INIT.ORA file has given way to a more robust method-- the server parameter file (SPFILE). Learn what truly works in converting and maintaining your parameters without ever having to use an editor again. Reporting Database Object Increase On Oracle : On the production Oracle system, a DBA is responsible for collecting database increase statistics. Learn how to do so easily and economincally, without changing the existing database. Using Index Hints in SQL statements - 'Cause we know more about our application than Oracle does : Hints are used to give specific information about our data and application, to Oracle. Ajay Gursahani examines Index Hints, how they can improve certain SQL statements that might otherwise be inefficient, and the advantages of doing so. Change data capture implementation in Oracle Data warehouses – Part 3 : Nandeep Nagarkar continues his series on change data capture implementation in Oracle Data warehouses. Learn about the change data capture model and how to publish subscribe to change data. Getting ANSI About Joins : The new ANSI format for joins in Oracle 9i may appear alien at first, but they have the potential to become part of a DBA's arsenal for clarifying SQL and PL/SQL code. This article discusses the new join formats including NATIVE, CROSS, and OUTER and includes examples for review and comparison to the "traditional" join mechanisms. DBA Call to Action: Make an Impact : A DBAs true value is not only to maintain database order but also to provide technical advantages to the company. Join James Koopmann as he breaks out of the cubical shell with a mission to 'make an impact.' Recovering Accidentally Lost Data Using Oracle's Flashback Query : Recent studies show that nearly 50% of system outages are due to human errors. Oracle 9i's new feature, Flashback Query allows the user to view an old image of data that has been modified and committed by the DML statement, without requiring any structural changes to the database. Manually Refreshing Materialized Views and Creating Refresh Groups in Oracle : Learn how to manually refresh materialized views and create refresh groups using Oracle supplied packages. DDL Generation--Oracle's Answer to Save You Time and Money : The days of building your own DDL extraction utilities are almost gone; Oracle has given us a simple way to generate the DDL for objects defined in the database. Join James Koopmann as he delves into DBMS_METADATA.GET_DDL. Getting control of the Oracle Java Virtual Machine : Being the master of your database means gaining control of Oracle's Java Virtual Machine. Follow along with Marin Komadina as he explains installation tricks and offers some practical JVM tips. Becoming the Master of Disaster : If a disaster happened to your database server, could you recover from it? This article discusses the questions a DBA can ask to probe the realm of what we all hate to think about - the possibility of the untimely demise of a production database server. Learn how to become a fearless 'master of disaster'. Materialized Views in Oracle : Learn how to make local copies of remotely located data & specify automatic refreshes. Database Impact of Collecting Statistics in Oracle : Oracle has given us a new parameter STATISTICS_LEVEL for collecting database statistics. James Koopmann takes a deeper look at what to expect from your database system when this parameter is set and statistics are being gathered. Get the init.ora parameter value using DBMS_UTILITY : Ajay Gursahani explains how to get the values for the parameters specified in 'init.ora' by using the GET_PARAMETER_VALUE procedure supplied with the DBMS_UTILITY package. Implications of Setting Oracle9iR2's Statistics Collection Level : Concerned about looking at statistics within Oracle? You should take a quick look at Oracles' new method of turning collections on or off. Change data capture implementation in Oracle Data warehouses - Part 2 - Oracle Streams implementation : In part-1 of the series, we discussed the overall view of Oracle Streams and the process of information sharing between databases. Part-2 of this article, presents a scenario to demonstrate a simple and "straight-forward" configuration for Oracle Streams. The comparison of SQL Server 2000 with Oracle 9i : Alexander Chigrik compares SQL Server 2000 with Oracle 9i Database regarding price, performance, platforms supported, SQL dialects and products limits. Recompiling PL/SQL Objects using DBMS_DDL package : Learn how to compile PL/SQL objects that are, already stored in the database using DBMS_DDL Oracle supplied package. Hold On There SYSter : Probably the most sacred user in all of Oracledom is the SYS user. Koopmann takes a quick look at how DBAs can take hold of this often misused account. EXECUTE IMMEDIATE option for Dynamic SQL and PL/SQL : Amar Kumar Padhi shares usage tips and examples of EXECUTE IMMEDIATE, which replaced DBMS_SQL package in Oracle 8i and above. Activating, Monitoring, and Tuning Automatic PGA Memory Management via PGA_AGGREGATE_TARGET Under Oracle 9i : Sizing the Program Global Area (PGA) is now one of many tasks made simpler under Oracle 9i. Learn how a database server utilizes the PGA, how the PGA can be automatically sized using PGA_AGGREGATE_TARGET initialization parameter, and how the PGA's size can be monitored and tuned using some new dynamic database views, now part of 9i. Protecting Oracle Instance with Local Clustering : Follow along with Marin Komadina as he explains the ins and outs of Local Clustering with Sun Cluster software. Oracle in a Nutshell: A Desktop Quick Reference : The goal of Oracle in a Nutshell is to pull together the most essential information on Oracle architecture, syntax, and user interfaces. Learn the two basic ways to access Oracle data from Java. Web Reports from SQL *Plus in Oracle 8i/9i : Learn how to build complete HTML Reports using SQL *Plus, Oracle's interactive query tool. Explain Away Your Troubles : Determining when things change in a database is the first step in zeroing in on problems. One of the prime culprits to change is the very SQL that we attempt to run every day. James Koopmann shares his no-frills method to help sniff out those changes that occur. Using Resume Operation in Oracle 9i : Learn how to suspend or resume operations using the new RESUME option in Oracle 9i DBA Call to Action: The Information Chase : A key role of every DBA is to keep up-to-date on trends within the database industry. Journey along with Koopmann as he rids his desk of endless piles of documentation and articles while still staying on top of the latest news and trends. Concerned About The (Oracle) Environment? : Jim Czuprynski offers suggestions on the perfect environment for evaluating software changes before they are run against the production Oracle database. Change Data Capture Implementation in Oracle Data Warehouses - Part 1 : In the first of this three part series, Nandeep gives an overview of Oracle Streams. Part 2 of the series will focus on a simple implementation of Oracle Streams followed by part 3, which will describe the Change Data Capture framework of Oracle. External Tables in Oracle 9i : Learn how to run any SQL query against external data without requiring that the external data first be loaded into the database. Killing the Oracle DBMS_JOB : If you've ever had a problem with a run-away job that didn't want to end, or found that you needed to shut down the database only to find it was waiting for a job to complete, Koopmann can help. Learn how to manage those jobs that don't want to end. How Grid Computing Can Improve Database Performance : Nathan Segal interviews Benny Souder, Vice President of Distributed Database Development for Oracle, and Jeff Jones of IBM. Oracle9i's Auto Segment Space Management Option : Follow along with James Koopmann and learn what you, the DBA, no longer have to manage thanks to a little feature from Oracle. Definer and Invoker Rights for stored routines in Oracle : Learn how to share procedures between users without sharing tables. Leaving the History Behind with Oracle's Fine Grained Access Control : Marin Komadina explains how to export tables from a user schema--without having to export the history tables as well. That Darn Alert Log : Until Oracle decides to give DBAs built-in direct access to the alert log, it will always be our responsibility to continually check and maintain it. Here is a simple solution that will help with this most basic of DBA task. Exploring the use of Directory Objects in Oracle 9i : Nandeep explores the advantages of Oracle9i's Directory Object. Learn how to set up a directory object, access data using external tables, and get directory information from the database. FireWire Real Application Cluster : With the demands of a 24/7 marketplace, a highly available and scalable database is getting increasingly more important. In the past, you had to choose from one of two options in a cluster. RAC takes the cluster architecture even further, providing improved fault resilience and incremental system growth by offering connection failover and load balancing in the same cluster. In the event of a system failure, RAC ensures your database will still be available. RAC gives you the availability and scalability that enterprises demand. Using Flashback in Oracle 9i : Lost data? No problem. View or recover data with Oracle 9i's Flashback feature, DBMS_FLASHBACK! Viewing and Managing Job Queues in Oracle 9i : Learn how to schedule the periodic execution of user jobs using job queues in Oracle 9i. Also covered are topics on viewing job queue information and managing job queues. Database Performance and some Christmas Cheer : James Koopmann demystifies some of the definitions surrounding the topic of database performance in his latest article. Whether a seasoned veteran or a beginner, the arena of database performance should not be confusing. Join Koopmann as he puts a framework around what database performance truly is. Call by Reference Parameters in PL/SQL (The NOCOPY Hint) : Amar Kumar Padhi discusses the use of the NOCOPY parameter hint, which has been introduced for OUT and IN OUT parameters in Oracle 8i/9i. Using this hint tells Oracle to make a call by reference. Remote Procedure Calls Will Get You the Cheese : Ever need to pull information from a remote computer through Oracle? Here is a method for getting the system date and time that you can easily expand on to pull loads of other information. Autonomous and Distributed Transactions in Oracle 8i/9i : This article presents a basic introduction to transaction processing in PL/SQL and primarily focuses on the Autonomous transaction processing feature of PL/SQL and the changes that have occurred from Oracle 8i to 9i. Managing Processes for External Procedures in Oracle : In his first article, Ajay Gurshahani details the use of External Routines in Oracle 8i/9i, which are helpful in eliminating the need for using CGIs and also make it possible to create dynamic libraries and call them from PL/SQL. Abstracting Oracle Connectivity with PHP/OCI8 : Dante Lorenso presents several functions designed to help run Oracle queries without the drudgery of repetition. Take these functions, roll them into a PHP class, and voila! ... easy PHP/OCI8! Sending E-mails from Oracle Database : In his first article for DBAsupport.com, Amar Kumar Padhi details how to take advantage of an e-mail server option in Oracle 8i that allows you to send mail from within your code. Oracle 8i Row Chaining and Migration : Though a number of factors can contribute to performance degradation in your databases, many performance issues can be prevented by properly designing and/or diagnosing the databases. As Gaurav Sharan Gupta discusses in his first article for DBAsupport, proper diagnosis of Row Migration (RM) and Row Chaining (RC) can eliminate one of these issues and improve database performance. Listen Software Solutions' "How To" Series: Dynamic SQL : In the final article of the "How To" series from Listen Software, author David Nishimoto discusses how to use Dynamic SQL (select, insert, update, and delete) in stored procedures. SQLTools 1.3.5.15 Beta Released : SQLTools is a light-weight, robust tool for ORACLE database development that includes a text editor, SQL console and a couple of SQL utilities. Small enough to fit on a floppy disk and able to be used on a dial-up connection, SQLTools is a handy, portable, free program that works as fast as SQLPlus. Listen Software Solutions' "How To" Series: The Listener Server : In the twenty-fifth article of the "How To" series from Listen Software, author David Nishimoto discusses how to start and stop the listener server and how the client and server use the listener server. Adding Columns in a Synchronous Multi-Master Replicated Environment : So you find yourself in a synchronous multi-master replicated environment under Oracle 8i and need to add a column to a table. Greg Johnson's step-by-step guide makes the process as painless as possible. Listen Software Solutions' "How To" Series: Using the Net 8 Assistant : In the twenty-fourth article of the "How To" series from Listen Software, author David Nishimoto discusses using the Net 8 Assistant to create a connector descriptor, using Host, Port, Sid, and logical names. OLAP and Data Warehousing - Data Warehousing Solution Architecture (Part 2) : Alexzander Nepomnjashiy continues his series on OLAP and Data Warehousing with a focus on Online Analysis Processing (OLAP) and Data Mining technologies. Listen Software Solutions' "How To" Series: SQL Tuning - File I/O Performance : In the twenty-third article of the "How To" series from Listen Software, author David Nishimoto offers tips and tricks for improving File I/O performance, with tuning topics focusing on the library cache, data dictionary cache, data cache hit ratios, sorting, utlbstat and utlestat, and rollback wait stats. Listen Software Solutions' "How To" Series: SQL Tuning - Performance : In the twenty-second article of the "How To" series from Listen Software, author David Nishimoto presents sample SQL code to analyze the library cache, data cache hit ratio, buffer hit ratio, and shared pool free memory. OLAP and Data Warehousing - Data Warehousing Solution Architecture (Part 1) : In his latest article, Alexzander Nepomnjashiy continues his analysis of OLAP and Data Warehousing with a look at the architecture used for enterprise-level business intelligence information systems organization. Oracle 9i Locally-Managed Tablespaces (LMT) Migration Method : So you've just migrated your Oracle8i databases in which all your various sized segments reside, and now you want to place them in appropriately sized Locally-Managed Tablespaces (LMT's). Here is a brief guide from Greg Johnson to help you get started in this process. Listen Software Solutions' "How To" Series: SQL Tuning - Optimizer Hints : In the twenty-first article of the "How To" series from Listen Software, author David Nishimoto offers hints to help improve the optimizer's performance. OLAP and Data Warehousing - Data Warehousing Technology Review (Part 2) : In his latest article, Alexzander Nepomnjashiy continues his analysis of OLAP and Data Warehousing with a review of the technology behind and the construction of Data Warehouses. OLAP and Data Warehousing - Data Warehousing Technology Review (Part 1) : In his latest article, Alexzander Nepomnjashiy continues his analysis of OLAP and Data Warehousing with a review of the technology behind and the construction of Data Warehouses. Listen Software Solutions' "How To" Series: SQL Tuning - The Explain Plan : In the twentieth article of the "How To" series from Listen Software, author David Nishimoto guides you through creating and using the explain plan to tune your SQL statements. Listen Software Solutions' "How To" Series: Performing an Incomplete Recovery : In the nineteenth article of the "How To" series from Listen Software, author David Nishimoto provides a step-by-step guide to performing an incomplete recovery of your database. Listen Software Solutions' "How To" Series: Troubleshooting Tips : In the eighteenth article of the "How To" series from Listen Software, author David Nishimoto offers troubleshooting tips for types of database failures, alert logs, and recovery views. OLAP and Data Warehousing - Data in Jail : In his latest article, Alexzander Nepomnjashiy continues his analysis of OLAP and Data Warehousing with a discussion of "Data In Jail" crises. Listen Software Solutions' "How To" Series: Backup and Recovery Strategy : In the seventeenth article of the "How To" series from Listen Software, author David Nishimoto details cold and hot backup steps with incomplete and complete recovery strategies. An Updated Guide to the SPFILE : This recently revised article from Venu G. will help you become more familiar with one of Oracle9i’s new features, the server parameter file – aka the SPFILE. The article has been updated with new sections on the V$SPPARAMETER dynamic performance view and on using the SPFILE with RAC (Real Application Server). Best Practices Road Map for Installing Oracle9i Database : Oracle offers the world's most advanced database for transaction processing, data warehousing, and content management in Oracle9i Database. Before you can reap the benefits of Oracle9i Database, however, you must successfully install it. This article from Ankit Patel provides installation best practices to help you quickly and easily install Oracle9i Database. Listen Software Solutions' "How To" Series: Calculating Tablespace and Table Byte Sizes : In the sixteenth article of the "How To" series from Listen Software, author David Nishimoto offers information on how to calculate tablespace and table byte size. Listen Software Solutions' "How To" Series: Tablespaces : In the fifteenth article of the "How To" series from Listen Software, author David Nishimoto presents information and code for creating tablespaces, adding a datafile to a tablespace, taking a tablespace offline and online, and performing a hot backup of a tablespace. Listen Software Solutions' "How To" Series: PL/SQL Commands and Syntax : In the fourteenth article of the "How To" series from Listen Software, author David Nishimoto offers information and examples on creating cursors, functions, procedures, packages, and triggers. Listen Software Solutions' "How To" Series: Tables : In the thirteenth article of the "How To" series from Listen Software, author David Nishimoto shares information on creating tables, adding Primary key constraints and foreign key constraints, and rebuilding indexes. Listen Software Solutions' "How To" Series: Oracle Functions : In the twelfth article of the "How To" series from Listen Software, author David Nishimoto offers an extensive list of pre-built Oracle functions, including examples of string, time, number, and group functions. Listen Software Solutions' "How To" Series: A Collection of DBA How To's : In the eleventh article of the "How To" series from Listen Software, author David Nishimoto offers various tips and guides to managing datafiles, tablespaces, indexes, rollback segments, snapshots, tables, constraints, and much more. Statement Tracer for Oracle : Above Software has made available a free beta release of their new Statement Tracer for Oracle software. Statement Tracer is an effective and easy-to-use solution for debugging programs interfacing with the Oracle RDBMS. Listen Software Solutions' "How To" Series: The Database Assistant : In the tenth article of the "How To" series from Listen Software, author David Nishimoto offers instruction on using the Database Assistant to create an Oracle instance. Listen Software Solutions' "How To" Series: SQL Plus Reports and Commands : In the ninth article of the "How To" series from Listen Software, author David Nishimoto offers examples of how to build SQL Plus reports, including header, title, column names, linesize, pagesize, format specification, and spooling commands. Listen Software Solutions' "How To" Series: Job Management : In the eighth article of the "How To" series from Listen Software, author David Nishimoto covers job management, with examples of how to use the snapshot process to create stored procedures that run as jobs, how to run existing jobs, how to remove jobs from the job queue, and more. Updatable Snapshots : In his latest article, Prakash continues his exploration of Oracle replication solutions by taking a closer look at Updatable Snapshots. Updatable Snapshots, a feature of Oracle Enterprise Edition only, is the snapshot, or copy, of a table, whose changes can also be propagated back to the parent table. Listen Software Solutions' "How To" Series: The Parameter File : In the seventh article of the "How To" series from Listen Software, author David Nishimoto covers the parameter file, with definitions and values for the various types of variables in the file. Listen Software Solutions' "How To" Series: Rollback Segments : In the sixth article of the "How To" series from Listen Software, author David Nishimoto covers rollback segments, offering examples of how to create a rollback segment and how to bring a rollback segment online. Oracle Replication Solutions : The management of copies of tables across a distributed database environment is replication. The latest article from Prakash addresses the different forms of replication available in Oracle, including potential conflicts and the inherent advantages and disadvantages of each type of replication. Listen Software Solutions' "How To" Series: Logfiles : In the fifth article of the "How To" series from Listen Software, author David Nishimoto covers logfiles, offering examples of how to reset a logfile, how to determine the status of existing logfiles, how to add a logfile to a log group, how to drop a logfile group, how to clear a corrupted logfile group, how to turn archiving on to enable recovery, and more. Introduction to Real Application Clusters : Real Application Clusters is one of the revolutionary features in Oracle 9i Database, but before using this new feature, we must first understand how Real Application Clusters works, what resources it requires, and how to effectively deploy it. Listen Software Solutions' "How To" Series: Creating a Database : In the fourth article of the "How To" series from Listen Software, author David Nishimoto offers examples for manually creating a Oracle Database Instance or creating a database by using the Instance Manager. OLAP and Data Warehousing (The Problem and Solution) : Alexzander Nepomnjashiy's latest article takes an in-depth look at on-line analytical processing (OLAP) server technology and online transaction processing systems (OLTP). Listen Software Solutions' "How To" Series: Control File Backups : In the third article of the "How To" series from Listen Software, author David Nishimoto provides two examples of how to create backups of the control file, which can be used during hot backup recoveries. Listen Software Solutions' "How To" Series: Stored Procedures : In the second article of the "How To" series from Listen Software, author David Nishimoto provides an example of how to create a stored procedure, complete with types of input parameters, types of data structures, conditional logic structures, and blocking statements. Listen Software Solutions' "How To" Series: Normalization : In the first article of the new "How To" series from Listen Software, author David Nishimoto covers the basics of normalization guidelines. A Detailed Guide to the SPFILE : This article from Venu G. will help you become more familiar with one of Oracle9i’s new features, the server parameter file – aka the SPFILE. Oracle Migration Workbench : Oracle recently released Oracle Migration Workbench to help developers quickly and easily migrate applications from IBM DB2/AS400 to Oracle9i Database. RMAN Enhancements in Oracle 9i : This note discusses some important new features that have been introduced in Oracle 9i RMAN. A brief discussion of some new features, commands etc. Undo Tablespaces in Oracle 9i : As a part of our Oracle 9i Feature Series, This article gives a brief overview of Undo Tablespaces, Init.ora parameters that affect them and creation, management and monitoring of the Undo Tablepspaces Database Management ( DBA ) Enhancements in Oracle 9i : As a part of our Oracle 9i Feature Series, This article gives a brief overview of the new features in Oracle 9i that help database administrators get administrative chores done quicker. Datawarehousing ( ETL) Enhancements in Oracle 9i : As a part of our Oracle 9i Feature Series, This article gives a brief overview of the new features in Oracle 9i that improve the data processing / data warehousing features of Oracle. Comprises of set of nine practice quizzes for SCJP exam with answers. Java Certifications - Explore information and links for Java and Sun certifications. Includes articles, practice tests, software reviews, book reviews, and forums. Java Certification Resources - SCJP tutorial, mock exams, objectives, mock exam links and discussion forum. Java - Java certification resources, including practice tests (SCJP SCWCD SCBCD ), free quizzes, and study aids. The Java Mock Test - Offers free applet based mock exam for SCJP2. Certified Java Programmer Mock Exam (310-025, 310-035) - Contains mock exams and tutorials for SCJP exam. Concentrated Guide to SCJP2 - A zip archive consisting of SCJP Notes (PDF) and Questions and Answers (Word document) compiled . SCJD Study Group - Developer exam resources including FAQs, guidelines, presentations, free books and discussion forum. Test simulators for Sun certification exams. [Commercial] Everything you want to know about SCJP - A Blog to help SCJP aspirants with links and daily question. Exams guide - Java certification resources. Free Java Certification Training - Contains mock tests, source code, resources for Sun Certifications, resources on Web-development and UML. Java Certification Site - Includes SCJP experiences, FAQs, mock exams, tutorials and links to other resources. Contains excerpts from an ongoing SCJP book, exam information, notes and links to Mock exams/resources. Also publications, resume, photography, banner art. Java Certification - Provides exam simulators and online training for Sun Java Certification exams. Java Certification Exam Questions - SCJP mock tests, exam notes and other resources. Java certification forum - A discussion forum dedicated to Java certification exams. Java Certification Guide - Contains tutorial on SCJP. Also contains a downloadable PDF version. Java Certification Resources - Includes tutorials, mock exams, study notes and exam simulators for SCJP and SCWCD exams. Java Certification (SCJP) - Contains SCJP mock exam, tidbits, exam notes and links to other resources. Java Certification Study Group - Study community with forums, chat and resources. Java Certification Study Notes - SCJP & SCWCD study notes, resources and tips. Java certification success, Part 1: SCJP - A SCJP Tutorial to test the knowledge of Java fundamentals and requires in-depth knowledge of the syntax and semantics. Java Certification Webring - Web-ring of sites involved with certification. Java Gurus Java Certification Forum Home Page - Forum to pose and view the who, what, where, why and how questions on Java certification. Java Mock Exams, Practice Questions, Tutorials, Articles - Contains practice questions and mock exams for various Sun and IBM certifications. Java Programmer Certification - SCJP Revision notes, links and other resources. Java Quick Reference - Comprises of concise study notes for SCJP exam and other links. Contains sample questions, SCJP exam objectives with code examples and other resources. Java certification resources. Certification community with exams on Java related technologies, including Java SE & EE, Spring, Hibernate, Ant, JUnit, Struts, JSF, Web Services and XML. Java Certificate - A free online training centre that will help prepare for the Sun Certified Programmer for Java(tm) 2 Platform exam (SCJP 1.4). Java Certified ProgrammerContains study aides, news and mock exams. Tutorials, mock exams and other preparation material for SCJP and SCWCD. SCEA Mock Exam, Solutions for JavaQueries. Includes general and certification questions and other java resources. Java Certification exam simulator with tutorials and integrated training content. [Commercial] Contains mock exams, links, forum, code examples and other SCJP/SCWCD resources. Learn + play Java - Interactive, downloadable course for SCJP with built-in Java source interpreter. Work and experiment with class libraries using the tests and JLS Summary. Java Certification - SCJP exam resource with tutorials, mock exam and community features. Java Mock Exam - Javascript based SCJP Mock Exam. Oracle Certified Java Developer - Starting point for Oracle Certified Java Developer OCP program. Passing the Java Programmer Certification Exam - Article discusses how to prepare for the Java Programmer certification. Includes suggestions on how to study for the exam. SCJD Resources - Sun Certified Java Architect resources and experiences. Quick Java - Contains a Java lookup reference and test-simulator based on a book. Web Development Resources - Contains links to SCJP resources. SCJP 1.4 certification primer - Outlines the new programmer certification exam with suggestions for preparation, sample questions and links to resources. SCJP2 MockExam - 60 questions mock test [Download]. SCJP Simulator - Offers an exam simulator with provision to add more questions. SCJP Study Guide - Study Guide for exam CX-310-055 (Sun Certified Programmer for the Java 2 Platform, Standard Edition 5.0). SCWCD Certification Resources - Contains links to study guides, exam simulators and other resources for SCWCD examination. SCWCD Exam Review - Review notes for the Sun Certified Web Component Developer exam. Provides simulators for SCBCD and SCJD exams. [Commercial] SUN Certification Study Materials - Provides study guides & mock exams (needs registration) for SCJP 5.0 (CX-310-055) and SCDJWS (CX-311-220) tests. Sun Certified Java Programmer Sample Test Paper - A practice test for SCJP consisting of 30 questions with answers. Sun Certified Programmer Examination Revision Book - SCJP Tutorial based on Sun's Objectives. Sun Java Links and resources useful for SCJP aspirants includes exam simulators, mock exams, study guides. Sun Java Certification Exam Preparation - Provides exam simulators and online training for Sun Java Certification exams: SCJP, SCWCD, SCBCD and SCEA [Commercial]. Sun Java Certification Resource Center - Contains concise details on various Sun certification exams and links to resources. Contains interactive quizzes, pitfalls, FAQs by programmers, list of integrated development tools. SCJP exam simulator containing 600 questions [Download]. SCJP mock exam engine with facility to add new question/answers. Needs jdk1.2.1 or higher [download]. Java - Contains topic-wise mock tests, tips from those who passed, recommended books and links to other testing/java resources. | ||||||||||||||||||||||||
