| Oracle9i - suitable platform WinNT or Solaris? [message #50406] |
Thu, 14 March 2002 02:11  |
Prabhakar
Messages: 9
Registered: April 1999
|
Junior Member |
|
|
Hi Harsha,
Let me introduce as Prabhakar. I have some knowledge
of Oracle 8. While browsing the net, I came across the
www.orafaq.net site and got a chance to access your
mail id. I need to have some information on Oracle9i
and would be delighted if you can help me. The
questions are listed below.
1. Is there any prefered platform for installation of
Oracle 9i.
2. Does the performance of Oracle 9i depend on the
platform installed.
3. Are there any features by which the search
functionality of the database be improved.(other than
indexing and creating stored procedures)
4. Does the Application Server that comes by default
is J2EE compliant.
5. Do we need to do any modification to the code
running on any other J2EE compliant server(say Web
Logic or iPlanet Web Server) to be ported/migrated to
the Oracle Application Server.
6. Do we have any search components in this similar to
that available in MS SQL server.
I would be very thank ful to you, if these questions
are answered. Hope you would respond and help me in
understanding the product better and clear.
Thanks in Advance,
Prabhakar
|
|
|
|
| Re: Oracle9i - suitable platform WinNT or Solaris? [message #50413 is a reply to message #50406] |
Thu, 14 March 2002 07:00  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
hi,
1. Is there any prefered platform for installation of
Oracle 9i.
-> NT,solaris,HP,AIX and all major OS are supported by orale. see www.docs.oracle.com for more information.
2. Does the performance of Oracle 9i depend on the
platform installed.
-> i personally prefer solaris,HP for oracle. because of feautures of administration and STABILITY. Note that performance also depends on the hardware(memory,disk rpm, cpu , networks etc).
3. Are there any features by which the search
functionality of the database be improved.(other than
indexing and creating stored procedures)
-> tons of features are available.
cache the frequently used objects ( tables, procedures)
proper type of raid and partitining (for range search).
seperate the datafile and indexes in different disk.
clustered indexes, partitioned indexes.
increase the sort area size and temporary segments.
optimizer modes
etc.
most important, using the EFFICIENT SQL ( using indexes,joins, identical sql statements etc).
4. Does the Application Server that comes by default
is J2EE compliant.
-> yes.
5. Do we need to do any modification to the code
running on any other J2EE compliant server(say Web
Logic or iPlanet Web Server) to be ported/migrated to
the Oracle Application Server.
-> sorry i have no idea.
6. Do we have any search components in this similar to
that available in MS SQL server.
-> u can use full text indexing, use CONTAINS in the query after creating full text catalog, clustered index for range queries,avoid table scans etc.
im not an MSSQL person. My knowledge is very limited.
Hope this may help u
Mahesh Rajendran
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
