 | | | Oracle List | | Hi
The cluster interconnect should not be configured with Virtual IP.
Load balancing is at the connection level. So if the users disconnect and reconnect they will connect to the correcThis seems to be such common sense that I would be surprised if such a
thing exists.
So why don 't we create it right here? I 'll start.
First is there a reason that you *cannot* use an Oracle da > If you define CLASS VARCHAR2(2000 CHAR) then you can insert 4000 chars
> irrespective of their single- or multi- bytes.
Yep when your NLS_LENGTH_SEMANTICS is set to CHAR (or you specify it at the
Larry
> > Got an import from a client that kept getting
> > IMP-00003 ORACLE error 1450 encountered
> > ORA-01450 maximum key length (6398) exceeded
> > when creating index for table below.
You n <html > <div style 'background-color ' > <DIV class RTE >We have installed Oracle 9i on a new HP-UX 11i server. In .NET application we are getting ora-12571 and ora-3114 errors intermittently. There iHi again
As I have mentioned in my previous post I have installed a database in a HA
environment using Service Guard. In the past I have always installed the
software and created the database in the Has anyone successfully used DBMS_METADATA 's SCHEMA_EXPORT capability to
generate DDL for all schema objects? If so please let me know perhaps
you 'll be good enough to take a look at my code and teHi all
I am in process of performing a 14 node Oracle Application Server Release 2
installation. All active-active except the database which will be
active-passive.
There are 6 nodes which forms thUntil the next version of Oracle 11XL-xyz...
...when new self managing "features " are announced...
...and the "End of the DBA " proclaimed (again).
o|
Seems the more they add the more questions I gAre you perhaps comparing contractor/consultant rates to salary? Well
given that you talking about the height of the tech insanity (I mean
"bubble ") maybe you 're not. 'Course any company that 's p is better (just for example) - 10 CPUs at 1GHz each or 5 CPUs at 2GHz?
Of course for the purpose of discussion we have to assume all other
system components are identical and since this is an OraclPaul
Library cache locks are held on Library cache object handles whereas Library
cache pins held on data heaps.
Pins are held in shared mode to read data heap / to avoid modifications of
dependant Hi all
does any one here implementing ASM for production?
for how long?
which platforms?
which size of database?
OLTP/DWH?
and finally what do you think about it?
Regards
Oded.
--
http //www.frList
I need to make a transaction faster or determine that it cannot be made
faster. Resulting in smaller transaction size and/or rewrite the sql
statement. The situation is I have a db server rHello list!
OS HPUX 11.11
Oracle 8.1.7.4 EE
I 'm facing right now a "file open " wait for a specific session as follows
This select is returning the same result for like one hour
select subHas anyone succesfully resized an ASM disk drive online ?
--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group
--
http //www.freelists.org/webpage/oracle-l
QUESTION
CPUJAN2006 does not seem to be available from metalink for 9.2.0.4. Will it be
released? When?
ANSWER
Sorry but there is NO CPUJAN2006 patch and will NOT be one..please up
Probably 2 temporary tablespaces can be created. Users writing poor queries could be assigned to one of them and critical applications use the other temporary tablespace.
Unfortunately Oracle The 2 nested loops are causing the delay.
try to changing to "hash join " changing parameters
by increasing db_file_multiblock_read_count at session level
using logon trigger
also cAs I recall the capability to have multiple inventories was introduced
with 10gR1. I wouldn 't know for certain though as I don 't have any
10g in production just now. -( I recall that Oracle
This was posted to bugtraq. I can 't find the patch number they reference but
jancpu2006 advisory does credit Imperva.
Oracle DBMS ? Access Control Bypass in Login
****************************Just a wild guess but I think you 'll find this on the RDBMS (server)
installation media. Just choose "Client " instead of "Database " in the
installer.
You can download the media from OTN as usual
Good afternoon all
O9.2.0.7 OS AIX 5.2
One of our applications requires that we drop and recreate
packages procedures and functions every night. This is not a problem as it
stands but we are inWell may be because since RAC works quite well with RAW devices and ASM are
like raw devices.... -o
It?s not a requirement though
When you say cost do you mean $$$? AFAIK ASM doesnt need a seperateJay
> Can anyone recommend some good books or whitepapers on OLAP in >general and Essbase in particular?
Haven 't seen much in the way of resources ie. books or whitepapers
but it has been awhile
Raj
You could and I 'm making this up as I go along do something like
CREATE TABLE hospital(acct# NUMBER medrec# NUMBER dx1 NUMBER dx2
NUMBER dx3 NUMBER)
ALTER TABLE hospital ADD CONSTRAIN As a wild guess you 're on a Windows PC of some description and you 've
got more than one ORACLE_HOME?
Does your TNSPING provide any more info
Used parameter files
c \oracle\ora92\network\admin\sq
Afternoon Gints
Norman Dunbar.
Contract Oracle DBA.
Rivers House Leeds.
Internal 7 28 2051
External 0113 231 2051
> > > Gints Plivna <gints.plivna@(protected) > 01/18/06 03 30pm > > >
> > Hello allHemant
I took a look at out 11.0.3 instance and do see the OWA% packages
therein.
John
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On BehWhat exactly in the SAR reports that points you to the fact that the
CPU is not used?
Why do you expect it to be used ? Do you have 24 parallel sessions doing work?
Could it be that your DISK is too |
|
|
