| orauday |
Posted: May 05, 2007 04:41:49 PM |
Total Post: 4
Joined: Mar, 2007
|
Hello,
I need the answers for the following questions.
1. What does 's' stand in oracle 8s?
2. What does 'i' stand in oracle 9i?
3. What is CLOB and BLOB data capacity?
4. Difference in oracle 8i and 9i? |
|
|
 vikhardba |
| Posted: May 06, 2007 12:49:28 AM |  |
|
Total Post: 85
Joined: Apr, 2007
|
The major diffferences are-
In 9i merge, insert all, case is introduced.
In 9i new datatype called timestamp is introduced.
In 9i you can moniter index using alter index <index name> monitering usage
or
u can check user_objects table from system user.
In 9i new performance monitering tools called STATPACK .
In 9i You can dynamically change init.ora parameter (For ex: "alter system set resource_limit=true scope=memory;" )
In 9i new concept for undo transaction called UNDO tablespace
In 9i by default TEMP tablespace is considering while creating new oracle users
In 9i new partition called LIST
In 9i tablespace next extent can be managed automatically
|
|
|
|
|
| vikhardba |
| Posted: May 06, 2007 01:03:00 AM | |
|
Total Post: 85
Joined: Apr, 2007
|
The biggest difference between Oracle8i and Oracle9i is that Oracle9i lets You resize the SGA memory areas dynamically i.e., the Database Buffer Cache DB_CACHE_SIZE or the SHARED_POOL_SIZE, etc., can be resized when the database is up and running. The same is not possible with Oracle8i.
|
|
|
|
|
| anand |
| Posted: May 07, 2007 01:53:33 AM | |
|
Total Post: 1
Joined: May, 2007
|
i - stands for internet application
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
