 | | | Oracle List | | I have two tables with basic views on top of them. And I need to run some
basic
sql against the database. The stuff you see in the body of the explain plan.
Neither table is that big. About 200Okay to be fair brconnect is useful b/c SAP will do whatever it wants with statistics etc. So you can create it on one of the 20 000+ tables to improve a query brconnect will drop it. Good badHas anyone out there done an upgrade from 8.1.7.4 to 10g on Sun Solaris?
Also I plan on changing my character set from UTF8 to AL32UTF8. Has anyone
simply altered the database to change the characThis is a test because I am having problems sending email to
oracle-l@(protected) <mailto oracle-l@(protected) > .
--
http //www.freelists.org/webpage/oracle-l
And the fine manual says (shared server oracle 9.2)
--- quote
The appropriate number of dispatchers for each instance depends upon
the performance you want from your database the host operatin
Well I just upgraded a 300gig 9.2.0.4 NT database to ten today - 20
(And those oracle Scripts sure needed some coaxing to work!
Next and final step
is RMAN migrate to Linux only worry is 3000 iYou 're welcome.
Was able to confirm (2 minutes after sending first reply) that DATE
datatype does not handle timezone in any way shape or form. And pardon my
syntax mistake the new-ish 9i dataJonathan
Very true representation of that monster. Wonder why Oracle
never included that graphic in their docs. Now excuse me while I salve
the wounds it 's added to my backside over the yearHi Dennis
>On a test server we are configuring multiple Oracle installs by
manipulating
>/var/opt/oracle/OraInst.loc. This seems to work for installing Oracle
but
>when I create a database
Whoa whoa everyone calm down! Just trying to inject a little dry
humour! Please take what I said with a pinch of salt!
Please close this thread before this gets out of hand!
-----Orig
Just sounding out opinions.
Is anyone using the all new all singing and all dancing 10g Grid
Control/Enterprise manager in a full live production environment? After
years of keeping away 9.2.0.6 on Solaris 2.8 no issues or improvements that we noticed.....
This is a test and uat platform that we are developing a new app to
replace one that currently uses over 100 modems and
Gut feel would say that even though it doesn 't appear to use the index
perhaps it actually is at execution time - there is no other way the
presence of an index can change the result set.
Hi
I 'm new to the list so apologies if you 've already
had a zillion of these posted.
I 've written a search plugin for Firefox to allow you
to search Metalink from the toolbar. I know zilch
abThis was the first patch I have ever done so I appologize if this
questions seems too elementary.
I applied the 9205 patch set to a win2k Advanced Server db. Im
curious if this would have any eI was able to get this code to work on my server. I want to thank
everyone who helped out with this. It is a great relief.
James Kramer
THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHave any of you had to define (for SOX or otherwise) what specific
operations should be performed by SYS versus other administrative
operations that can be performed by a user granted DBA privilege?WordPad an option? 20
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Edgar Chupit
Sent Wednesday December 08 2004 12 54 PM
As I mentioned yesterday when we were in discussions with Oracle Tech
reps and Sales reps they informed us unequivocally that all that
mattered is the PHYSICAL count of CPU 's hyperthreading / muDoes anyone know the algorithm that Oracle uses to spawn DBWR processes
in Oracle9i2 ? We are running two instances of 9.2.0.4 (from the same
Oracle home) on a 40-CPU SunFire 15K server. One is an 1Hi
I pay referral fees if the referral results in a hire. Therefore if the
position
described below is not a match for you (i.e. qualifications location etc)
but you know
of someone who woul
SQLPlus looks in 2 places for scripts to execute
1) in your current working directory
2) in the SQLPath registry value
Relative pathnames are understood by SQLPlus but they are relative to
youTry something like this
CREATE TYPE obj1 AS OBJECT
(
emp_no NUMBER
emp_name VARCHAR2(20)
)
CREATE TYPE tab_obj1 AS TABLE OF obj1
CREATE OR REPLACE PROCEDURE proc1
(
inHi Jaromir
>In case when all indices on the partitioned table are defined local
there is
>really not very much "value added " in the global statistics. (Of course
in
>case when e.g. the locaWe have Hotsos on-site this week teaching their SQL Optimization Course 2E 20
It is truly the best SQL Optimization course I 've ever taken!
Sriram Ramachandran <sriram_kr_2000@(protected) 2Ecom > It 's called "phishing " or fishing for suckers folks gullible and willing
enough to hand over credit card numbers PINs passwords SSNs etc. Usually
it 's pretty obvious because there are so many
"why the additional 2 Gb 20 of memory the Sysadmin added to the
production server was not improving 20 our OLTP transaction response
time 2E "
That 's the best one in ages!
You can 't jusOur limit for 4K block is 16Gb (Oracle limit). Or limit for 8k is 32Gb
(HP-UX limit) minus first 8k or something which Oracle skips.
This is true for raw devices and filesystems.
--
Best regardHi All
Does anybody have an idea what OCIDBAccess.free_temp_alloc(Native Method) does?
We are using JDBC OCI to make db connections from appserver. The JVM
(java virtual Machine) goes down intThere is a paper on appsdba.com that describes how to do this with 8.0
RMAN. Even though it 's incredibly old it still may be of some help. For
what you want to do I don 't think too much has chan |
|
|
