Solved

Oracle SQL and PL/SQL Tuning Docs & Information

Posted on 2012-04-04
7
335 Views
Last Modified: 2012-04-09
Hi,

  Any information or docs on Oracle SQl and PL/SQL .

   Help Appreciated.

Thanks
Aman Khan
0
Comment
Question by:amankhan2005
  • 2
  • 2
7 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 37807841
You can find the SQL and PL/SQL references here... (along with lots of other good development info)

http://www.oracle.com/pls/db112/portal.portal_db?selected=5&frame=


The tuning guide is here...

http://docs.oracle.com/cd/E11882_01/server.112/e16638/toc.htm
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 37807850
If you're looking for book recommendations I'll suggest...

Oracle PL/SQL Programming by Steven Feuerstein  -- excellent

anything by Tom Kyte for general SQL and PL/SQL design, as well as other aspects of using Oracle effectively

for tuning,  Jonathan Lewis and Cary Millsap
0
 
LVL 23

Expert Comment

by:David
ID: 37808000
Good ideas above, may I also remind people of the free online training provided by Oracle: http://www.oracle.com/technetwork/tutorials/index.html
0
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 500 total points
ID: 37808206
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 37821329
would like to split points between sdstuber and myself...also this question is well answered and i am unaware of the reason  why author chose to give  "B" grade rating..
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question