Posts

    [ + | - ]

Archives

    [ + | - ]

Resource Pages

    [ + | - ]

Welcome to Oracle Masters. The portal, as the tagline says, is for anything Oracle. FAQs, Certifications, Resources! In addtion, there will be pages on real life scenarios, Oracle internals, approaching the DBA job at various stages in your career and many other useful resources.Further, if you have a question, you can ask it and we will answer it at the earliest!
So join in. Learn, share and prosper!
Register with us!





Ramesh Menon
Oracle Certified Master - 10g
Oracle Certified RAC Expert - 10g
Oracle Certified Professional - 11g

Are you interested in Weekend/Online Training in Oracle DBA? Do you have business/consulting requirements? Click here Enquiry Form to leave your requirements or mail me at Ramesh Menon

Architecture
Friday, 30 Jan 2009 8:48 AM

Parameter File

By Ramesh Menon Ramesh Menon
This entry is part 2 of 5 in the series Oracle Database Concepts

Every Oracle instance needs an initialization parameters to startup. This file determines the attributes and corresponding values for the instance as well as the database.

A few examples of these attributes(parameters) are listed below

Popularity: 11% [?]

Uncategorized
Friday, 30 Jan 2009 2:01 AM

Oracle Database Concepts & Architecture

By Ramesh Menon Ramesh Menon
AKPC_IDS += "266,";

Popularity: 3% [?]

Auditing And Security
Wednesday, 28 Jan 2009 9:14 AM

Logon Trigger – Database Level and Schema Level

By Ritesh Kumar Singh Ritesh Kumar Singh

Auditing User Logins via LOGON TRIGGER – Database & Schema level

The LOGON TRIGGER enables us to audit user connections to the database.
The following example shows you how to create a logon trigger at database level (for all users)
and at schema level (a particular user)

Popularity: 13% [?]

Uncategorized
Sunday, 25 Jan 2009 11:24 PM

SQL FAQs – Basics (continued)

By Ritesh Kumar Singh Ritesh Kumar Singh
This entry is part 2 of 2 in the series SQL FAQs

Questions in this section.

  1. How can I see all the environment settings currently applicable for SQL *Plus?
  2. Can I make aggregate reports in SQL *Plus?
  3. What is a correlated subquery?
  4. What is the decode function used for?
  5. How can I used CASE statement in SQL statement?
  6. What is SET AUTOTRACE used for?
  7. What is the difference between EXISTS and IN?
  8. What is difference between ROWNUM and ROWID?

    9. Read the rest of this entry »

Popularity: 5% [?]

Network Administration
Friday, 23 Jan 2009 4:54 AM

Using Configurationless connections

By Ramesh Menon Ramesh Menon

Configurationless connections, enable you to bypass TNSNAMES.ORA file and directly connect to the server as follows

sqlplus username/password@[//][host][:port][/service_name]

In order for this to work, the following needs to be added to sqlnet.ora on the server $ORACLE_HOME/network/admin location

NAMES.DIRECTORY_PATH=(ezconnect,tnsnames)

Popularity: 4% [?]

SQL FAQs
Friday, 23 Jan 2009 4:42 AM

SQL FAQs – Basics

By Ritesh Kumar Singh Ritesh Kumar Singh
This entry is part 1 of 2 in the series SQL FAQs

Questions in this section.

  1. What is SQL? What are the different types of statements in SQL?
  2. What tools are available for me to write SQL code?
  3. How do I set the default editor for my SQL *Plus program?
  4. What is glogin.sql used for?
  5. How do I save output of a SQL statement to a file?
  6. How do I spool SQL output in HTML format?
  7. What are pseudocolumns?
  8. What are joins? What are the different types of joins?
  9. What are sub-queries?
  10. What are the GROUP BY, ORDER BY and HAVING clauses used for?
  11. What is DISTINCT clause used for?
  12. What are the set operators available in Oracle SQL?

    13. Read the rest of this entry »

Popularity: 6% [?]

Control Panel

Login



My Links

Blogroll

Project Management

Recent Posts

Recent Comments
Internet Advertisingundelete