A Closer Look at the New Edition
January 2010
TECHNOLOGY: Compression
As Published In
A Closer Look at the New Edition
By Tom Kyte
Our technologist redefines and defers with Oracle Database 11g Release 2.
Instead of using the usual question-and-answer format of the Ask Tom column, I&m going to continue in this issue to explore some of the many new features of Oracle Database 11g Release 2. This time I&ll be looking at two features:&
Edition-Based Redefinition
Deferred Segment Creation
The Killer Feature: Edition-Based Redefinition
I consider Edition-Based Redefinition the killer new feature of Oracle Database 11g Release 2. In short, it&s the ability to perform an online application upgrade of your application. It&s also a huge feature&so huge that it&ll take at least three columns to describe it. I&ll start with how to use Edition-Based Redefinition to &patch& systems. Next time, I&ll show how to use Edition-Based Redefinition to minimize downtime during a full-blown application upgrade that includes physical schema changes. Last, I&ll show how to remove downtime during that same full-blown application upgrade.
Over the years, Oracle Database has given us many online operations, such as&
Modifying most parameters (Only 90 out of the 350 are not modifiable online.)
Reorganizing objects (turning a nonpartitioned table into a partitioned one, reclaiming free space, and so on)
Creating indexes
Applying database patches with Oracle Real Application Clusters
Upgrading Oracle Database from major release to major release&
The result is that almost any change at the database level could be accomplished while the database was up and running and performing transactions&with a few glaring exceptions, such as re-creating a stored procedure, changing a trigger, adding a grant, revoking a grant, and changing a view. In short, the objects that constitute your application in the database could not be modified while users were using them. If someone was executing a stored procedure and the DBA tried to &patch& it (CREATE OR REPLACE the code with new code supplied by the developer to fix a bug), the DBA would get locked out (blocked) by the person executing the code.
Further, anyone else who tried to subsequently run a procedure the DBA was trying to replace would be blocked by the DBA. And in most cases, the DBA would be replacing not a single procedure but many procedures, and the CREATE OR REPLACE of the new procedure code would tend to invalidate other dependent objects as well. The database would appear to &freeze&&the DBA could not accomplish the patching tasks (replace a few procedures, packages, views, triggers, and so on), and the end users could not accomplish their tasks (run the procedures to perform transactions). They ended up blocking and locking each other out.
This all ends with Oracle Database 11g Release 2 and Edition-Based Redefinition, which enables DBAs and end users to access more than one occurrence of a stored procedure, a trigger, a view, and other objects and therefore to stage&in isolation&the changes in a schema. Starting with Oracle Database 11g Release 2, a single schema can now have two or more occurrences (think &versions&) of a stored PL/SQL unit (function, type, trigger, and so on) or
a view or synonym and all of their related metadata such as GRANTs on those objects. (These two occurrences are independent&they coexist but do not interfere with each other.) The &magic& that permits this is the new edition object type&it introduces a new transparent namespace that allows more than one occurrence of a stored procedure, trigger, and so on in a schema at a time.
In the past, a schema object was referenced with two components: the owner of the object and the object name itself. That would, of course, prevent the existence of two stored procedures named &P& in a single schema. At most, you could have one schema object referenced by OWNER.P.
The edition object in Oracle Database 11g Release 2 introduces a third dimension in the name resolution scheme: all objects are now referenced by the edition of the session, the owner of the object, and the object name. Every database has at least one edition associated with it, and the database always has a default edition. When you create a session in Oracle Database 11g Release 2, your session will have an attribute associated with it that denotes the edition your session will be using (by default, this will be the default edition of the database). Using ALTER SESSION, you may specify any edition to which you have been granted access in your session.
When you invoke or reference objects in Oracle Database 11g Release 2, those objects are dereferenced with the edition currently set in your session. That means that an application administ alter a session to use an edition named VERSION2, and compile code into this edition. The work performed by the application administrator in the VERSION2 edition is visible only in sessions using the VERSION2 edition. Because VERSION2 is not the default edition, no one else sees these changes (new procedures, modified views, dropped packages, and so on) unless the person specifically requests to (via ALTER SESSION) and has the privilege to use&to &see&&that edition. The application administrator is able to create or replace any code without contending with the others running the code. If the application administrator needs to replace 50
PL/SQL units, that person can do so&in isolation&all while the in-use production application continues to execute.
The following small example demonstrates this concept. I&ll start as the DBA by creating a demonstration account and granting it the minimum set of privileges:&
SQL& create user demo
User created.
SQL& grant create session,
create procedure
Grant succeeded.
Now I&ll start the process that will enable me to create more than one occurrence of my code objects in the database. I&ll need a new edition in order to do this. The following command creates the new edition:&
SQL& create edition version2
as child of ora$
Edition created.
I&ve created an edition named VERSION2 in my database, and it starts as a child of ORA$BASE. As mentioned above, every database has at least one edition and every database has a default edition. For example, every fresh Oracle Database 11g Release 2 install will have a default edition named ORA$BASE. As a child of ORA$BASE, my VERSION2 edition starts life as a complete copy of the default ORA$BASE edition&everything that is true in ORA$BASE is true in VERSION2.
It is important to note, however, that this VERSION2 copy is a virtual copy. The CREATE EDITION statement did not physically copy every object from ORA$BASE into a new VERSION2 edition. Rather, VERSION2 knows to point to ORA$BASE objects, and it won&t start to use storage in the dictionary until I modify objects in the context of the VERSION2 edition.
So, now I install version 1 of my application in the DEMO account:&
DEMO& create or replace
procedure my_procedure
dbms_output.put_line
( 'I am version 1.0' );
Procedure created.
DEMO& create or replace
procedure my_procedure2
Procedure created.
Pretty simple so far, and when I execute this &application,& I see&
DEMO& exec my_procedure2
I am version 1.0
PL/SQL procedure successfully completed.
Now, suppose this application code has been running in production for a while now and I discover a bug, something I need to fix in the stored procedure. In the past, I would have needed a maintenance outage in order to install the new code.
Now, however, I can stage the change in the database while the database is up and running and users are executing my code with the default edition (ORA$BASE). First, as the DBA, I need to permit the DEMO account to use editions, and then I need to permit the DEMO account to see and use the VERSION2 edition. Additionally, for this demonstration, I am going to let the SCOTT account see and use VERSION2:&
SQL& alter user demo
User altered.
SQL& grant use
on edition version2
Grant succeeded.
SQL& grant use
on edition version2
Grant succeeded.
The ALTER USER statement enabled the DEMO account to use editions of the application code. Without this permission, the DEMO account would be able to have only one copy of the code in place at any given time, just as in Release 7.0 through Release 11.1 of Oracle Database. The GRANT USE statements then permit the DEMO and SCOTT accounts to see the VERSION2 edition. Because the DEMO account is edition enabled, it will be able to modify the VERSION2 edition as well&it can change the implementation of various objects in this edition without affecting other editions in place. The SCOTT account will be able to use just this VERSION2 edition&to set its current edition in its session to VERSION2 and see the objects as they exist in that edition.
Now I&ll &patch& my application. Logging back in as the DEMO account, I&ll first see what I have in place after altering my session to use the VERSION2 edition, as shown in Listing 1.
Code Listing 1: Setting the VERSION2 edition and selecting procedures&
DEMO& alter session
set edition = version2;
Session altered.
DEMO& select object_name,
object_type,
edition_name
from user_
OBJECT_NAME
OBJECT_TYPE
EDITION_NAME
-------------
-----------
------------
MY_PROCEDURE2
MY_PROCEDURE
So, right now, in the VERSION2 edition, I have both PL/SQL units (MY_PROCEDURE and MY_PROCEDURE2), but as the EDITION_NAME column denotes, they are &inherited& from ORA$BASE. The VERSION2 edition is pointing at the copy in ORA$BASE; it is not a physical copy of the code.
I have to fix two bugs. First, I have a bug in the implementation of MY_PROCEDURE, and I will be replacing that code. Second, I missed a GRANT when I deployed my application&the SCOTT user was supposed to have had the EXECUTE privilege on MY_PROCEDURE2, but somehow that didn&t happen when I last installed the application. I&ll start by updating the code:&
DEMO& create or replace
procedure my_procedure
dbms_output.put_line
( 'I am version 2.0' );
Procedure created.
DEMO& select object_name,
edition_name
from user_
OBJECT_NAME
EDITION_NAME
-------------
------------
MY_PROCEDURE2
MY_PROCEDURE
As you can see, I still have only two objects&but there are really three physical objects there, as you&ll see in a second. I have MY_PROCEDURE2, which is inherited from ORA$BASE, and I have MY_PROCEDURE, which now physically exists in the VERSION2 edition. This is called actualizing the code&when I have a physical copy of the code in the edition, I have actualized the code in that edition.
Using a new set of views that see across all editions&and end in _AE&I can see the entire state of my DEMO schema. I query the USER_OBJECTS_AE view for OBJECT_NAME and EDITION_NAME:&
DEMO& select object_name,
edition_name
from user_objects_AE;
OBJECT_NAME
EDITION_NAME
-------------
------------
MY_PROCEDURE
MY_PROCEDURE2
MY_PROCEDURE
Looking across the editions, you can see that I have actualized two physical copies of MY_PROCEDURE now: one in the default ORA$BASE edition and one in the new VERSION2 edition I&m working in. Now I&ll apply the needed EXECUTE grant to SCOTT:&
DEMO& grant execute
on my_procedure2
Grant succeeded.
DEMO& select object_name,
edition_name
from user_
OBJECT_NAME
EDITION_NAME
-------------
------------
MY_PROCEDURE2
MY_PROCEDURE
DEMO& select object_name,
edition_name
from user_objects_AE;
OBJECT_NAME
EDITION_NAME
-------------
------------
MY_PROCEDURE2
MY_PROCEDURE
MY_PROCEDURE2
MY_PROCEDURE
If you look at USER_OBJECTS, you&ll see that I have the two procedures but that both have now been actualized in the VERSION2 edition. By granting the EXECUTE privilege on the MY_PROCEDURE2 stored procedure to SCOTT, I made a physical version of the stored procedure appear in the VERSION2 edition, and I applied the grant in that edition in isolation, without encountering any concurrency issues (blocking/locking issues because someone was running the procedure). Looking at USER_OBJECTS_AE, you can see that there are now four physical objects, two in each edition.
Now when I run the MY_PROCEDURE2 stored procedure in the VERSION2 edition, I see&
DEMO& SELECT SYS_CONTEXT
('userenv',
'current_edition_name') sc
FROM DUAL;
----------------------
DEMO& exec my_procedure2
I am version 2.0
PL/SQL procedure successfully completed.
The version 2.0 code is executed.
Now by simply connecting&and therefore using the database&s default edition (still ORA$BASE)&I instead see&
DEMO& connect demo/demo
Connected.
DEMO& SELECT SYS_CONTEXT
('userenv',
'current_edition_name') sc
FROM DUAL;
-----------------------
DEMO& exec my_procedure2
I am version 1.0
PL/SQL procedure successfully completed.
The version 1.0 code is still there, and by default it will be executed.
Further, to see the effect of the EXECUTE privilege I granted to SCOTT, I can connect as SCOTT and try to execute the MY_PROCEDURE2 stored procedure in the default edition and the VERSION2 edition, as shown in Listing 2.
Code Listing 2: Executing my_procedure2 in current and VERSION2 editions&
DEMO& connect scott/tiger
Connected.
SCOTT& SELECT SYS_CONTEXT
('userenv',
'current_edition_name') sc
FROM DUAL;
-----------------------
SCOTT& exec demo.my_procedure2
BEGIN demo.my_procedure2; END;
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DEMO.MY_PROCEDURE2' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SCOTT& alter session
set edition = version2;
Session altered.
SCOTT& exec demo.my_procedure2
I am version 2.0
PL/SQL procedure successfully completed.
As you can see, when SCOTT is using the ORA$BASE edition, SCOTT cannot see or execute the MY_PROCEDURE2 stored procedure. However, in the VERSION2 edition, SCOTT can see and execute that procedure, so when version 2.0 of the application goes into production, SCOTT will get the ability to execute that procedure by default.
At this point, I&m ready to release this application code to production to be used by the user community at large. A single, simple ALTER DATABASE issued by the DBA sets the current edition for the database to VERSION2, and this code becomes immediately accessible.
I would like to point out that this is just the tip of the iceberg. Here I had to do relatively common operations: replace some existing PL/SQL units and change grants on some objects. I did not take the entire application from version 1.0 to version 2.0, because that would have involved changing tables and other objects that are not &editionable.& So what this column has discussed so far is the very common need to &patch& a system, whereby you need to apply code changes and privilege changes but no physical schema changes such as adding columns, adding indexes, and altering tables. I will be addressing how to approach those tasks in the next column.
Until then, look at Chapter 19 in Oracle Database Advanced Application Developer&s Guide 11g Release 2 (11.2), at .
Look, Nothing Up My Sleeve
Historically, when you or an application created any database object&a table, an index, anything that consumed storage&the database would create the appropriate segments and allocate at least one initial extent. This extent might be small&say, 64K&but it was allocated.
Although creating one new 64K extent sounds small, if you do something small over and over, it starts to add up. For example, some third-party (or in-house-developed) applications create hundreds or even thousands of tables that never get used, but new corresponding segments and extents are nevertheless created. (The application tables would be used if you used a particular feature or option of the application, but in many of our installations, we do not use these tables.).
Enter a new feature of Oracle Database 11g Release 2: Deferred Segment Creation. It can be set systemwide (via an init.ora parameter), session by session, or even at the data definition language (DDL) statement level. I&ll demonstrate this with a session setting, which is probably what you would use with a third-party install script to have the creation of the initial extents deferred until data is actually placed into each segment.
First, I&ll demonstrate what has happened historically when we&ve created objects in the database and observe just how many segments might be created by a very small, simple CREATE TABLE statement, as shown in Listing 3.
Code Listing 3: Create one table, create many segments&
SQL& alter session set
deferred_segment_creation=
Session altered.
SQL& create table t1
constraint t1_pk
primary key,
constraint t1_y
store as t1_z_lob
(index t1_z_lobidx);
Table created.
SQL& select segment_name,
extent_id,
from user_extents
order by segment_
SEGMENT_NAME
------------
T1_Z_LOBIDX
I ran this DDL in a schema that had no created objects whatsoever, so every segment you see was created by that single CREATE TABLE statement. I have segment T1 for the table data, T1_PK for the default index created in support of the primary key, T1_Y for the default index created in support of the unique constraint, T1_Z_LOB for the large object (LOB) segment created in support of the character large object (CLOB) column, and finally T1_Z_LOBIDX for the LOB index created on the LOB segment. A simple CREATE TABLE statement (with three columns) meant the creation of five segments!
Next Steps
Tom Kyte answers your most difficult technology questions. Highlights from that forum appear in this column.
READ more Tom
Oracle Database Concepts 11g Release 2 (11.2)
READ more about
Edition-Based Redefinition
Oracle Database Advanced Application
Developer&s Guide 11g Release 2 (11.2)
Deferred Segment Creation
Oracle Database Administrator&s Guide 11g
Release 2 (11.2)
Now, let&s see what can happen if I enable Deferred Segment Creation, as shown in Listing 4.
Code Listing 4: DEFERRED_SEGMENT_CREATION=TRUE&
SQL& alter session set
deferred_segment_creation=
Session altered.
SQL& create table t2
constraint t2_pk
primary key,
constraint t2_y
store as t2_z_lob
(index t2_z_lobidx);
Table created.
SQL& select segment_name,
extent_id,
from user_extents
order by segment_
SEGMENT_NAME
------------
T1_Z_LOBIDX
As you can see, no new segments have been created, even though I executed a CREATE TABLE statement that was identical to the first (with the exception of the names). That is the goal of Deferred Segment Creation: to defer the allocation of storage until we need it. So, let&s need some storage and see what happens:&
SQL& insert into t2
values ( 1, 2, 'hello world' );
1 row created.
SQL& select segment_name,
extent_id,
from user_extents
order by segment_
SEGMENT_NAME
------------
T1_Z_LOBIDX
T2_Z_LOBIDX
10 rows selected.
Now I see the segments&my INSERT statement caused their creation. (Note that the statements used to create these segments were executed as a recursive transaction and committed immediately. Even if I were to roll back the insert, the segments would remain.)
Tom Kyte is a database evangelist in Oracle&s Server Technologies division and has worked for Oracle since 1993. He is the author of Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions (Apress, 2005) and Effective Oracle by Design
(Oracle Press, 2003), among others.
About Oracle
Top Actions
Key Topics
Integrated Cloud Applications & Platform ServicesAccess denied | www.shinyshiny.tv used Cloudflare to restrict access
Please enable cookies.
What happened?
The owner of this website (www.shinyshiny.tv) has banned your access based on your browser's signature (3b12fc-ua98).Access denied |
used Cloudflare to restrict access
Please enable cookies.
What happened?
The owner of this website () has banned your access based on your browser's signature (3b12fca-ua98).Access denied | baseballhall.org used Cloudflare to restrict access
Please enable cookies.
What happened?
The owner of this website (baseballhall.org) has banned your access based on your browser's signature (3b12fc-ua98).CHARTS & TRENDS
There was an error trying to load your rating for this title.
Some parts of this page won't work property. Please reload or try later.
I'm Watching This!
Error Please try again!
Added to Your Check-Ins.
1,017 user
383 critic
A giant great white shark arrives on the shores of a New England beach resort and wreaks havoc with bloody attacks on swimmers, until a local sheriff teams up with a marine biologist and an old seafarer to hunt the monster down.
(screenplay),
(screenplay)
Popularity
Jumanji: Welcome to the Jungle
Replicants, superheros, and reboots await you in our Fall Movie Guide. Plan your season and take note of the hotly anticipated indie, foreign, and documentary releases, too.
Related News
17 October
PM, +08:00
17 October
PM, +08:00
16 October
AM, +08:00
Powered by ZergNet
User Lists
Related lists from IMDb users
a list of 43 titles
created 06&Dec&2013
a list of 35 titles
created 31&Oct&2014
a list of 41 titles
created 01&Jan&2015
a list of 49 titles
created 19&Feb&2016
a list of 46 titles
created 18&Oct&2016
Connect with IMDb
Share this Rating
Want to share IMDb's rating on your own site? Use the HTML below.
You must be a registered user to use the IMDb rating plugin.
User Polls
10 wins & 18 nominations.
During a preview tour, a theme park suffers a major power breakdown that allows its cloned dinosaur exhibits to run amok.
Steven Spielberg
Sam Neill,
Laura Dern,
Jeff Goldblum
Police chief Brody must protect the citizens of Amity after a second monstrous shark begins terrorizing the waters.
Jeannot Szwarc
Roy Scheider,
Lorraine Gary,
Murray Hamilton
When Dr. Henry Jones, Sr. suddenly goes missing while pursuing the Holy Grail, eminent archaeologist Dr. Henry "Indiana" Jones, Jr. must follow in his father's footsteps to stop the Nazis from getting their hands on the Holy Grail first.
Steven Spielberg
Harrison Ford,
Sean Connery,
Alison Doody
Archaeologist and adventurer Indiana Jones is hired by the U.S. government to find the Ark of the Covenant before the Nazis.
Steven Spielberg
Harrison Ford,
Karen Allen,
Paul Freeman
Rocky Balboa, a small-time boxer, gets a supremely rare chance to fight heavy-weight champion Apollo Creed in a bout in which he strives to go the distance for his self-respect.
John G. Avildsen
Sylvester Stallone,
Talia Shire,
Burt Young
A seemingly indestructible humanoid cyborg is sent from 2029 to 1984 to assassinate a waitress, whose unborn son will lead humanity in a war against the machines, while a soldier from that war is sent to protect her at all costs.
James Cameron
Arnold Schwarzenegger,
Linda Hamilton,
Michael Biehn
John McClane, officer of the NYPD, tries to save his wife Holly Gennaro and several others that were taken hostage by German terrorist Hans Gruber during a Christmas party at the Nakatomi Plaza in Los Angeles.
John McTiernan
Bruce Willis,
Alan Rickman,
Bonnie Bedelia
A weatherman finds himself inexplicably living the same day over and over again.
Harold Ramis
Bill Murray,
Andie MacDowell,
Chris Elliott
Marty McFly, a seventeen-year-old high school student, is accidentally sent thirty years into the past in a time-travelling DeLorean invented by his close friend, the maverick scientist Doc Brown.
Robert Zemeckis
Michael J. Fox,
Christopher Lloyd,
Lea Thompson
After a space merchant vessel perceives an unknown transmission as a distress call, its landing on the source moon finds one of the crew attacked by a mysterious lifeform, and they soon realize that its life cycle has merely begun.
Ridley Scott
Sigourney Weaver,
Tom Skerritt,
A boy who communicates with spirits that don't know they're dead seeks the help of a disheartened child psychologist.
M. Night Shyamalan
Bruce Willis,
Haley Joel Osment,
Toni Collette
57 years later, Ellen Ripley is rescued by a deep salvage team during her hypersleep. The moon from the original movie has been colonized, but contact is lost. This time, colonial marines have impressive firepower, but will that be enough?
James Cameron
Sigourney Weaver,
Michael Biehn,
Carrie Henn
Cast overview, first billed only:
(as Jeffrey C. Kramer)
It's a hot summer on Amity Island, a small community whose main business is its beaches. When new Sheriff Martin Brody discovers the remains of a shark attack victim, his first inclination is to close the beaches to swimmers. This doesn't sit well with Mayor Larry Vaughn and several of the local businessmen. Brody backs down to his regret as that weekend a young boy is killed by the predator. The dead boy's mother puts out a bounty on the shark and Amity is soon swamped with amateur hunters and fisherman hoping to cash in on the reward. A local fisherman with much experience hunting sharks, Quint, offers to hunt down the creature for a hefty fee. Soon Quint, Brody and Matt Hooper from the Oceanographic Institute are at sea hunting the Great White shark. As Brody succinctly surmises after their first encounter with the creature, they're going to need a bigger boat.
Written by
Plot Keywords:
You yell shark, and we got a panic on our hands on the Fourth of July.
Certificate:
Parents Guide:
Official Sites:
Release Date: 20 June 1975 (USA)
Also Known As: Tiburón
Filming Locations:
$8,000,000
(estimated)
Opening Weekend:
$7,061,513
(22 June 1975)
$260,000,000
Production Co:
Show detailed
(Extended Edition)
Sound Mix:
(Westrex Recording System)|
(Dolby 5.1)|
(DTS 5.1)|
(DTS HD Master Audio)
Aspect Ratio: 2.35 : 1
Did You Know?
The blowing up of the shark was scheduled for the last day of the shoot. Four cameras were trained on it. , however, was not there. He decided that before the crew did any kind of wild prank on him to mark the end of principal photography, he would just leave quietly. He and
were on a plane to Boston when the actor turned to him and asked how the final shot went. When Spielberg answered, smiling, "They're shooting it now," Dreyfuss began laughing hysterically.
After Quint chops the rope to stop the boat from being pulled by the shark, a calm moment follows during which the men are just catching their breath. After a few seconds, three barrels suddenly appear, but during that time, you can see the barrels in the foreground just under the water, waiting to be released and pop to the surface.
[first lines]
What's your name again?
Where are we going?
Crazy Credits
The producers gratefully acknowledge the cooperation of The Nation Geographical Society and Mr. L.J.V. Compagno of the Department of Biological Sciences, Stanford University.
Connections
Referenced in &(2016)
Soundtracks
Untitled Improvised Campfire Guitar Music
(uncredited)
Performed by
Frequently Asked Questions
(Spoiler Alert!)&&
User Reviews
&Jaws& is a thrill-ride of suspense that continues to deliver the goods to the audience 25 years later.
The plot is somewhat thin: a large shark is terrorizing the tourists at the local beach.
However, with that said Steven Spielberg's direction is amazing.
The young director (only 28 at the time) showed unlimited potential that would only increase with age.
A great accomplishment that could have been a multi-million dollar bust.
5 stars out of 5.
82 of 152 people found this review helpful.&
Was this review helpful to you?
Contribute to This Page
Recently Viewed
Find showtimes, watch trailers, browse photos, track your Watchlist and rate your favorite movies and TV shows on your phone or tablet!
Follow IMDb on
Copyright &}