GeekInterview.com
Series: Subject: Topic:
Question: 188 of 203

difference between oracle 8i and 9i ?

Asked by: Interview Candidate | Asked on: Feb 6th, 2006
Showing Answers 1 - 9 of 9 Answers
rajat dey

Answered On : Feb 20th, 2006

The major diffferences are-In 9i merge , insert all, case is introduced .In 9i newdatatype called timestampIn 9i you can moniter index using alter index monitering usageor 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 using alter system scope=/path/ of your spfile/pfileIn 9i new concept for undo transaction called UNDO tablespace In 9i by default   TEMP tablespace  is considering while creating new oracle usersIn 9i new partition called LISTIn 9i tablespace next extent can be managed automaticallyregrdsrajat dey

  
Login to rate this answer.
Jawwad

Answered On : Feb 21st, 2006

View all answers by Jawwad

Dear Rajat, CASE statement is already there in Oracle 8i.  So, which version of Oracle r u talking about ?

  
Login to rate this answer.
Deep Chandra Pandey

Answered On : Mar 28th, 2006

There are many differences between oracle 8i and oracle 9i(1) In oracle 8i default tablespace is dictonary managed while in 9i it is locally managed.(2)Oracle 9i can support 512 PetaByte of data.(3)Oracle can supprt 10,000 concurrent users.(4)oracle 9i provides auto undo segment management.and there a lot difference in oracle 9i and 8i as 9i Support RAC Concept.Thanks and Regards.Deep Chandra PandeyOCPDBA

  
Login to rate this answer.
arun oommen

Answered On : Aug 30th, 2006

Thanks a lot.

  
Login to rate this answer.
rajatm2

Answered On : Sep 5th, 2006

View all answers by rajatm2

Jawwad Malvi who told u ??? pls verify ....

  
Login to rate this answer.
raghukumar

Answered On : Sep 7th, 2006

Differeneces between 8i and 9i1. Undo Retention2. Incremental level backup using export and import is not there in Oracle 9i3. Lot of simplified scripts for RMAN backup and Recovery when compared to Oracle 8i4. In Oracle 9i Rollback segments (undo) is managed automatically by Oracle.cheersRaghu

  
Login to rate this answer.
madhan

Answered On : Oct 8th, 2006

Thank u

  
Login to rate this answer.
Rajendra Thanekar

Answered On : Apr 28th, 2007

1)  connect internal (SVRMGR) is not supported in 9i now you can manage database with SQL*plus.2) SPfile in 9i which is not available in previous version. Helpful for those init parameter those need server reboot.3) SGA is dynamic i.e buffer cache and shared pool can be dynamically increased or decreased.4) by default now table-space are locally managed to improve performance as free space management is done in the header of the data file instead of dictionary.5) Default TEMP table space and default UNDO table space can be specified at the create database statement level.6)dbms_meta data a new package introduced which helps to generate DDL from the database instead of writing PL/SQL Block.7) Multiple block size support.8) Merge statement is introduced in Oracle 9i.9) ANSI Support for join i.e inner-join,outer-join,left-outer join keyword introduced instead of operator (+)10) newly introduced Rollback segment management (UNDO)

  
Login to rate this answer.
dnkreddy

Answered On : Nov 30th, 2008

View all answers by dnkreddy

8i-materilized views, instead of triggers, support internet, granting of columns
9i-timestamp, rename of column, new datatypes, rank, dense_rank, 9i joins

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Oracle Backup and Recovery Interview Questions

Oracle Basics Interview Questions

Oracle Architecture Interview Questions

D2K Interview Questions

Data Access Interview Questions

Oracle DBA Interview Questions

Oracle security Interview Questions

Database Tuning Questions

Oracle Distributed Processing Interview Questions

Oracle Concepts Interview Questions

Oracle Memory Management Interview Questions

Oracle Forms Interview Questions

PL/SQL Interview Questions

Programmatic Constructs Interview Questions

RMAN Interview Questions

Real time Oracle Interview Questions

Oracle SQL Interview Questions

SQL*Plus interview Questions

Oracle System Architecture Interview Questions

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.