Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- New Oracle10g SQL optimizer hints
- With each new release of Oracle, there are more tuning controls and opportunities for improving the execution speed of SQL. In an article about speeding up SQL execution in Oracle, I discussed some common SQL tuning hints and, in another article, I warned about performance issues when using SQL hints...
- Technical articles 2004-04-26
- Database Optimization: Measuring Oracle disk I/O speed
- Because all Oracle databases retrieve and store data, the relative cost of physical disk access is an important topic. In Oracle, we see two types of data block access:db file sequential read—A single-block read (i.e., index fetch by ROWID)db file scattered read—A multiblock read (a full-table scan, OPQ, sorting)Physical disk...
- Technical articles 2004-03-01
- Database Optimization: Determine if the 64-bit architecture is right for your database
- When deciding whether to upgrade your database servers to a 64-bit environment you should apply a very specific set of criteria to justify your decision. Remember, if your system does not experience any of the 32-bit limitations, then your 64-bit migration may not improve performance. On mission-critical databases where speed...
- Technical articles 2004-02-23
- Database Management: Auditing and reporting Oracle user activity
- Changes in U.S. federal laws have mandated increased security for auditing Oracle user activity. HIPAA, the Sarbanes-Oxley Act, and the Gramm-Leach-Bliley Act have all produced serious constraints on Oracle professionals who are now required to produce detailed audit information for Oracle system users.Starting with Oracle8i, Oracle introduced special triggers that...
- Technical articles 2004-02-09
- Database Optimization: Managing third-party Oracle vendor systems
- If you use a vendor package with Oracle, you may be one of the thousands of shops that struggle with optimizing and tuning vendor systems that you did not write and cannot change. Oracle shops are now using giant enterprise resource planning ERP solutions such as Oracle Applications, SAP, and...
- Technical articles 2004-02-02
- Database Optimization: Tweaking Oracle SQL performance parameters
- Oracle Corporation has invested millions of dollars in making the cost-based SQL optimizer CBO one of the most sophisticated tools ever created. The job of the CBO is to always choose the most optimal execution plan for any SQL statement.However, there are some things that the CBO cannot detect, which...
- Technical articles 2004-01-26
- Database management: Tuning with Oracle replication
- Oracle replication has been around for quite some time and has become a mature, feature-rich environment to satisfy widely dispersed processing requirements. Replication was first introduced as a way to allow Oracle tables or subsets of tables to be available locally on widely separated database servers. This was accomplished via...
- Technical articles 2004-01-06
- Database management: Create a proper development environment for Oracle SQL
- In order to provide a consistent SQL execution environment in Oracle there are a number of environmental issues that should be addressed. By ignoring these issues you invite instability, acknowledged by ever-changing SQL execution plans, resulting in poor database query performance.Successful use of Oracle’s Cost-Based Optimizer CBO is heavily dependent...
- Technical articles 2003-12-29
- Database management: Optimizing your Oracle*Net configuration
- Oracle databases are often shared across geographical areas, so it's imperative that the Oracle professional understand how database performance is affected by network communications. The Transparent Network Substrate TNS, provided by Oracle, allows distributed communications between databases.The TNS, which is a distributed protocol, allows for transparent database communications between remote...
- Technical articles 2003-12-16
- Use referential integrity to enforce basic business rules in Oracle
- It is important for a database system to have a means of enforcing basic business rules. If a transaction attempts to insert, update, or delete a table row that would violate the business rules, then the database must roll back the transaction and flag an error to the application. While...
- Technical articles 2003-12-02
- Database administration: Causes of Oracle buffer busy waits
- One of the most confounding problems with Oracle is the resolution of buffer busy wait events. Buffer busy waits are common in an I/O-bound Oracle system, as evidenced by any system with read (sequential/scattered) waits in the top-five waits in the Oracle STATSPACK report, like this:Top 5 Timed Events %...
- Technical articles 2003-12-09
- Optimize an Oracle network configuration
- Oracle databases are often shared across geographical areas, so it's imperative that the Oracle professional understand how database performance is affected by network communications. The Transparent Network Substrate TNS, provided by Oracle, allows distributed communications between databases.The TNS serves as an insulator between Oracle’s logical data request and the physical...
- Technical articles 2003-11-18
- Extend the capabilities of STATSPACK to measure Oracle disk I/O
- One of the current shortcomings of STATSPACK is that it cannot directly monitor disk input and output (I/O). Here's a great technique that I use for extending the capabilities of Oracle's STATSPACK performance utility to report statistics on I/O activity at the disk and file level in a UNIX environment.Ordinarily,...
- Technical articles 2003-11-11
- Hypercharge Oracle SQL by using histograms
- The distribution of values within an index will often affect the cost-based optimizers CBOs decision whether to use an index or perform a full-table scan to satisfy a query. This can happen whenever the column referenced within a SQL query WHERE clause has a non-uniform distribution of values, making a...
- Technical articles 2003-10-31
- Optimize SQL query speed with the Oracle clustering_factor attribute
- The cost-based optimizer CBO improves with each new release of Oracle, and the most current enhancement with Oracle9i is the consideration of external influences (CPU cost and I/O cost) when formulating an execution plan. As Oracle evolves into Oracle10g we may see even more improvements in the ability of the...
- Technical articles 2003-10-27
- 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
- CEO Ellison reveals the Oracle10g vision of enterprise grid computing
- In his typical manic style, Oracle CEO Larry Ellison shared his vision of the future of enterprise computing last week at the OracleWorld conference in San Francisco. Always brilliant, and sometimes too far ahead of his time, Ellison laid the foundation for his version of grid computing: the enterprise grid...
- Technical articles 2003-10-06
- Audit design with Oracle fine-grained auditing
- In my last installment, I examined the different auditing tools provided by Oracle and examined the system-levels triggers for auditing. Now I will explore Oracle’s most powerful auditing tool, the Oracle9i fine-grained auditing FGA package.Miss parts of the series?Get up to speed with these articles:"Oracle design security from the ground...
- Technical articles 2003-09-22
- Choose the proper Oracle design for auditing
- More than ever, companies are demanding complete audit trails for everything that happens within an Oracle database. Managers want to see audits of all aspects of the database, and government regulations are spurring this interest.The most important regulation is HIPAA, the Health Insurance Portability and Accountability Act of 1996. Under...
- Technical articles 2003-09-08
- Track CPU and I/O cost with Oracle9i
- With each new release of Oracle, the database becomes more aware if its external environment. Oracle sets several important initialization parameters based on the number of CPUs on the Oracle server, and Oracle is now becoming more aware of the costs of CPU cycles and I/O operations.The cost-based SQL optimizer...
- Technical articles 2003-09-02
- << Previous
- page 1 of 4
- Next >>
Refining Tags
- Oracle Corp. (65 results)
- database (31 results)
- Oracle9i (24 results)
- SQL (13 results)
- Oracle9 (9 results)
- server (8 results)
- RAM (6 results)
- performance (6 results)
- security (5 results)
- database management (4 results)
- auditing (4 results)
- data buffer (4 results)
- ERP (3 results)
- Oracle Database (3 results)
- certification (3 results)
- execution plan (3 results)
- cost based optimizer (3 results)
- materialized view (3 results)
- full-table scan (3 results)
- Listing B (3 results)
- clause (3 results)
- CPU (3 results)
- I/O (3 results)
- Oracle Real Application Cluster (3 results)
- disk (3 results)
- bitmap (3 results)
