Post: #1

Secrets of Oracle Database

Secrets of the Oracle Database is the definitive guide to undocumented and partially documented features of the Oracle database server. Covering useful but little–known features from Oracle9i Database through Oracle Database 11g, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible.

Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well–tested, well–illustrated by clear examples, and sure to improve your ability to make an impact in your day–to–day work with Oracle.

What you’ll learn
Take advantage of Oracle’s built–in Perl DBI distribution to write applications for monitoring, benchmarking, data extraction, and more.
Interpret the undocumented, extended trace file format to pinpoint performance problems that TKPROF reports overlook and obscure.
Get the most out of Statspack by using undocumented report formatting options, accessing its scarcely–documented repository, and integrating with SQL Trace.
Take control of your instance through the ill–documented ORADEBUG command, enabling you to control processes, trace SQL statements, dump process state, monitor wait events and the call stack, and much more.
Leverage undocumented features in Oracle’s built–in scheduler to better automate your workload.
Take * advantage of Transparent Application Failover and Cluster Database Services in a Real Application Cluster environment.

Please Click on the Below link to Download this Book:

You are not allowed to view links. Register or Login to view.

Please Provide your Valuable Suggestions/Comments.

Regards,

Quote this message in a replyReply

Post: #2

Hello Chandu.

My best Friend is learning Oracle 10 i which is most used language as database and Oracle 10 i latest version. I also know about Oracle. Triggers are named PL/SQL blocks that get executed implicitly when a triggering event occurs. Rather that being executed when called, triggers get fired automatically when certain events occur in the system. The action of executing a trigger is called ‘firing’ the trigger. A trigger fires when a triggering event occurs. I have downloaded which you have posted in you post.

Thanks for sharing you knowledge.

Quote this message in a replyReply

Post: #3
Chandu garu plz answer me
query:
Dispalay all the employees annual salary whose working in sales department
Quote this message in a replyReply

Post: #4

Mallesh Garu,

Syntax:

select <col name> from <tab name> where (condition);


Example:

select empannualsal from emp where dept=sales;


Table names, column names meeru correct gaa specify cheste query inkaa efficient gaa vastundi.

Quote this message in a replyReply

Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)