- Java, Databases, and Oracle
- Apr 25, 2003
- If you're a Java enthusiast but haven't fallen for a database system yet, discover why Java and Oracle are a perfect match for your applications.
|
- Managing Contention for Oracle Latches
- Nov 6, 2000
- Internally, Oracle uses various types of structures, the access of which is controlled using a variety of mechanisms, including latches. In this article, Oracle expert Megh Thakkar discusses how contention for Oracle latches can be minimized.
|
- Mobile Database Review: Oracle 9i Lite
- Feb 22, 2002
- Second in a series of reviews of popular mobile database products, this article presents Bryan Morgan's take on Oracle9i Lite.
|
- Multilingual Applications with Oracle Developer
- Nov 30, 2001
- Programming with Oracle Developer author Matthew Bennett provides an example for creating multilingual applications using Oracle Developer.
|
- Optimizing Oracle Export and Import
- Nov 6, 2000
- Oracle provides the Export/Import utility combination for data transfer. The entire data transfer procedure can take a very long time for very large databases. Oracle expert Megh Thakkar shows several techniques that can be used to improve the performance ...
|
- Oracle 9i: Performance Impact of the Database Cache
- Apr 19, 2002
- Megh Thakkar discusses proper sizing of the Oracle 9i database cache to improve the hit/miss ratio of the buffer cache.
|
- Oracle 9i: Working with Multiple Block Sizes
- Apr 12, 2002
- Megh Thakkar discusses advantages of the updated System Global Area (SGA) in Oracle 9i.
|
- Oracle Architecture and Design Issues for E-Business
- Feb 1, 2002
- This sample chapter from e-Business for the Oracle DBA covers capacity planning, using StatsPack for capacity planning purposes, architectural issues and components of an e-Business, and design issues for e-Businesses.
|
- Oracle DBA: Backup and Recovery Scripts
- Dec 27, 2002
- Having the right backup and recovery procedures is crucial to the operation of any database. It is the responsibility of the database administrator to protect the database from system faults, crashes, and natural calamities resulting from a variety of circumstances. Learn how to choose the best backup and recovery mechanism for your Oracle system.
|
- Oracle Developer and ODBC
- Nov 30, 2001
- Programming with Oracle Developer author Matthew Bennett provides an example of connecting Oracle Developer to an ODBC database.
|
- Oracle Developer Interface Guidelines
- Nov 30, 2001
- Programming with Oracle Developer author Matthew Bennett shares some ideas on interface guidelines for Oracle Developer.
|
- Oracle Exadata Smart Flash Cache in Depth
- Jul 6, 2015
- In this chapter from Oracle Exadata Expert's Handbook, the authors review the architecture of Exadata Flash solid-state disk and examine in detail how Exadata Smart Flash Cache and Exadata Smart Flash Logging allow you to transparently leverage this Flash I/O.
|
- Oracle Performance By Design
- Nov 30, 2009
- An application’s design determines whether the application performs like a Ferrari or a gas-guzzling clunker. If you want your Oracle application to win the performance race, Guy Harrison showcases these high-performance design patterns.
|
- Oracle Performance Tuning: A Methodical Approach
- Nov 5, 2009
- Guy Harrison shares a methodology that ensures that you focus on the root causes of Oracle performance problems.
|
- Oracle PL/SQL Programming Concepts
- Jan 24, 2003
- PL/SQL is Oracle's Procedural Language extension to SQL. It is commonly used to write data-centric programs to manipulate data in an Oracle database. Here's a basic primer to help beginners get started.
|
- Oracle Solaris 11 System Administration: Administering Storage Devices
- Aug 13, 2013
- System administrators need to know how to specify device names when using commands to manage disks, file systems, and other devices. This chapter describes disk device management in detail. It also describes disk device naming conventions as well as adding, configuring, and displaying information about disk devices attached to your system.
|
- Oracle SQL: The Basics
- Aug 25, 2009
- In this chapter you will learn the basics of the SQL language and use SQL Developer and SQL*Plus.
|
- Oracle Universal Installer
- Aug 13, 2004
- One of the beauties of the Oracle database is that nearly everything associated with it can be automated, and installation is no different. This chapter provides a handy guide to using this feature of Oracle to its fullest extent.
|
- Oracle versus SQL Server in the Enterprise
- Mar 25, 2005
- Can Oracle kick SQL Server's behind? Oracle expert David Hull throws down the gauntlet to Microsoft devotees.
|
- Oracle vs. SQL Server, Part 5 - Dissecting Oracle 9i
- Aug 30, 2002
- See the pure power of this awarding-winning RDBMS by looking at the outstanding features and benefits that it has to offer you.
|