 | | | Oracle List | | Our upgrade went smoothly. We researched 9.1 and stopped due to bugs.
A year later we researched 9.2 and went forward. Of course the
upgrade was preceded by testing all critical pieces of code onHi
1) I have one instance that generates syntax errors with the following command
SELECT DBMS_METADATA.GET_GRANTED_DDL( 'DEFAULT_ROLE ' 'CBSLATE ')
FROM dual
ALTER USER "CBSLATE " DEFAULT
Doc ID 226531.995 says it all. I think everything before 8.1.7.4 wasn 't fun.
On Thu Feb 17 2005 at 04 48 41AM +0530 Chirag DBA wrote
> We got this error on one of the Production DB.
> NoWe got this error on one of the Production DB.
Nothing special on Metalink.
DB is 8.1.7.2 and OS is SOLARIS 5.9 64 bit.
Any one have gone through this error? Any solution...!!
- Chirag MajmundaWhy invent another wheel? What is wrong with Oracle 's definition?
Oracle 9i (9.2) Database Reference
Indicates the amount of order of the rows in the table based on the values
20
of the index.
I found this on metalink
select /*+ index(bdd_prov bdd_prov_idx) */ int_nom_inst
/* all columns that belong to the index */
from bdd_prov
where int_nom_inst int_nom_inst
Verify with explHi Ron
The first thing is what is slow for you?
Currently for me is very slow that I can do only few
thousands inserts into Oracle while some other so
called in-memory databases can do it much Thanks to everyone who responded.
It turns out that in AIX you have to turn on support for
large files ( > 2gb ) when you create a file system.
I verified that this was the problem when I triedConnect / as sysdba works for me. We have the password file set to
exclusive. Connect internal has been going away since 8.0. Since that is
where I started I always connect / as sysdba.
RuSounds like a contest. -)
Winner is first person to install 10g Standard Edition/RAC/ASM (single
or multi node RAC and ASM only) on RHEL4 on VMWare 5 and document
same.
Prize suggestions?
Well I wouldn 't place space issues in priority of failback.
Btw you can upgrade to 10.1 and then downgrade it back to any
patchset of 9.2 (don 't remeber about others). I tried it on our test
systHi
Rac Gurus
Has anybody implemented 10g1.0.3 rac on hp itanium
We are seeing lots of issues out here in the crs
The vip does not get failed over from node1 to node2
if the 1 node goes down
butHello list
May be this question might have asked server times before but I
never come accross.
How do we handle multiple databases with 10g Enterprise Console?
By default we can only manage anot really allowed to post copyrighted stuff elsewhere
On Wed 16 Feb 2005 10 01 32 -0500 Ray Stell <stellr@(protected) > wrote
>
> Inside the Solaris 64 bit 9.2.0.6 patch is a readme that sayclass.ForName is to register the JDBC Driver.
Either you can use class.ForName( "Driver ")
OR
you can use registerDriver method from DriverManager class as below..
DriverManager.registerDriverJohn
As I know it is the part of the standard edition too.
Regards
Zoran
--- John Dunn <jdunn@(protected) > wrote
> Is AQ available in 9i Standard Engine...or only in
> Enterprise?
>
Holy Toledo Batman I just noticed I have 50 gmail invites. How come
Starbucks still costs the same?
Regards
Mike Thomas
PS Just delete sorry for the spam. -)
--
http //www.freelists.oHi DBAs
We have a case here which is taking long time to perform a simple update (becoz
we are using unix shell scirpt instead of using a simple update statement)
we have 2 tables hs1 hs2 (with May I suggest you consider using Advanced Queuing. 20
Nick
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On Behalf Of Sami Seerangan
Senwithout the structure size indexes and statistist of the tables and
definition of the view there is too much for guessing.
If you 're so puzzle for this I suggest you to trace your statement and
Hi
>
> http //integrid.info/memory_latching.pdf
>
> This guy explains also latchless SCN in some details.
As "this guy " doesn 't have access to Oracle source code and the doc is about
pretI thought you couldn 't set NLS_CHARACTERSET on the client. Do you mean
NLS_LANG?
If you want to change NLS_LANG you could create a different batch file
for each application e.g.
set nls_lang E >-----Original Message-----
>Lex de Haan
>
> a column with a unique index is not good enough --
> otherwise it might be quicker but also give different results -)
> it must be an index on a NOTWhat is the output of 'ulimit -sa ' ?
On Tue 15 Feb 2005 15 53 53 -0500 Schauss Peter
<peter.schauss@(protected) > wrote
> Oracle 8.1.7.4
> Aix 5.2
> Using rman with catalog information in the
Note 547411.994 complains of slow performance after upgrading to
9.2.0.6. Anybody had a similar hit?
Sanjay Mishra wrote
>Can we check as when Index was last used from the
>dictioanry tables. Index are not in Monitoring mode
>and Statisitic Level is TYPICAL in the Oracle 9i
>database
>
>TIA
Copy all CD 's onto the host and place in directories named Disk1 Disk2
Disk3
Then run from Disk1 location....install goes much faster and is a whole
lot easier w/o having to change CD 's
--Hi All
Environment
We have 2 databases (both are active) physically located in different
geographical area(NJ and NY). Each DB has 2 node OPS (8i) and both
database replicates in Master-MasterHi
After tracing a slow running transaction I noticed
that most of the time was spent waiting on enqueue.
After drilling down further I saw the following line
multiple times in the trace filesHello list
Could any one give me the script or sql for the following requirements
If I need to know the 100th day of this year like If I pass value
100 want to extract the 100th day of the |
|
|
