 | | | Oracle List | | Hi Sam
Not sure what SQL OEM executes but the Tom Kyte script looks ok. I
like Steve Adams ' script which can be found at
http //www.ixora.com.au/scripts/sql/enqueue_locks.sql
Also as to exac > I 'm trying to test a conversion from raw to filesystems.
> a couple of questions am planning to use dd
> this is AIX 5.2
> i know to convert from raw to filesystem there is an filesystem headerHello everyone out here
Is there a way to get the listing of all file names in a directory
pointed by an entry in dba_directory in oracle9i into a collection in
pl/sql procedure.
Thanks & RegaHello all
If anyone has requested posting privileges recently
and has not seen a (belated) response from me yet
then please ask again because your email probably
got lost.
@ Regards
@ Steve
Larry
the EXEC phase seems to have visited a huge number of blocks 475 439
(disk) 21 600 279 (query) 2 563 509 (current) for two executions.
Something spooky here methinks o)
Cheers
Norman.
Make sure that the role is set as a default for that user
ALTER USER DEFAULT ROLE <role1 > <role2 > <roleN >
or
ALTER USER DEFAULT ROLE ALL
if you want the user to have all of the roles assigned toyou could create a new table insert the data truncate old one modify the
column and them insert back in - then you dont have to worry aboutindexes /
constraints etc
On 2/8/06 Michael Ray <topshotHi
AFAIK "Session Param Value " chunks are allocated as freeable. But you can easily confirm the same by taking a heapdump at level 2 using the following command
alter system set events 'iI have a production host using RMAN connected to a recovery catalog. I set
up scheduled jobs in OEM to perform the backs and archive the redo logs.
The OEM (management server) which also contains Hi
I was wondering how to restore an Oracle 9i RMAN backup from a location
where it was not backed up to.
For example I backed up the database to F \ I then take this backup to
another Server whereInside Metalink use the Certify tab. I followed "By Platform " then "Linux
(AMD64) ". It came up with this so yes it is supported. The only unsupported
configuration is running 32-bit software on Why do you want to replace the inline view with an external view? The
statement is doing a join to a view. Inline views are generally a very
effective way to code SQL statements.
IMHO -- Mark D PoYAGRTDE (Yet Another Good Reason To Document Everything) or at least
every time you change something from it 's default/previous value.
What works well with this version of the optimizer won 't necess
Has everyone forgotten that Unbreakable was actually
a program specifically related to Linux. The program
means that the software is Unbreakable but oh if it
does break then Oracle will even dive Is anyone using Secure Path with EVA8000 's?
We are struggling with how to configure it for use with ASM.
Secure Path does not provide a single virtual path for active/active
arrays
like the EVA8000.
Morning J Dex
Norman Dunbar.
Contract Oracle DBA.
Rivers House Leeds.
Internal 7 28 2051
External 0113 231 2051
> > > "J. Dex " <cemail_219@(protected) > 02/07/06 03 10am > > >
> > How can the UNDExperiencing strange problem on a small Dell "box " (dual CPU PE1850 with
6GB RAM build in SCSI and 2x146GB HDDs) with RHEL 4 EL and Oracle 10gR2
with 5 toy databases attempt to create sixth toy Folks
I have an 11i (11.5.0)/9.2.0.6 (64-bit) database running on Solaris 8
with the following shared pool sizing
Shared_pool 1.2 GB
Db_cache_size 6 GB
ODM is enabled and that is why the cache sI have an Oracle 10g (10.1.0.4.0) installation....
How important is the following patch.....
Does anyone already applied this patch....anything to watch out for?
Oracle vulnerability
Oracle is adOr at the very least maybe OPatch could check the
exit status for the 'ar ' command it *thought* it
invoked and maybe take appropriate action if it
failed...
After all it is also possible to find I received the following from folks working on the GLAST project the Gamma Ray Large Area Telescope. The skymodel mentioned is a Monte Carlo simulation to check on the ability to collect data. It iPlease move my daily newsletter to my personal email doc_sewell@(protected)
instead of the current william.sewell@(protected) The State of
Florida blocks your site.
William Sewell
<br > <font sAll
Here is my situation - winxp pro oracle 10.2
Goal set up dataguard on a laptop for demo purposes Primary files are
on C \... standby are on E \...
actual db name RECO unique_primary_naOn 05/02/06 Mladen Gogala <gogala@(protected) > wrote
> On 02/05/2006 01 17 26 PM Jared Still wrote
> > Even those problems that are addressed by security problems are
> > not always corrected rAnyone have experience in getting LogMnr to run just a tad faster? ?
Vital stats Oracle 9.2.0.6 Tru64 5.1 1GB redologs.
I 'm trying to retrieve a DELETE statement and eventually undo it. ?Its acroKevin
You can take the statistics from production and import them into the test
environment. This will make the CBO make the same choices as it would with
the same amount of data as production. ExThat 's not a synonym.
Standby redo log files can be created and act similar like the online
redo log files if a database is in standby mode.
The RFS process (which resides on the standby) is then ablHas anyone experienced performance problems after applying cpujan2006 on
aix 5.1? We applied it yesterday and are seeing slow response from at
least 2 sqls. One is getting high waits on latch_free_wHi
A third party made for us an application in three tier architecture.
In the middle tier it has the application code Oracle Data Provider
for .NET release 9.2.0.4.
The middle tier software runs iExact same question I wanted to ask -)
I have not used hotsos profiler either but having been using orasrp
for several months and I thought it is pretty neat.
In addition to Jay Miller 's questions |
|
|
