| Author |
Message |
   
Scallion
Junior Artist Username: Scallion
Post Number: 145 Registered: 05-2009 Posted From: 65.217.188.20
Rating:  Votes: 8 (Vote!) | | Posted on Friday, June 12, 2009 - 09:28 am: |
    |
Maverick:tammud..burleson consulting vadu cheppindi 3 posts esava
Aniyaaa , I am the one who posted there Jai TDP. Jai Jai NTR |
   
Maverick
Hero Username: Maverick
Post Number: 10271 Registered: 01-2008 Posted From: 69.136.169.198
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, June 11, 2009 - 09:33 pm: |
    |
Scallion:
tammud..burleson consulting vadu cheppindi 3 posts esava.. tenali..solaris 10 10g r2..pga at 4 sga at 3 10k post : why do u want to do pmp? |
   
Tenalodu
Junior Artist Username: Tenalodu
Post Number: 85 Registered: 04-2008 Posted From: 69.249.206.75
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, June 11, 2009 - 06:39 pm: |
    |
which OS is this ? if it's *nix post top o/p here. |
   
Scallion
Junior Artist Username: Scallion
Post Number: 140 Registered: 05-2009 Posted From: 65.217.188.20
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, June 11, 2009 - 05:44 pm: |
    |
Try changing the setting of âulimitâ as follows, it may resolve the issue: ulimit âa time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) 4194302 memory(kbytes) unlimited coredump(blocks) unlimited nofiles(descriptors) 4096 Jai TDP. Jai Jai NTR |
   
Scallion
Junior Artist Username: Scallion
Post Number: 139 Registered: 05-2009 Posted From: 65.217.188.20
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, June 11, 2009 - 05:42 pm: |
    |
Decrease sort_area_size and/or hash_area_size this might also help Jai TDP. Jai Jai NTR |
   
Scallion
Junior Artist Username: Scallion
Post Number: 138 Registered: 05-2009 Posted From: 65.217.188.20
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, June 11, 2009 - 05:39 pm: |
    |
See as well on Oracle Database Control the field below the PGA_AGGREGATE_TARGET, there you can find the maximun value for PGA, se if its higher than the acctual parameter value... Jai TDP. Jai Jai NTR |
   
Disc
Junior Artist Username: Disc
Post Number: 495 Registered: 02-2009 Posted From: 66.45.237.210
Rating:  Votes: 3 (Vote!) | | Posted on Thursday, June 11, 2009 - 04:44 pm: |
    |
konchum water poyi sysremlo ani set avuthayi ani chanti thambi chepadu(j/k) chiru ni...nilabetti gochi lagesaaru |
   
Wrathchild
Side Hero Username: Wrathchild
Post Number: 4307 Registered: 03-2009 Posted From: 192.146.101.71
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, June 11, 2009 - 04:43 pm: |
    |
ORA-04030: out of process memory when trying to allocate XX bytes Increased pga_aggregate_target to 4gigs swap space 23 gigs. Not helping..any thoughts? tia |