You have to consider that DDATE is a date field and not a CHAR string. You would need to explicitly convert the literal CHAR string to date eg. to_date('01-JUN-03','dd-MON-yy') or something like that
What do your queries look like?
And where do the indexes sit on your tables?
I don't believe 2 million rows are terribly significant.
200 million rows maybe ;-)
My installation fails immediately.
It appears that I don't have a supported version of the Java package installed.
* The failure message:
Initializing Java Virtual Machine from /tmp/OraInstall2003-06-18_10-25-29PM/jre/bin/java. Please wait...
There was an error trying to initialize the HPI...
In this side-issue to getting Oracle set up, I think I have finally reached finality! phew...
I issued an "ipcrm -q 10" knowing that such a queue does not exist. The instruction fails, as expected.
Then I perform "sysdef" and, by George, the parameters are listed as required...
OK, subsequent investigations have led to this answer:
"As Sun explained this to me, your shared memory setting are correct and the system recognizes them. However, since Solaris uses a dynamic kernel, the setting won't take affect until a process attempts to use them. (i.e. Oracle, IBM...
sysdef will indeed provide info on kernel parameters.
However, not quite all are listed.
In particular, during my pre-installation procedure of Oracle 9i I cannot get confirmation (after booting) of the
shared memory and semaphore kernel parameter settings.
I'm investigating ndd to see if this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.