Skip to Content
Author's profile photo Divyanshu Srivastava

Oracle Interactive Quick Reference

Hi All,

While arsing and buzzing on oracle web site, I found an useful tool, a flash application which available as an offline reference for ORACLE 11g R2 DB.

As it says ” Use this helpful reference as a cheat sheet for writing custom data dictionary scripts, locating views pertinent to a specific database component, and more.”

I thought of sharing it with everyone on the SCN community.

There are three main views in this application

/wp-content/uploads/2013/08/ora1_256471.jpg

Top DBA Views: Key DBA static data dictionary views and dynamic performance views organized by product feature areas

/wp-content/uploads/2013/08/ora2_256526.jpg

Architecture: A single diagram that illustrates the relationships between key database memory structures, processes, and storage

/wp-content/uploads/2013/08/ora3_256527.jpg

Background Processes: A comprehensive list that categorizes the background processes and flags which are new in Oracle

/wp-content/uploads/2013/08/ora4_256528.jpg

You can download this tool from this link.

Regards,

Divyanshu

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ashutosh Chaturvedi
      Ashutosh Chaturvedi

      Thanks divyanshu for providing a good information

      Author's profile photo Divyanshu Srivastava
      Divyanshu Srivastava
      Blog Post Author

      Thanks Ashutosh..

      Author's profile photo Former Member
      Former Member

      Downloaded and took a view ....

      good visuals for understanding the Architecture  and overview of oracle top views and important background process.