 | | | Oracle List | |
Thanks indeed Mark Ananda Prashant Mogens Cheng Nial Folks for the
inputs.
Mark - There are 16 Disks in 4 LUNs (each LUN contains 4 Disks).
Respective Redo Logs are on an additional LUN.
Norman Dunbar.
Contract Oracle DBA.
Rivers House Leeds.
Internal 7 28 2051
External 0113 231 2051
> > > amonte <ax.mount@(protected) > 08/03/06 07 29am > > >
> http //miracleas.dk/index.asp?sprog Does anyone ever get any problems from users who don 't want to apply the
cpu patches? For example we have users who don 't want to apply them
because
1. the test system is different from the prod Greetings
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for IBM/AIX RISC System/6000 Version 9.2.0.6.0
> Hi
>
> We are setting up a new library for access to the database where we want
> to replace the old still oci 7
> interface by occi
> When we create a connectionpool with min 3 session max 5 According to Oracle the issue is a known bug 4901231 which is fixed in
oracle 9208 and oracle 10
I am currently upgrading this database to Oracle 10 and should be able to
confirm whether this is
the cJack
I have not used MTS but in general you can only have one program
listening on a port on a given machine. If there are separate dispatcher
processes for each instance I would expect different-- Repost due to overquote.
I use Solaris + Oracle 10.2 in VMware Server. Both Solaris and Oracle
64 bit. I have AMD Athlon 64 bit CPU.
2006/8/2 John Dunn <jdunn@(protected) >
> I need some clarifica > Could someone shared their experieces on compressed
> backup especially with big sized database.
Red Hat Enterprise Linux ES release 3 (Taroon Update 4)
Oracle Database 10g Release 10.2.0.2.0 SE
I recall some tests I did in the past and I think that adding a new column
to a large table with a default value utilizes significantly more redo than
adding the column with null running an update toRoger
The coalesce command combines leaf blocks within the same branch of the
index tree. Unless you know how fragmented the index is it could be
difficult to predict how much redo is generated.
Hi Paula
The gotcha if you don 't load with any indexes and constraints is that you need a lot of temp tablespace to build them but experience says that it will be a lot faster overall to apply constIf your interval is the string you provided I would expect
the next run date to be 9/5/2006 00 30.
Selecting the string from dual provides that date. If the job failed
then the scheduler will set Yes perhaps developers will actually use it now. I am sure on many an
occasion they did not look at the docs because it required registration.
On 8/1/06 Jared Still <jkstill@(protected) > wrote
>
>
>I 'm not sure what you 're attempting to do with that first loop but both
it and the state_sql variable are unneeded.
Perhaps a perusal of the docs is in order?
http //download-west.oracle.com/docs/cHi
I have some queries with ORs in 8i which ahd this plan
0 SELECT STATEMENT Optimizer RULE
1 0 SORT (ORDER BY)
2 1 TABLE ACCESS (BY INDEX ROWID) OF 'S_LST_OF_VAL '
3
There is only 2 weeks left for you to submit abstracts for the
AUSOUG/OAUG National Conference Series for 2006. The Call for Papers
closes Monday 14th August.
We are continuing our acclaimed NationPay also attention if some of those columns has been used in the where
clause with a range condition.
If such put this column(s) at the end of the index. The reason why you can
find in the book of J
> > >A 4-node RAC BIG benchmark with Oracle 10g / AIX 5.3L using a
Hybrid Banking App. is underway.
uh have you measured at 1 2 and 4 nodes ?
also when did the definition of "Large " start to inCannot reproduce it on Solaris 8
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit and
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit.
SYS@(protected) > set echo on
SYS@(protected)Here 's the environment
RDBMS 10.1.0.4 (standard edition)
OS RHEL AS 3
User "X " has "RESOURCE " priviledge and NOT given explicit "quota " to tablespaces
"DATA " and "INDX ".
The tablespaces has datList
With Oracle Label Security I can block access to records and columns to
specific users. Can I allow access to a column within a record to only
specific information? I was asked this by a "d > > For control file autobackups. are their problems with setting the format
> > to
> > something besides the default?
Yes restore ... from autobackup will change if certain conditions are met.
RegSorry to beat this into the ground but the more I read the more questions I have.
Wolfgang 's paper mentions Oracle 's calculation of density (page 6 of "Histograms Myths and Facts ")
* Without a hiHow about recovering the data file on the machine where the log file
exists?
Others have already suggested the rownum 1 (or rownum <2) trick if you 're
really just checking for existence.
Barring that isn 't this pretty much what bit map indexes were created for?
True you 'll hSo I wanted an update on what Scott had to say about PL/SQL in 10g and of
course I bought the Oak Table book.
Now I?ve gotten this from Amazon
We 've noticed that customers who have purchased Oracl >and I ended up drinking 100 grams of vodka at a time against a very young lady who well out-drank me to be honest.
It 's never late to learn.
>If they claim they can generate these stats in no tAll I 'm having trouble getting client connections to connect to the
?open? database in a DG environment.
Here is what I have
Red Hat 4.3 Oracle 10GR2
Node 1 RH1PROD
Node2 RH2DEV
P DEV service nSalary $90 000 - $100 000
General Comments
New consulting firm needs to hire a strong ORACLE DBA to work in various
industries. This owner/manager wants a candidate who does not want to
relocate b |
|
|
