Did you mean
Oracle9i (98 results), Oracle9i Database (18 results), Oracle9i Application Server (15 results), Oracle9i Real Application Cluster (6 results), Oracle9i Application Server Portal (3 results)
Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- Recover from import errors in Oracle
- When an import runs, it creates tables and loads data before loading other schema objects such as views, synonyms, and sequences. If the import fails after table creation and loading, check out a technique that you can use to continue manually using SQL*Plus. TechRepublic's Oracle newsletter covers automating Oracle...
- Technical articles 2005-04-26
- What to expect when you migrate to Oracle9i
- With the impending desupport of Oracle8i in December 2003, many shops are preparing to make their move to Oracle9i. So, what can you expect when you upgrade to Oracle9i? Actually, Oracle9i is very stable and most shops are quite thrilled with the performance improvements and new features. Let’s take a...
- Technical articles 2003-10-16
- How to integrate Oracle9iAS Portal with Active Directory
- By Sanjeev MalikOne tough challenge architects face is implementing enterprisewide single sign-on systems. As enterprise portals become more important than ever, companies are facing the challenge of minimizing user hassle without decreasing security.Oracle9iAS Portal (9iAS Release 2) provides Oracle Internet Directory OID based authentication, which helps companies implement enterprisewide single...
- Technical articles 2003-07-31
- Learn to use Oracle9i space management tools with tablespaces
- Locally managed tablespaces LMT and automatic segment space management ASSM provide a new way to manage freelists for individual objects in a database. Along with these ASSM features, Oracle9i provides several new DBMS PL/SQL packages for viewing and managing tablespaces with ASSM. These include:dbms_space.space_usagedbms_repair.rebuild_freelistsLet’s explore how some of these packages...
- Technical articles 2003-01-20
- TechRepublic Tutorial: Automatic space management improves table management in Oracle 9i
- Improve Oracle table managementRecent releases of Oracle include new mechanisms to simplify the administration of tables and indexes. Oracle began with locally managed tablespaces in Oracle8i and progressed to automatic extent management in Oracle9i. In this Daily Drill Down, I’ll explain how automatic space management in Oracle 9i makes it...
- Technical articles 2002-12-26
- Oracle9i database parameters ease maintenance and reduce downtime
- Learn what Oracles database parameters can do and how to use them, including immutable, semi-immutable, dynamic system, and run-time behavior parameters.Sophisticated database management systems such as Oracle need maintenance, and many database maintenance procedures require you to modify the database system’s parameters. Because Oracle is so flexible, it requires over...
- Technical articles 2002-11-25
- Dynamic adjustment of the Oracle9i SGA
- Database performance is a constant issue in today's always-available world. Oracle has addressed this issue with on-the-fly performance tuning in Oracle9i, but admins must develop a strategy for monitoring and adjusting system performance.The ability to dynamically reconfigure Oracle9i was the most exciting new feature of the new version's release, propelling...
- Technical articles 2002-09-16
- Oracle9i simplifies SQL syntax
- Oracle9i SQL includes major improvements over previous versions. Learn more with a detailed discussion of the enhancements, including sample code.Oracle has made some important enhancements to Oracle9i SQL, including a host of exciting new execution plans, support for scalar subqueries, and support for the ISO 99 SQL standard. As implemented...
- Technical articles 2002-08-02
- Turbocharge SQL with advanced Oracle9i indexing
- Oracle 9i indexing goes far beyond the b-tree. The new powerhouse structures include bitmapped indexes, function-based indexes, and index-only tables. Check out this article to see how these structures can benefit you.Oracle9i includes numerous data structures to improve the speed of Oracle SQL queries. Taking advantage of the low cost...
- Technical articles 2002-03-26
- Oracle9i promises some interesting enhancements
- Get a jump on Oracle 9i's new features and capabilities. This article examines the product's WebServer, availability, and database enhancements.In an earlier article, we covered some of the new data warehouse characteristics of Oracle 9i and discussed a few of the version’s changes. Continuing with our overview, we’ll turn our...
- Technical articles 2000-12-18
- What's new in Oracle9i?
- The Oracle9i beta release will be available soon. Here's a sneak peek at some of the enhancements and new features you can expect.Oracle has a long history of introducing new releases with huge fanfare. When Oracle9i was introduced, Oracle Corporation offered one million dollars to any customer who did not...
- Technical articles 2000-12-14
Additional Resources
- How and when to use Oracle9i bitmap join indexes
- Oracle continues to push the envelope with the new features added to Oracle9i. Learn more about the creation of bitmap join indexes and how they really work.Oracle9i has added the bitmap join index to its mind-boggling array of table join methods. This new table access method requires that you create...
- Technical articles 2002-11-12
- Use Oracle9i full-index scans to read data quickly
- The Oracle9i optimizer has been enhanced to further streamline SQL query performance. Learn more about these new features and how you can use them to read indexes without touching the table itself.In keeping with Oracle’s commitment to add intelligence to SQL query optimization, the full-index SQL execution plan has been...
- Technical articles 2002-11-25
- Take advantage of Oracle9i full-index scans
- Database administrators are constantly working to improve query performance. Oracle provides a powerful tool to facilitate the search by monitoring and tweaking RAM memory usage.In keeping with Oracle’s commitment to add intelligence to SQL query optimization, the full-index SQL execution plan has been enhanced to provide support for function-based indexes...
- Technical articles 2002-12-02
- Oracle9i's automatic segment space management improves segment storage internals
- To keep its position as the most powerful and flexible database, Oracle has been creating new mechanisms to simplify and block storage of tables and indexes over the last few releases. Starting in Oracle8i, Oracle began to automate the management of objects within a tablespace. The first enhancement was called...
- Technical articles 2003-01-13
- An insider's guide to Oracle certification, part 2
- To maximize the number of certification options, Oracle Corporation currently offers four types of Oracle certifications. They are designed to encompass all job areas using Oracle, including DBA, developer, and operator.In this installment, we examine the Oracle certification series and take a closer look at the Oracle exams. In an...
- Technical articles 2002-04-19
- Oracle9i provides enhanced views of RAM usage
- Many database performance problems are directly related to a shortage of RAM memory. To help you better manage RAM utilization, Oracle9i provides enhanced views of individual RAM usage for processes connected to a database.Prior to Oracle9i, most relational databases couldn't show the individual RAM memory usage for processes connected to...
- Technical articles 2002-10-18
- Oracle9i provides enhanced views of RAM usage
- Many database performance problems are directly related to a shortage of RAM memory. To help you better manage RAM utilization, Oracle9i provides enhanced views of individual RAM usage for processes connected to a database.Editor’s note: This article was originally published on Builder.com.Prior to Oracle9i, most relational databases couldn't show the...
- Technical articles 2002-11-29
- What to know about Oracle's revamped DBA certification program
- Those of you planning to pursue Oracle DBA certification need to be aware of a few changes before you begin your work. For starters, Oracle has added a requirement that candidates must take an Instructor-Led Training class.Oracle Corporation has completely revised its database administration DBA certification program for version 9i...
- Technical articles 2002-09-04
- Oracle Tip: The end of rule-based optimization in Oracle 10g
- This article originally appeared in the Oracle e-newsletter. Click here to subscribe automatically. More than a decade ago, all Oracle databasesused what is now called rule-based optimization, which uses a fixedstrategy to optimize a query's results. For example, if a table had a unique index andthe columns...
- Technical articles 2004-05-24
- << Previous
- page 1 of 1
- Next >>
