Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best Practices

638933Apr 16 2009 — edited Apr 16 2009

Hi All,

Can i requst to give link,documents where by i find Oracle's recommandations to application developers.
I have coulple of VB/.NET/JAVA/C# applications poiting to Oracle 91(9.2/9.6) and 10g(10.2.0.3) databases and i found that no codeing standards have been maintained by application developers.
To give couple of eg:

1.All form bases applications are not sharing sql statements causeing lot of library cache contention.
2.Few reports are desinged with explicit index hints withing their SQL and i found index access very costely as compare to FTS in terms of elapsed time and resource consumption.

My intention is to find best programming practices w.r.to Oracle database performance that oracle recommands to get best output from Oracle databases and hw/sw deployed.

Apologies in advance if i am missing anything.

Regards,
Bhavik Desai

Locked Post

New comments cannot be posted to this locked post.

Locked on May 14 2009

Added on Apr 16 2009

#general-database-discussions

2 comments

404 views