Any Oracle DBA's here Chalanachithram.com | Topics | Search
Hide Clipart | Log Out | Register | Edit Profile

Last 30 mins | 1 | 2 | 4 hours     Last 1 | 7 Days

Chalanachithram.com DB » TF Industry related » Archive through September 18, 2008 » Any Oracle DBA's here « Previous Next »

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachin
Side Hero
Username: Sachin

Post Number: 3754
Registered: 04-2008
Posted From: 70.112.201.205

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 17, 2008 - 05:07 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Kadapanagfan:




inthakee nee problem eto naaku ardham avvatledu...
I HATE CASTE FANATICS
Top of pagePrevious messageNext messageBottom of page Link to this message

Kadapanagfan
Side Hero
Username: Kadapanagfan

Post Number: 6276
Registered: 12-2006
Posted From: 13.8.137.11

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 17, 2008 - 05:07 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Maverick:




sga 512 mb chaala takkuva anipistondi..



S adey antunnaru antha.......
Top of pagePrevious messageNext messageBottom of page Link to this message

Maverick
Side Hero
Username: Maverick

Post Number: 6074
Registered: 01-2008
Posted From: 192.146.101.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 17, 2008 - 05:06 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Kadapanagfan:

SGA memory baaaga pani chesey instnce ku 2GB undi anta where as eprfomance isssue vachey instance lo 512MB undi anta.......

adi increase setttey yemanna chala perofamce increase untada.....




sga 512 mb chaala takkuva anipistondi..

tammud procedures unte trace analyse cheyyandi
Top of pagePrevious messageNext messageBottom of page Link to this message

Kadapanagfan
Side Hero
Username: Kadapanagfan

Post Number: 6274
Registered: 12-2006
Posted From: 13.8.137.11

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 17, 2008 - 05:02 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Sachin:



annai bind variables vaadatam elaago naaaku thelusu



telsu vayya naaak koooda.....kaaani adi main issue kaaadu......bcs we have used same coading standards in our previous succesfull app also.........that may be one of the reason.....kaaani adey main reason kaaadu.........
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachin
Side Hero
Username: Sachin

Post Number: 3751
Registered: 04-2008
Posted From: 70.112.201.205

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 17, 2008 - 05:00 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Kadapanagfan:




annai bind variables vaadatam elaago naaaku thelusu
I HATE CASTE FANATICS
Top of pagePrevious messageNext messageBottom of page Link to this message

Kadapanagfan
Side Hero
Username: Kadapanagfan

Post Number: 6273
Registered: 12-2006
Posted From: 13.8.137.11

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 17, 2008 - 04:58 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

After analyzing the database performance reports during this time we found that
âExecute to Parseâ ratio is very low, and this is due to higher number of parsing.
We need to rewrite queries to use more bind variables.
Also we will increase the SGA memory.
----------------------------------------------------

pai mail vachindi naaaaku.........memu poyina year oka APP live lo yettamu .......daaani perfomance bramhandanga undi........

Similar apppp ipppudu pilot testing setunnamu ........chala slow ga undi perfomance......

DB tho koorchuntey aaadu final ga adi telchadu.....SGA memory baaaga pani chesey instnce ku 2GB undi anta where as eprfomance isssue vachey instance lo 512MB undi anta.......

adi increase setttey yemanna chala perofamce increase untada........
Top of pagePrevious messageNext messageBottom of page Link to this message

Maverick
Side Hero
Username: Maverick

Post Number: 6069
Registered: 01-2008
Posted From: 192.146.101.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 17, 2008 - 04:46 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

dba kaadu kani..i can try telisinantalo
Top of pagePrevious messageNext messageBottom of page Link to this message

Kadapanagfan
Side Hero
Username: Kadapanagfan

Post Number: 6271
Registered: 12-2006
Posted From: 13.8.137.11

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 17, 2008 - 04:43 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

untey oka sari ikkadaku randi...chinna info kavali.......

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x9055648){Movie Clipart}
Show / Hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  


Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: