Oracle Tips by Burleson

Oracle 10g Changes to v$session_longops

More operations are being added to v$session_longops. This view displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution, and more operations are added for every Oracle release. In the 10g release, this view keeps track of ROLLBACK and ROLLBACK TO operations also.

MAXTRANS and Maximum Concurrency

In previous releases of the Oracle Database, the MAXTRANS values used to represent a physical attribute for objects such as table, index, or cluster. MAXTRANS represented the maximum number of concurrent update transactions for any given data block belonging to the segment.

With Oracle Database 10g, these objects are preconfigured for maximum concurrency. Oracle now allows up to 255 concurrent update transactions for any data block depending on the available space inside the block.

For backward compatibility reasons, even if you specify the MAXTRANS parameter while creating a table, an error is not flagged, and internally the value is ignored.

In the next section, we will examine the changes regarding the statistics collection mechanism. Oracle Database 10g introduces a statistics collection method for the data dictionary tables, as well as predefined jobs, to gather statistics regularly.

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:

http://www.dba-oracle.com/service_oracle_backup.htm