- 6 Reasons to Migrate Your Oracle Databases Twice as Fast to Release 12.1.0.2
- Sep 15, 2015
- Oracle Database 11.2.0.4 is the terminal release for Oracle 11g R2, and extended support for that release ends as of December 2015. Yet many Oracle shops haven't accelerated their pace to transition to Oracle Database 12c R1. Oracle ACE Director Jim Czuprynski, author of Oracle Database 12c New Features, Part 1 LiveLessons, explains why Oracle DBAs should redouble their upgrade efforts to take advantage of six key feature sets available in Oracle Database 12.1.0.2.
|
- A Close Look at Oracle8i Data Block Internals
- Feb 9, 2001
- Data blocks: how they're created, how space is really managed inside a tablespace, and some other geeky internal things
|
- An Interview with Bert Scalzo and Dan Hotka on Toad for Oracle
- Aug 27, 2015
- Data expert Phyllis Helton talks to Bert Scalzo and Dan Hotka, co-authors of Toad for Oracle Unleashed, about some of their favorite features in Toad, their thoughts on GUI tools, and advice for people new to developing using Oracle and Toad.
|
- An Oracle Programmatic and General Reference
- Dec 19, 2003
- Need to look up the Oracle operators, functions, format models, reserved words, and privileges? This handy set of charts, from the Oracle DBA SQL Quick Reference, will help you find what you need.
|
- art_gore_outsourcing
- Jan 1, 2003
|
- Associating Data Dictionary Views with the Related X$ Tables
- Nov 6, 2000
- Once you are comfortable with the Oracle RDBMS as a DBA, you will find a lot of valuable information in x$ tables that won't be available anywhere else. Oracle expert Megh Thakkar shows how you can associate data dictionary tables with the related x$ ...
|
- Basic Concepts for Guerrilla Oracle
- Jul 4, 2003
- Get the important foundational information you need to fully understand and successfully build your Guerrilla Oracle database. You will explore five important topics, including databases, the Oracle Server environment, SQL programming languages, development tools, and the Web.
|
- Challenges in Developing a Scalable Java Environment with Oracle8I
- Nov 6, 2000
- It can be quite difficult to write reliable and scalable multithreaded Java applications. Megh Thakkar discusses the issues that developers must tackle when trying to improve scalability in e-commerce applications.
|
- Choosing the Appropriate JDBC Driver to Connect to an Oracle Database
- Nov 6, 2000
- Oracle8i provides two different client-side programmatic interfaces for Java developers to access data stored in the database: JDBC and SQLJ (enabling SQL to be embedded in Java). Oracle expert Megh Thakkar discusses the JDBC drivers that can be used ...
|
- Comparing Autonumbering Methods in Different Relational Database Management Systems
- May 1, 2002
- Most SQL engines have a rich set of tools to manage sequential numbers. This article examines four systems with four quite different approaches.
|
- Conditional Control: IF Statements in Oracle PL/SQL
- Aug 27, 2008
- This chapter explores the conditional control statements IFand ELSIF and shows you how they can be nested inside one another.
|
- Creating Oracle Databases
- Dec 3, 2004
- This chapter from the Oracle 9i Fundamentals I Exam Cram book covers the creation of a database, with sample questions to help you prepare.
|
- Dealing with Database Block Corruption in Oracle
- Nov 6, 2000
- Oracle expert Megh Thakkar discusses how an Oracle DBA can deal with data block corruptions.
|
- Dynamic Reconfiguration and Oracle 9i Dynamically Resizeable SGA
- Apr 9, 2004
- This article explains how Oracle 9i can operate in combination with Sun's dynamic reconfiguration (DR).
|
- FAQ: Undo Space Management in Oracle 9i
- May 24, 2002
- Megh Thakkar covers the major questions related to management of undo segments in Oracle9i.
|
- Forcing Garbage Collection to Avoid Memory Leaks in Oracle's JVM
- Nov 6, 2000
- One of the best features of Java is that it performs automatic garbage collection, or memory management. In this article, Oracle expert Megh Thakkar demonstrates how you can force garbage collection to occur when you need it.
|
- Fundamentals of Programming in PL/SQL
- Feb 6, 2004
- In Oracle PL/SQL by Example, Third Edition, authors Benjamin Rosenzweig and Elena Silvestrova cover Oracle 10G and all the fundamentals. In this sample chapter, you'll be introduced to the key words and their syntax. You'll also expand on simple block structure with an exploration of scope and nesting blocks.
|
- Introduction to Oracle Databases on Virtual Infrastructure
- Oct 22, 2014
- 99.9% of all database or data management systems should be considered candidates for virtualization on vSphere. In this chapter from Virtualizing Oracle Databases on vSphere, the authors argue that Oracle databases and software are prime candidates to consider migrating to virtualized infrastructure.
|
- Introduction to Oracle Web Applications
- Apr 4, 2003
- Before baking a cake, you need to know the ingredients; the same is true for Web apps. First take a look at the basics of the Internet, the Web, and browsers and then see how PL/SQL can be a powerful component for Web applications.
|
- Java Capabilities of Oracle 9i
- Jun 7, 2002
- Oracle recognizes the importance of supporting Java capabilities. In this article, Megh Thakkar discusses some of the key features provided.
|