How do you "talk" to your databases? What are the necessary components that are used to make Oracle networking, using SQL*Net2 or Net8, work? What does a DBA need to know to successfully configure a Net8 listener? This presentation will provide a detailed look at how to work with the necessary configuration files to understand the listener and successfully configure it. Troubleshooting information will be included.
This article presents first hand experiences about creating, managing, and using Oracle Outlines. How many times have DBA's been called in to address a performance issue, only to discover that some kind of environmental change has caused the Oracle optimizer to change the execution plan for some of the applications key SQL statements? Sometimes these environmental changes can be very innocent and minor for example: adding a new index to a table, increasing SORT_AREA_SIZE or re-analyzing some tables. With the introduction of Oracle8i, Oracle now provides a facility referred to as Plan Stability. This facility allows you create a stored execution Plan in the Oracle dictionary and then reference this plan when running your application. Oracle now has provided a facility to help us control and pre-determine the execution plans for applications SQL statements. This facility permits the application to be isolated from environmental changes and will save DBA's a lot of grey hair!
The Oracle server has evolved from a traditional RDBMS to a broad based Internet platform. Revolutionary growth of the Internet and emergence of the Oracle server as the lifeblood of any e-business has underlined the need for the better management of Oracle databases to ensure round the clock availability and high performance. This session discusses some of the key features of the Oracle server which have been provided to simplify server management and ease database administrative tasks. It also discusses some of the best management practices recommended by Oracle for ensuring high availability, scalability and optimal performance.
For an e-business, downtime equates to no business. With your competitors only a mouse click away, you cannot afford downtime. Learn how to use the latest features of the Oracle database to create 24x7 e-business solutions. This session will discuss strategies to protect the application from unplanned outages, to prevent failures, and to recover almost immediately from any failures that might occur. The session will also examine ways to reduce planned downtime, as a 24x7 operation has no window for offline maintenance operations.
Have you ever wondered why a web form runs fast some times and slow at others? When considering performance tuning, establish where the problem is. This has been more complicated with the addition of a new tier, the application web server. For example, ask the question "Is the whole of the application slow or is it just one web page or module?" This session provides a methodology and tools to determine the causes of slow system performance. Find out how to diagnosis why an individual session is running more slowly than expected. This session will explain how to use the V$views to quickly identify the session's status and contention. There will be scripts and examples to supplement the discussion.
Oracle8i extends the enhancements to the buffer cache introduced in Oracle 8.0 with the multiple buffer pool feature. This presentation will review the multiple buffer pools then explain and investigate the mid-point insertion enhancement to the buffer cache replacement algorithms. In addition, there will be discussions on useful new X$BH columns and queries presented that can help identify candidate segments for the RECYCLE and KEEP pools
Partitioning tables and indexes can provide significant performance improvement and increased availability. This presentation provides the results of partitioned tables implementation in a large OLTP database. Using a case study, various issues examined provide guidelines on when and how to implement partitioning in OLTP environment.
This presentation covers improving OLTP database performance by using Oracle features such as index-organized tables, partitioning, table and index clustering, prefixed/nonprefixed indexes and multiple buffer pools. The presentation includes a general overview of these features and when, why and how to use these features to gain performance. Oracle OLTP performance testing done at Compaq will provide the platform to demonstrate improved database performance.
This presentation will focus on key hints, tips and tricks from Oracle Certified Instructors and senior level Oracle DBAs. These recommendations reflect the recommendations from interviews of numerous Oracle instructors as well as several DBAs with 10+ years of experience. Hints and tips offered guarantee to reduce the time spent performing daily administration functions and increase the performance, reliability, availability and recoverability of Oracle database applications. Numerous handouts supplied by the instructor offer proven administration and monitoring scripts for NT, LINUX and UNIX. The session also offers a reference web site for script downloads.
The session will present Networking directions for the database and discuss what are the key technologies and choices Oracle is making in this area. The goal is to convey an understanding on how to leverage Networking features as the database becomes a central hub for large, scalable and available Web sites.
The company's new Web application is a smashing success! But now there are more customers to support, more transactions to handle, and more data to store than you expected. To handle the increasing load, the application developers have a list of changes to make to the application schemas: move some tables to a new tablespace, drop a few indexes, create some others, change a couple table columns, and edit some procedure code. That's a long list of changes to implement, test and deploy by tomorrow. This session will show how to best use the Oracle Change Management Pack to keep up with the rapid pace of change in the e-business environment. Using real world examples and best practices advice, users can best track application schema changes over time and implement these changes without error. Learn to use the pack to set up and maintain development, test and production environments to ensure the application changes roll out correctly. This session shows examples using the Oracle Change Management Pack to troubleshoot configuration and schema problems and to correct them before they degrade the application performance.
This presentation analyzes performance problems in the Oracle shared pool and library cache that can result from large volumes of non-sharable SQL. Discussions include the sources and symptoms of this problem, as well as quantitative experimental results illustrating the severity. In addition, there is an investigation on the effectiveness of the Oracle fix for this problem contained in release 8.1.6.
This presentation compares and contrasts the features of OPS, HA and OPFS and discusses transparent application failover with relation to Websites Technically, availability has concentrated more on vendor solutions not tightly coupled to the applications. Therefore, software vendors like Oracle have created Oracle Parallel Server to augment hardware availability. Additionally, OPS has evolved into Oracle Parallel FailSafe a tightly integrated hardware vendor and Oracle solution that provides near five 9's availability.
Clustering is moving from a position of exotic technology for the most mission critical applications to almost a necessity for enterprise applications. A wide variety of technologies is available, including offerings from Microsoft ("Wolfpack"), VERITAS (VERITAS Cluster Server), and Oracle itself. This session will describe the principles of clustering for business computing, including both the so-called "shared nothing" and shared data models. It will then compare various vendors approaches in the context of suitability for Oracle databases in various types of applications. Finally, discussion includes some new developments, such as "clusters of clusters" for global computing.
This session focuses on four main topics. These include a Net8 Overview describing Net8 and its features, naming methods and configurations. Also, LDAP Directory Naming; what LDAP directory naming is, how it works, tools in Net8, and Net8 directions. Migration will also be discussed; why migrate, how to migrate, several recommended steps, such as, to choose an LDAP directory server, architecture design. Server migration discussions cover Oracle Names and local names, client migration, and coexistence strategies Finally there will be a discussion on Case Studies; the migration strategies, procedures, and stories of several customers with different environments.
What is the cost of a DBA? A lot. What is the cost of hardware? A lot MORE. What is the cost if you lose data? Infinite. This session will describe several strategies that fit your e-business operations to prevent data loss with a minimum of effort and resources. Forget about manually reading backup logs and learn to automate the backup and recovery task so you can focus on your company objectives. Learn that loss of data is a thing of the past.
Life would be great if we could blame poor application performance on the database, or even better the DBA. But with advances made in Oracle8 and 8i the blame usually lies with the application developers. This presentation will demonstrate how an old, but powerful tool, Tracing and TKPROF, can help, even today, improve our application?s response time etc. Attendees will learn tried and true techniques on how to enable tracing, how to analyze it using TKPROF, and how to read and make use of the output it generates. The presentation will wrap up with a discussion on how events can be used to dump bind values, wait events and cost-based optimizer information to the trace file.
There are dozens of little-known facts and methods that most Oracle professionals frequently ask for to improve their environments. Many are not documented well, if at all. This presentation will focus on getting more out of Oracle by showing powerful techniques used by DBAs and developers to become more productive in their environments. Examples include using SQL to generate SQL, dumping the contents of a table to an ASCII file in a tab-delimited format, finding and deleting duplicate records in SQL, getting around some limitations of the LONG datatype, connecting to a database without knowing a user's password, and many, many more topics.
Oracle Names provides a mechanism of resolving service names by storing database connecting information in a central location. This replaces the need of having connecting information installed on each individual client machine. This presentation discusses the required steps to configure and setup an Oracle Names Server in Net8. It offers an introduction to the basic concepts of Net8 and step-by-step instructions for configuring LISTENER.ORA, SQLNET.ORA, TNSNAMES.ORA and NAMES.ORA files. This presentation also shows how to using "lsnrctl" and "namesctl" utilities to setup Oracle Listener and Names Server in both Unix and NT environment.
This session walks through the steps for installing Oracle8i release 2 on a Red Hat 6.1 Linux system. It emphasizes tips and techniques particular to deploying Oracle on the Linux operating system. Members of the audience will gain what they need to know in order to make their Oracle on Linux deployment go very smoothly. Oracle8i release 1 was a bit tricky to install on Linux, but with the right information at your fingertips Oracle8i release 2 installs quickly and easily.
Table and index partitioning are key elements in VLDB management on the Oracle Internet Platform. Commonly touted, these features are used for providing a 'rolling time window' of data that ages out old partitions and accepts current data into new partitions. However, details for implementation of this feature are difficult to obtain, and often left to the creativity of the DBA. This presentation briefly explains the "rolling window" concept, and then goes beyond the simple ALTER TABLE example to leverage other database features as part of a more robust solution.
This session addresses three issues: ? From out of the firewall and into the firing line - The hacker threat to Oracle products ? What is Oracle doing to mitigate these threats, during and after product development; and ? What additional steps application developers and administrators can take to further "harden" their deployment of Oracle products against attacks.
Transportable tablespaces offer the DBA a way to move an entire tablespace from one database to another. Essentially, the DBA can now "unplug" and "replug" a tablespace. But, how do you perform this task and what are the advantages, problems, and restrictions that you might face in wanting to use this Oracle8i new feature? The presentation provides the answers to effectively use the transportable tablespace option. This presentation will cover an in-depth examination of the features offered with the new transportable tablespace option in Oracle8i and a step-by-step approach to implementing this feature.
This presentation provides an in-depth discussion of the various performance enhancements contained in Oracle8i. These include materialized views, function-based indexes, automated parallel query tuning, index-organized table enhancements, hash and composite partitioning, extensible indexing, etc. The presentation contains numerous uncomplicated charts and graphs that illustrate the dramatic improvements in performance obtained with these enhancements. The session also includes a reference web site for downloading proven tuning scripts and hints.
This session describes an approach to configuring storage for an Oracle database that has excellent performance and is easy to implement and manage. This approach is possible because of recent advances in storage arrays, volume managers, and file systems. Oracle has worked for the last year with EMC and Veritas on defining and testing this configuration.
This presentation provides attendees the fundamentals of Oracle database performance management and a checklist of the key parameters that need to be configured to ensure optimal database performance. This technical session also focuses on tuning Very Large Data Bases(VLDBs).
This presentation focuses on the responsibilities of a DBA as it relates to PL/SQL. The presentation covers several of the PL/SQL areas that can seriously affect the DBA's responsibilities. The presentation specifically will cover the following: ? the creation of the PL/SQL components, ? the source code storage with PL/SQL, ? the security requirements, ? encrypting PL/SQL source code, ? the PL/SQL versus SQL engine execution, ? methods to determine impact analysis at a detailed level, ? method of Pinpointing invalid PL/SQL objects and disabled database triggers, ? PL/SQL related init.ora parameters, pinning objects and cursors, ? and the V$ PL/SQL related views. This information is presented through examples to illustrate each area of coverage.
Reorganizing and restructuring a database for optimal performance can take many hours -- sometimes even days. Fortunately, Oracle offers a wealth of features that can dramatically increase the speed of database reorganizations. This presentation will teach you how to evaluate and take advantage of these features, including many advanced options. The topics to be covered include: ? Fast reorganizations inside the database using SQL ? Oracle NO LOGGING option ? Oracle parallel option ? ALTER SESSION parameters ? INIT.ORA parameters, including optimal configuration of the I/O subsystem Original research and case studies will be presented.
The Surgeon General has determined that the information in this class may be too hazardous for the beginning DBA. Drilling into the heart of the Oracle database will be the focus of this fast-faced advanced tuning session. Exploring the information in the V$ views and X$ tables can lead to significant tuning insight that can help accelerate even the most stubborn database performance. Forget the GUI tools and glitz, zoom into views and tables that store the impact areas of memory, disk I/O and query information that give participants the advantage they need to accelerate performance. Not for the weak of heart!
This presentation demonstrates the methods to load LOB information (BLOB,CLOB and NCLOB) into an Oracle8i database as well as simple java applications to read and display the LOB from the Oracle8i database.
You can spend all day tuning your SQL statements. You can apply any one of a number of fantastic first-party (Oracle) and third-party analysis tools to the SQL side of your application. You can bring in an Oracle tuning specialist. Yes, you can tune and tune and tune -- and still your PL/SQL-based programs can run very inefficiently. It is difficult to find detailed, comprehensive recommendations for tuning the PL/SQL side of one's Oracle applications. After spending 12 years learning, using and writing about Oracle's PL/SQL language, Steven Feuerstein has assembled 1,247 tuning tips for PL/SQL developers. He has selected the top 200 most terrific of these tips for this presentation.
For many years the Defacto standard for applications was client/server. However many customers found this problematic. This is not the most scalable architecture for the Internet where the number of users can be enormous. Therefore, customers went to three tiers. For availability and scalability it is necessary to separate the taking of the customer information from the processing of the customer information. This allows the Web site to continue to operate when key back services are down and offload processing of orders to other machines. Oracle Advanced queuing is fully integrated in the database and avoids many of the problems of today's message systems. This presentation will cover the need for message system with a quick technical overview of the AQ product to answer the question.
This presentation examines the use of XML in an Oracle8i environment. The session includes the basics of XML, a brief look at Oracle's XML Parser for PL/SQL and modeling, and an example of Relational Data in XML.
Here's the "GoFaster" button that you've been hunting for. You will receive an overview of 8i developer's gold; autonomous transactions, bulk binds, Native dynamic sql, new PL/SQL package limits, and the nocopy hint. Performance benefits from 30 to 400%!!! We'll examine the features and review of the new PL/SQL limits.
This presentation includes detailed information on how to tune an application written in PL/SQL. It covers performance analysis, tuning, and new performance features scheduled for future releases.
This technical session provides attendees a fundamental understanding of the different levels of RAID and their performance impact on Oracle databases. It also provides a real-life perspective of the key I/O-related issues with RAID and Oracle and its usability. The session also focuses on the role of RAID in Very Large Data Bases (VLDBs).
Partitioning is an essential technology for addressing the requirements of large data volumes in data marts and data warehouses. This presentation provides specific scenarios of how partitioning can enhance query performance, load performance, and manageability of data warehouses. There will be descriptions of each partitioning technique, along with its typical usage within a data warehouse. The session also includes discussion on the maintenance operations used to scalably manipulate partitioned tables. Finally, there is special attention to performance features such as partitioning pruning, partition-wise joins, and parallel DML.
Data warehouse system designers are faced with a diverse set of challenges. This presentation is meant for an intermediate Oracle audience embarking on a data warehousing project. Instead of discussing general Oracle and data warehousing technologies, this presentation will provide the listeners with innovative tips and techniques to exploit the existing Oracle8 technologies into their own DSS environment. The tips and techniques discussed in this presentation are: ? Exploiting star query / star transformation options. ? Using parallel dml options. ? Utilizing parallel index scans. ? Improving performance when enabling constraints. ? Partitioning your tables and indexes. ? Benefiting from index-organized-tables. ? Using bitmapped indexes. ? Selectively disabling REDO. ? Multiblock I/O using fast full index scans. ? Breaking size barriers. The tips discussed are extremely practical and can be easily replicated. General rules of thumb have been identified with each tip for each attendee's easy reference.
Wouldn't you like the Data Warehouse to return results faster? Of course! Materialized views can be the answer. Introduced in Oracle8I were new capabilities added to materialized views with each new software release. This session will first describe how to manage and maintain your materialized views using either SQL or Oracle Enterprise Manager. Then a detailed discussion query response times improved by using query rewrite. The presentation concludes examining the most recent materialized view capabilities and how to use them to gain faster performance and greater control over your data warehouse.
Data Warehouse DBAs, Data Administrators, Data Modelers and System Architects all realize the difficulty of designing data warehouses for both data loading and query response performance. Unfortunately, these two optimization strategies are mutually exclusive. Normalized transaction-oriented systems may ensure data loading performance and data integrity but are inherently slower at performing analytical queries. On the other hand, de-normalization and warehouse index strategies improve query performance but incur the penalty during data loading. Even when achieving a proper balance between load and query performance, consideration must be given to how efficient the design will be as the data warehouse grows in size, complexity, and usage. In order to achieve the perfect balance between query performance and an ever-shrinking maintenance window, both the DBA and Data Administrator must share a common understanding of the complete life cycle of warehouse information. This session identifies warehouse business issues and provides design solutions that ensure continued performance, flexibility, and maintainability of your warehouse system. The session also discusses subtleties of dimensional modeling, data migration issues, and tuning strategies.