 | | | Oracle List | | Earlier this week SarBox auditors wanted proof that DBA 's
could not change database stored procedures (which would
prevent DBA 's from applying vendor patches for vendor
supplied stored procedures)Carel-Jan Engel wrote
> Hi Larry
[...]
>
> You can copy the whole software tree (e.g. /opt/oracle/...) including
> admin directories. Under 8i this works fine from 9i onwards it is
> gettiA failure of a hardware RAID controller (driver perhaps) caused this
(along with GBs of trace files)
Fri Feb 18 20 15 45 2005
Running with 1 strand for Non-Enterprise Edition
Running without d10.1.0.3 EE on w2k3 EE (32 bit)
dual 3.6 GB Xeon hyperthreading enabled.
8 GB mem
had cursor_sharing exact ... was trying to get by without resorting to
setting it otherwise.
shared pool was sHi
How can I know what is Windows 2003 block size. 20
I mentioned db_block_size 3D8192 in init file but it is 16384 after
database creation. I see this value in v$parameter after database is Hello
I am trying to run tkprof and am encountering this error.
"could not allocate space of size 328 "
It 's a 3gb trace file with 4gb RAM on the Win2k machine with 8gb swap
Any ideas?
ThanTrace it using event 10046.
On Fri 18 Feb 2005 12 20 33 -0700 Bryan Wells <bunjibry@(protected) > wrote
> All...
>
> I am finally getting around to using this utility. I have a 200+gb DW
> on w2k. My question is there a gRudy Zung wrote
>I don 't think Oracle has a built-in function for that but you can
>cobble one
>together with
> length(myString) - nvl(length(replace(myString 'O ')) 0)
>
>...Rudy
> All
Occasionally I have a Cognos report that gets run and runs out of TEMP
space (ORA-1652). I don 't have the opportunity to talk to the person
running the report so I don 't exactly know whatHi all
hope someone can save me some time (busy trying examples and jsut running into walls sorry late on Friday guess brain is weekend mode already)
busy trying a POC atm regarding AQ.
Birkir
How is this DWH using the Logical Standby?
If you use it for E.G. ETL you might consider switching to Physical
Standby and open that in Read Only mode periodically.
It will easier keep uHello
the dbtimezone reflects the actual timezone the database itself has been
created with.
the sessiontimezone is your client 's current time zone.
they both if not explicitly set are derI join to this kidding
I think that both Mladen and Juan Carlos could get enourmous success on
an Italian TV program called "Zelig " where actors do cabaret.
Since every actors team must have a nBirkir Bjornsson wrote
>
>
> Im running a logical standby DB and I was wondering what happends if I set
> transaction_consisstency parameter to none. The logical standby is behind by
> alm
Does anyone use 9i RMAN for VLDB 's? I need to keep the a full backupset
compressed on disk by directing files for RO tablespaces to one directory
and rotating RW tablespaces in another directoryThere has t be something really wrong in there as I just finished
truncating a 37G table
Table truncated.
Elapsed 00 01 26.29
Table dropped.
Elapsed 00 00 06.23
Took a minute 2Environment 9i RAC 2 Node veritas cluster
One of the datafile got corrupted in test environment and restored
form RMAN backup.
However even after recovery it gave me "ORA-01187 cannot read fContent-Type text/plain
charset "us-ascii "
Content-Transfer-Encoding quoted-printable
Dear All
20
Are there any convention which number UID and GID that I have to use for
'oracle ' os uWe are running a bunch of Linux servers... 64 Bit have a few that are
32 bit... Red Hat 3
If you look at cpuinfo... there is a flag... "lm "
Red Hat site is less than helpful from what I have fEnvironment 9i RAC 2 Node veritas cluster
One of the datafile got corrupted and restored form RMAN backup.
However even after recovery
I used to get "ORA-01187 cannot read from file 7 becauseOn Fri 18 Feb 2005 11 02 25 -0600 Knight Jon <jknight@(protected) > wrote
> Thanks to everyone for the suggestions. And Jared ... I guess I should
> give him a break but I can only pay $1Juan Carlos Reyes Pacheco wrote
>
>Based on this waits
>db file scattered read 2 588 531 0 4 836 2 ########
>db file sequential read 1 847 717 0 environment
OS RH Linux EL 3 w/smp
OCFS Version -14 ELsmp
Platform HP Blade server technology - BL20 P servers (2 nodes)
SAN StorageTec D280
we got OCFS installed on the 2 nodes clustDavid
This porbably won 't help much until you get your CSI access but there is
a patch (3555863). You can also try to run the install logged in
locally not in a domain (assuming you are onCan someone tell me whether or not I can install Forms and Reports
with Oracle 10gAS Ver2 (10.1.0.2) or do I need to install 10gAS Ver1
(9.0.4) to get Forms and Reports as well? I looked at the In
I 'm trying to find the oracle workflow version to download that works with the 9i database.
Technet only seems to have a 10g version but maybe I 'm looking in the wrong place what with all the nLeonard George wrote
>Hi there
>
>Looking for someone that has used this tool before.
>
>
I used sledgehammer on a machine that used to run oracle. It was an
Ultrix MIPS 3000 box.
SatisI would suggest you have the enqueue populate to the remote database queue
and deal with it locally.
Nick
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bouHi all
I have a query that is currently doing a huge amount of table scans
(know the resolution to this) and is also causing a lot of cache buffer
chaining (Top wait event 20 min in a 29 min wi |
|
|
