Starting with Oracle Database 10 g Release 1 the size of internal SGA overhead

Starting with oracle database 10 g release 1 the size

This preview shows page 5 - 8 out of 9 pages.

selects an appropriate default value. Starting with Oracle Database 10 g Release 1, the size of internal SGA overhead is included in the user-specified value of SHARED_POOL_SIZE. In other words, if you are not using the automatic shared memory management feature, then the amount of shared pool memory that is allocated at startup is exactly equal to the value of SHARED_POOL_SIZE initialization parameter. In manual SGA mode, this parameter must be set so that it includes the internal SGA overhead in addition to the desired value of shared pool size. REF. Oracle(r) 10g Administrator Guide, 2-31 QUESTION: 195 What does the Character Set Scanner command line utility do? 126
Image of page 5
B. performs character set conversions to the new specified characterset C. scans on any character set conversion required, then converts the data D. checks for any character definitions that will fail conversion to the new characterset Answer: D The character set scanner (csscan) allows the users to evaluate the impact of migrating an existing database to a new character set or to check if a database contains codepoints outside the current character set (from V1.1 onwards). The tool scans the data in the database including the data dictionary and provides an analysis of the current data, highlighting data which will be converted when migrated to the new database character set or what data is incorrectly stored in the database.These findings are summarized in the database scan summary report and individual exception report. REF. Metalink Note179843.1Availability & versioning of the Character Set Scanner QUESTION: 196 An AFTER SUSPEND system event trigger containing no exception handler is fired, and runs out of space after inserting some audit records. Which two events happen? (Choose two.) REF. Oracle(r) 10g Administrator Guide, 14-9 and 14-10 QUESTION: 197 127
Image of page 6
Image of page 7
Image of page 8

You've reached the end of your free preview.

Want to read all 9 pages?

  • Fall '20
  • Oracle Database

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture