Home > Articles > Data > Oracle

Oracle

67 Items

Sort by Date | Title

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.

Page 1 2 3 4 Next >