UROWID

Posted on June 8th, 2008 by admin

A single datatype called the universal rowid, or UROWID, supports

both logical and physical rowids, as well as rowids of foreign

tables such as non-Oracle tables accessed through a gateway. A column

of the UROWID datatype can store all kinds of rowids. The value of the

COMPATIBLE initialization parameter must be set to 8.1 or higher to

use UROWID columns.

 

You can also influence checkpoints with SQL statements.

SQL> ALTER SYSTEM CHECKPOINT

directs Oracle to record a checkpoint for the node, and

ALTER SYSTEM CHECKPOINT GLOBAL directs Oracle to record a checkpoint

for every node in a cluster.

SQL-induced checkpoints are heavyweight. This means that Oracle

records the checkpoint in a control file shared by all the redo

threads. Oracle also updates the datafile headers.


Add your opinion - this will move the pointer
get dashboard plugin?

Filed under: ERP, Interview Questions(& answers), Oracle Apps, PL/SQL, SQL

Free Dashboards

Here are some more interesting Articles
  • No related posts

    • Leave a Reply

    You must be logged in to post a comment.

    « Trace Files and the Alert Log-LGWR remote transaction-distributed transaction-two-phased commit -Interview QA »

    • About InfoPurple

      InfoPurple is an Oracle Digest that collects best articles from the best minds from entire blogosphere. We collect them and post an excerpt and point back to the main site. This allows for a consolidated view of Oracle Apps related topics. If you would like to add your website to be included then please email us (infopurple8888 AT gmail DOT com) your web url. If you would like to get your website removed then send us an email and we will remove it. -- infoK purple