Thursday, April 19, 2007

Oracle9i DBA -- Database: Fundamentals I (19)

Using Globalization Support


  • NLS_DATABASE_PARAMETERS shows the database character set and all the NLS parameter settings.
  • NLS_CHARACTERSET and the NLS_NCHAR_ CHARACTERSET are set when creating the database and cannot be changed later.


  • Using DBMS_FGA the DBA creates an audit policy on the target table. Monitoring of data access based on content is implemented through DBMS_FGA.
  • Audit session, Audit session whenever successful, Audit session whenever not successful, Audit select on Account.person, Audit Delete on Account.person

Loading data into a database

  • The three models of concurrency are Intersegment concurrency, Intrasegment concurrency and Parallel concurrency

Read more!

No comments: