Oracle performance tuning 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 June 27, 2013 » Oracle performance tuning « Previous Next »

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

Buduguuu
Hero
Username: Buduguuu

Post Number: 14742
Registered: 01-2012
Posted From: 24.107.4.53

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

Posted on Thursday, June 27, 2013 - 08:26 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Morning bump for sachin
Coolmac : nanu comment sesey staayi ledhu neeku

Biryani about Mahesh Babu
Top of pagePrevious messageNext messageBottom of page Link to this message

Buduguuu
Hero
Username: Buduguuu

Post Number: 14741
Registered: 01-2012
Posted From: 24.107.4.53

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

Posted on Wednesday, June 26, 2013 - 11:42 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Sachin:

replied



Done :-)
Coolmac : nanu comment sesey staayi ledhu neeku

Biryani about Mahesh Babu
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachin
Legend
Username: Sachin

Post Number: 34895
Registered: 04-2008
Posted From: 68.55.138.131

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

Posted on Wednesday, June 26, 2013 - 11:19 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Buduguuu:

Done



replied
Top of pagePrevious messageNext messageBottom of page Link to this message

Buduguuu
Hero
Username: Buduguuu

Post Number: 14739
Registered: 01-2012
Posted From: 24.107.4.53

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

Posted on Wednesday, June 26, 2013 - 10:54 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Sachin:

sachin_ccdb@yahoo.com ki mail cheyi...



Done :-)
Coolmac : nanu comment sesey staayi ledhu neeku

Biryani about Mahesh Babu
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachin
Legend
Username: Sachin

Post Number: 34894
Registered: 04-2008
Posted From: 68.55.138.131

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

Posted on Wednesday, June 26, 2013 - 10:44 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Budugesh...i might be bale to help you...repu bump kottuko thed ni...

sachin_ccdb@yahoo.com ki mail cheyi...
Top of pagePrevious messageNext messageBottom of page Link to this message

Emc2
Hero
Username: Emc2

Post Number: 13154
Registered: 03-2008
Posted From: 71.246.229.243

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

Posted on Wednesday, June 26, 2013 - 02:59 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Buduguuu:

naku ivem teleedu. interview waste antaara



telavakapothe US ki enduku vastharu ayya ani twitter adagamannadu..
Happy Anniversary

Top of pagePrevious messageNext messageBottom of page Link to this message

Megapowerkkd
Comedian
Username: Megapowerkkd

Post Number: 1345
Registered: 05-2008
Posted From: 158.48.133.2

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

Posted on Wednesday, June 26, 2013 - 02:58 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Buduguuu:

naku ivem teleedu. interview waste antaara

hints,indexes,dbms_profile,explain plan, cost enti chaduvu ko.apend hit,parallel hint kooda chaduvo.kummey.oracle-base site choodu..concept baba isthadu.
Top of pagePrevious messageNext messageBottom of page Link to this message

Emc2
Hero
Username: Emc2

Post Number: 13153
Registered: 03-2008
Posted From: 71.246.229.243

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

Posted on Wednesday, June 26, 2013 - 02:57 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Buduguuu:



performance tuning book undi chaduvu,

performance and tuning lo konni points..

query optimization, table spaces tuning,index tuning, data model tuning, adanna mata..ala oko point cheppukuntu povali..
Happy Anniversary

Top of pagePrevious messageNext messageBottom of page Link to this message

Ustad
Hero
Username: Ustad

Post Number: 13441
Registered: 07-2008
Posted From: 98.149.191.187

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

Posted on Wednesday, June 26, 2013 - 02:54 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Buduguuu:

naku ivem teleedu. interview waste antaara


give a shot....nothing to lose right?
Bragging is a mask for insecurity. Truly confident people are quiet and unassuming.
Top of pagePrevious messageNext messageBottom of page Link to this message

Ustad
Hero
Username: Ustad

Post Number: 13440
Registered: 07-2008
Posted From: 98.149.191.187

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

Posted on Wednesday, June 26, 2013 - 02:54 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Buduguuu:

naku ivem teleedu. interview waste antaara


give a shot....nothing lose right?
Bragging is a mask for insecurity. Truly confident people are quiet and unassuming.
Top of pagePrevious messageNext messageBottom of page Link to this message

Buduguuu
Hero
Username: Buduguuu

Post Number: 14735
Registered: 01-2012
Posted From: 24.107.4.53

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

Posted on Wednesday, June 26, 2013 - 02:51 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Ustad:



naku ivem teleedu. interview waste antaara :-)
Coolmac : nanu comment sesey staayi ledhu neeku

Biryani about Mahesh Babu
Top of pagePrevious messageNext messageBottom of page Link to this message

Ustad
Hero
Username: Ustad

Post Number: 13439
Registered: 07-2008
Posted From: 98.149.191.187

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

Posted on Wednesday, June 26, 2013 - 02:47 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Megapowerkkd:

not for developer mama..may be DBA.AWR AND ADDM reports.


I guess it depends on what client is looking for. If they want someone come in to tune their sql programs then I am sure they expect the consultant to know about AWR and ADDM reports.
Bragging is a mask for insecurity. Truly confident people are quiet and unassuming.
Top of pagePrevious messageNext messageBottom of page Link to this message

Megapowerkkd
Comedian
Username: Megapowerkkd

Post Number: 1339
Registered: 05-2008
Posted From: 158.48.133.2

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

Posted on Wednesday, June 26, 2013 - 02:42 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Ustad:

Don't forget to read about AWR reports. The first place I check to find problem SQL.

not for developer mama..may be DBA.AWR AND ADDM reports.
Top of pagePrevious messageNext messageBottom of page Link to this message

Ustad
Hero
Username: Ustad

Post Number: 13437
Registered: 07-2008
Posted From: 98.149.191.187

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

Posted on Wednesday, June 26, 2013 - 02:40 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Buduguuu:


Don't forget to read about AWR reports. The first place I check to find problem SQL.

Also, get some idea about table fragmentation...one of the most common problem at lot of sites.
Bragging is a mask for insecurity. Truly confident people are quiet and unassuming.
Top of pagePrevious messageNext messageBottom of page Link to this message

Buduguuu
Hero
Username: Buduguuu

Post Number: 14703
Registered: 01-2012
Posted From: 24.107.4.53

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

Posted on Wednesday, June 26, 2013 - 01:56 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Khaleja:



thanks. inkoka kochen. veedu financial client. nuvvu face chesina most complex problem enti ante em cheppali? oka maanchi masala example vadalandi. naa daggara anni tuutambar examples unnai. i dont have experience on a alarge scale database
Coolmac : nanu comment sesey staayi ledhu neeku

Biryani about Mahesh Babu
Top of pagePrevious messageNext messageBottom of page Link to this message

Khaleja
Side Hero
Username: Khaleja

Post Number: 3546
Registered: 09-2009
Posted From: 99.67.74.174

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

Posted on Wednesday, June 26, 2013 - 01:28 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
http://www.dbspecialists.com/files/presentations/use_explain .html

http://docs.oracle.com/cd/B10500_01/server.920/a96533/sqltra ce.htm

1st link follow ayipo. naku aa concept ippatiki sarigga radam kadu. all the best.
Top of pagePrevious messageNext messageBottom of page Link to this message

Gandhiguevara
Legend
Username: Gandhiguevara

Post Number: 38979
Registered: 10-2009
Posted From: 98.199.212.117

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

Posted on Wednesday, June 26, 2013 - 01:23 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Buduguuu:

chesinollu evaranna unnara? interview oti undi. aa angle lo prep avvamani hints vachai. how do i approac?

re install chesthaa ani cheppu
Top of pagePrevious messageNext messageBottom of page Link to this message

Buduguuu
Hero
Username: Buduguuu

Post Number: 14700
Registered: 01-2012
Posted From: 24.107.4.53

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

Posted on Wednesday, June 26, 2013 - 01:20 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Megapowerkkd:

oracle performance and tuning doc vuntndhi danlo last 15 pages meeda focus cheyyi



oracle vad publish chesinada?
Coolmac : nanu comment sesey staayi ledhu neeku

Biryani about Mahesh Babu
Top of pagePrevious messageNext messageBottom of page Link to this message

Megapowerkkd
Comedian
Username: Megapowerkkd

Post Number: 1333
Registered: 05-2008
Posted From: 158.48.133.2

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

Posted on Wednesday, June 26, 2013 - 01:18 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
http://docs.oracle.com/cd/E11882_01/server.112/e16638.pdf.Pa rt-1v nunchi chaduvko.dbms_profiler.
Top of pagePrevious messageNext messageBottom of page Link to this message

Megapowerkkd
Comedian
Username: Megapowerkkd

Post Number: 1332
Registered: 05-2008
Posted From: 158.48.133.2

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

Posted on Wednesday, June 26, 2013 - 01:13 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Standard questions :
Difference between trandional insert and insert with append hint
how do you see explain plan
hints - hash/parallel/all hints oracle meeda focus cheyyi
oracle performance and tuning doc vuntndhi danlo last 15 pages meeda focus cheyyi
Top of pagePrevious messageNext messageBottom of page Link to this message

Buduguuu
Hero
Username: Buduguuu

Post Number: 14699
Registered: 01-2012
Posted From: 24.107.4.53

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

Posted on Wednesday, June 26, 2013 - 12:28 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Buduguuu:

yep.. koncem emanna site unte cheppandi annai. repu majjanam interview undi



nenu peroformce tuning meeda pedda work cheyyaledu. anduke ee tippalu. naaku raadu ani honest ga cheppeste bye ani first ee cheppestaru. atlest try anna cheddam ani aasa :-)
Coolmac : nanu comment sesey staayi ledhu neeku

Biryani about Mahesh Babu
Top of pagePrevious messageNext messageBottom of page Link to this message

Buduguuu
Hero
Username: Buduguuu

Post Number: 14698
Registered: 01-2012
Posted From: 24.107.4.53

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

Posted on Wednesday, June 26, 2013 - 12:25 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Katthi:

database or app servers?



databases. oracle :-)
Coolmac : nanu comment sesey staayi ledhu neeku

Biryani about Mahesh Babu
Top of pagePrevious messageNext messageBottom of page Link to this message

Buduguuu
Hero
Username: Buduguuu

Post Number: 14697
Registered: 01-2012
Posted From: 24.107.4.53

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

Posted on Wednesday, June 26, 2013 - 12:25 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Dreamcatcher:

oo jamana lo chaysaa...look up plan tables, hints, indexes..etc.



yep.. koncem emanna site unte cheppandi annai. repu majjanam interview undi :-)
Coolmac : nanu comment sesey staayi ledhu neeku

Biryani about Mahesh Babu
Top of pagePrevious messageNext messageBottom of page Link to this message

Dreamcatcher
Side Hero
Username: Dreamcatcher

Post Number: 4280
Registered: 11-2009
Posted From: 208.86.145.68

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

Posted on Wednesday, June 26, 2013 - 12:18 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Dreamcatcher:

oo jamana lo chaysaa...look up plan tables, hints, indexes..etc.



BTW, this is in the context of databases, queries, procedures, etc...
Top of pagePrevious messageNext messageBottom of page Link to this message

Dreamcatcher
Side Hero
Username: Dreamcatcher

Post Number: 4279
Registered: 11-2009
Posted From: 208.86.145.68

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

Posted on Wednesday, June 26, 2013 - 12:17 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
oo jamana lo chaysaa...look up plan tables, hints, indexes..etc.
Top of pagePrevious messageNext messageBottom of page Link to this message

Katthi
Side Hero
Username: Katthi

Post Number: 8642
Registered: 07-2010
Posted From: 24.34.30.248

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

Posted on Wednesday, June 26, 2013 - 12:17 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
database or app servers?
Top of pagePrevious messageNext messageBottom of page Link to this message

Buduguuu
Hero
Username: Buduguuu

Post Number: 14696
Registered: 01-2012
Posted From: 24.107.4.53

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

Posted on Wednesday, June 26, 2013 - 12:16 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
chesinollu evaranna unnara? interview oti undi. aa angle lo prep avvamani hints vachai. how do i approac?
Coolmac : nanu comment sesey staayi ledhu neeku

Biryani about Mahesh Babu

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x99533cc){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: