||Oracle Tips by Burleson
Perform a Two-Phase Commit
In this assignment you will get an opportunity
to perform a two-phase commit on your two instances (pubs and newpubs).
As we know, Oracle will use the Recoverer process on your PC to ensure
that both of our updates will either commit or fail as a single unit.
Remember, only a specific commit between two
DML statements will release a two-phase commit. It is the default
behavior of Oracle 10g. Your challenge is as follows:
Create a single script that will perform the
following updates as a two-phase commit:
1 – Add 50 to the published quantity for all
books. This will require an update to
2 – Update all books to increase the royalty
percentage by 1%. This will update book.book_royalty_pct by one.
Turn in to the instructor by the due date.
The main points of this tutorial include:
* Role-based Oracle security cannot be
extended to remote instances.
* Database links may be either public or
* Database links do not require a CONNECT TO
* The DBA can choose to implement private
database links to manage remote security.
* Some shops encapsulate all SQL into stored
procedures and use “grant execute” to manage cross-database
* Location transparency can be implemented
by using public synonyms.
* Databases on the web use XML as a
* Two-phase commit processing is handled
automatically by Oracle*Net, but internet-based database require
special code to manage concurrent updates.
For more details,
see the "Easy
Oracle Series" a set of books especially designed by Oracle
experts to get you started fast with Oracle database technology.
Burleson Consulting can offer world-class
remote Oracle database support at super-affordable prices.
Oracle DBA service provides 100% of the remote Oracle database
administration needs for your company, and includes 24x7 access to our
staff of 100% OCP Certified Oracle DBAs.
We require a 12 month service commitment and include the following
- Initial configuration
review and problem identification
- Installation of Oracle
statistics collection mechanisms and quarterly database growth
- Hourly monitoring of your
Oracle database for pending problems
- Periodic performance
analysis & identification of tuning activities
- Twenty Four hour Oracle
- Reporting and resolving
all serious Oracle alert log messages
- Free use of the BC
- Quick response emergency
support for production database outages
- Four hours of free remote
DBA support every month. You can use these free hours for any DBA
activity, including database analysis, system design, production
migrations or personal mentoring.
information, please visit
www.remote-dba.cc or email