Recent comments @weblog

Comment on AWE -What is It and How to use it? by Jargo

Hi Amit, your article was really a great help!! Though we are still trying to get some good working settings.
Our RMAN backup still fails whatever we try..
Maybe you have got some ideas:

Oracle 9.2i
CPU’s = 8
Total ram = 16GB

AWE is set at 536 870 192

DB_BLOCK_BUFFERS = 384216
sga_max_size = 1500M
shared_pool_size = 500M
PGA_AGGREGATE_TARGET = 700M

/3GB and /PAE are set in boot.ini.

We have tried several configs with all different sizes for SGA, PGA, block_buffers etc. but still we get:

MAN-03002: failure of backup command at 06/24/2010 14:26:10

ORA-04030: out of process memory when trying to allocate 1049100 bytes (pga heap,KSFQ Buffers)

with our RMAN..
Do you have any suggestions to get RMAN working again? Must be something with PGA i would suspect!

Thanks!!!
regards,
Jargo

Comment on DBMS_SCHEDULER jobs not running? by Amit

Thanks Aman. Yes above link is also very informative..

Regards
Amit

Comment on DBMS_SCHEDULER jobs not running? by Aman....

There is another thread by the same guy Ravi,
http://forums.oracle.com/forums/thread.jspa?messageID=2304463&#2304463

This is about external jobs. Very nice!

Aman….

Comment on Simplified Approach to Resolve ORA-4031 by Andy D.

Thanks so much. This helped me out a lot.

Andy.
http;//www.Franklinfaces.com

Comment on Issues with CLUSTER_DATABASE parameter by Orlando

Maybe it was inserted in the spfile a time ago and you didn’t notice.
I had similar issue this weekend,

*.cluster_database =false and also
sid.cluster_database =true

present in the spfile, inserted by another dba.

Comment on Issues with CLUSTER_DATABASE parameter by Amit

Thanks Arul. I am aware of the parameter precedence, but not sure why the parameter had instance specified to it. If we are using spfile and do not specify sid parameter it takes default value of “*” by default.

Regards
Amit

Comment on 11gR2 Database Installation with ASM on OEL5 by Amit

Thanks Gaurav. I have corrected the link now. Let me know in case you still face issues.

Regards
Amit

Comment on Issues with CLUSTER_DATABASE parameter by Arul

Its might be too late and you might have figured out teh root cause by now.

In case you haven’t, In a RAC environment SID.parameter=value takes the precedence over *.parameter=value.

So if you use alter sytesm without sid clause it defaults to * and if tehre is an existing entry with explicit “sid.” in spfile, you alter system will not work for this particular instace.

Hope this explains…

Comment on 11gR2 Database Installation with ASM on OEL5 by Gaurav

Hi Amit,

Links provided are not working as being incomplete.

Thanks-
Gaurav

Comment on Downloading Oracle Software directly to Server by Log Buffer #191, A Carnival of the Vanities for DBAs | The Pythian Blog

[...] Askdba.org, Amit advises on downloading Oracle software directly to server in a post based on Pythian’s downloading from OTN directly to your database server. Watch for [...]

Comment on Generating Datapump Export Dump with Dumpfile name Containing Current Date and Time by Lorenzini

After much thought I believe your title “ generating datapump export dump with dumpfile name containing c…” looks reddish-brown on my GPS browser.

Comment on UNKNOWN State Of RAC Resources by Murali Venkatraman

Excellent. Very useful.
Thanks
Murali

Comment on Downloading Oracle Software directly to Server by Bradd Piontek

Great update to Pythian’s blog. I had been meaning to write something similar for downloading from edelivery.oracle.com and My oracle Support (no cookies involved, and is much simpler , works like a champ. We’ll see how my June shapes up for blogging).

Comment on Downloading Oracle Software directly to Server by Raju Angani

Plugin for FF 3.6
https://addons.mozilla.org/en-US/firefox/addon/66579/

Comment on Downloading Oracle Software directly to Server by bob

Nice

Bob

Comment on Downloading Oracle Software directly to Server by jametong

Very good tips, so many times, I have to use links (a text based url browser to download something on linux command line. thx.

Comment on Downloading Oracle Software directly to Server by Amit

Thanks Dev.

Comment on Downloading Oracle Software directly to Server by dev

Brilliant Amit.