Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle SQL and PL/SQL Tuning Docs & Information

Posted on 2012-04-04
7
Medium Priority
?
363 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
7 Comments
 
LVL 74

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 74

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 2000 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

688 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