 | | | Oracle List | | Check to see what is running when these ora-600 happen.
Check your snapshots this will tell you alot. Waits what sql is running etc.
Very powerful and helpful. You may need to change then I should have mentioned in my original email that I was looking for suggestions additional tips and constructive critism to my work. I have to do a presentation to a users group and I would value peHello
A batch runs daily at night which takes around 5 hours to complete. Following is the AWR report for 30 minutes during the batch.
Before "SQL Ordered by Reads " Section of the AWR repYou can select from v$sess_io and see if it is doing any IO.
Also 10046 trace will show if anything is happening ( which is
probably what you are seeing in v$session_event.
I 'd search metalink for bugRan into this article and am wondering if anyone has this setup and/or comments about this article?
http //www.dell.com/downloads/global/power/ps2q07-20070242-Ahmadian.pdf
Many Thanks
LIt deals with my Windows 3G issues and how we turned it around for now.
Kathy
No errors during OCR initialization before that?
What does "ocrcheck " show?
On 5/4/07 Robert Freeman <robertgfreeman@(protected) > wrote
> Trying to install RAC on VMWARE (Win host 2 RH Ent
> Linux aNow I 'm interested.
Anticipating a blow by blow description if you want help understanding what
is happening I have a couple questions
1) Did you shut down just the database or the whoHi
I have to create MV on the prebuilt table as have some weird req to
replicate 10g DB on 9i DB. Client migrated to 10g from 9i and want all data
to be replicated till they get satisfied from 10g.
I am running Oracle 10.2.0.2.0 on HPUX B.11.23.
We have an application which complains that it is getting the date in
'DD-MON-RR ' format.
I changed nls_date_format for the database using
alter sys
I just saw your posting at
http //www.ardentperf.com/2007/05/04/recovering-your-controlfile-without-a-backup
You didn 't actually "recover " the controlfile.
You really "restored " it.
You had done a Hi all
I have noticed that my sort_area_size was very small - 64K. After
increasing it to 5M the waits did not disappear
completely but they took mush fewer time.
thank you all who responded
Gen
Everybody
How do I pick a unicode character set? I need to build a new database and
the vendor 's requirement is a unicode char set. There are several unicode
character sets. How do I decide on whic
Yes besides the fact that the Data Dictionary check can make files
go "MISSING "
the OPEN RESETLOGS actually *initializes* your online redo logs.
So it does make sense to backup your online redo
Interesting..
Question In your recovery testing what was the exact sequence ? Was it ?
a) Restore an older controlfile binary backup -- only
controlfile restored datafiles being current
Good explanation! I was just going to say hit cancel.
Joel Patterson
Database Administrator
joel.patterson@(protected)
x72546
904 727-2546
-----Original Message-----
From oracle-l-bounce@(protected)
The "USING BACKUP CONTROLFILE " tells Oracle that the SCNs in the
Controlfiles are NOT
the current ones . Oracle keeps prompting for as many archivelogs as
you have available because
it does not kJohn
Before you start recreating control files just do a couple of sanity
checks
Are the disk mount points and directory names exactly the same?
If so can you do a "startup mount " commRichard Dennis
the whole idea is from an development department from our company so i
don 't know why they did not proposed that ( will ask) You mention a
serious issue both in maintenance and secall
does anyone has a docs about clusterware comparation against oracle clusterware?
is the OS cluster better than oracle clusterware?
--
regards
ujang
--
http //www.freelists.org/webpage/oracle-lHow about
Execute Immediate 'Select ' '/* ' || sys_context( 'USERENV ' 'SESSION_USER ')
|| ' */ ' SysDate From Dual
I may not have the single quotes just right but I 'm headed for the
shower so you Dear RAC/ Oracle App experts
Let me preface this question with I have very limited exposure to both RAC
and Oracle apps but I have been asked to help with this issue. Unfortunately
I don 't even knowBill
I don 't know TDE details but here is a thought for you. In my observation
Oracle tends to provide the foundation for a feature in one database
version and then make it more practical in the Thanks!
Joel Patterson
Database Administrator
joel.patterson@(protected)
x72546
904 727-2546
-----Original Message-----
From Siva Valiveru [mailto SValiveru@(protected)]
Sent Thursday May 03 Eric
We did this at my previous job. Versions were logged in a table and of course the row for the new version wasn 't inserted until the patch script completed successfully. It 's true that this dI finally get the chance to recover from a failure and it turns out to
be the worst kind - DW (NOARCHIVELOG)
10.2 on RedHat
I am using Robert 's excellent RMAN book (which was delivered to me from
I 'd copy that last file from the primary system onto the standby and
then restart the recovery. You might also have to run a datafile rename
too.
..................................................Hi Joop
> In the new situation it will be be 1 or 2 10G release 2
> RAC Clusters with each one " shared " database. Oracle Label
> security must assure that on row level the different companies
> can Shiva
This is normal behaviour. If you dont like this or is causing issues for
your App please look at documenation on using INSTANCE_GROUPS
&PARALLEL_INSTANCE_GROUP
INSTANCE_GROUPS is a Real AWow. Software RAID. People still use that?
Seriously its usually not too hard to justify the cost of pushing the RAID
logic into the hardware layer.
Software RAID can consume a lot of CPU cycles. |
|
|
