Posts Tagged ‘1Z0-032’

What is log writer (LGWR)?

September 8th, 2009

The log writer (LGWR) is an Oracle background process. It is responsible for writing all the new entries that have been copied in the redo log buffer since the LGWR last wrote the entries to a redo log file. The log writer should write the entries of the redo log buffer fast enough, so that buffers are immediately available for new entries.

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

How are the archived redo log files’ names determined when automatic archiving is enabled?

September 4th, 2009

When a database is running in ARCHIVELOG mode, and automatic archiving is enabled, the archiver process (ARCn) automatically archives the filled online redo log files at specified archive destinations. ARCn automatically decides the names of the archived redo log files by looking at the LOG_ARCHIVE_FORMAT parameter in the initialization parameter file. The LOG_ARCHIVE_FORMAT initialization parameter specifies a default filename format for the archived redo log files. It uses a text string and certain variables to specify the default filename format. This helps Oracle keep the archived redo log files’ names sequential, unique, and easily identifiable from other files.

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is a connect identifier?

September 4th, 2009

A connect identifier is either a connect descriptor or a name that resolves to a connect descriptor. One of the most common connect identifiers is a net service name (a simple name for a database service). A database service name, alias, or net service alias can also be specified as a connect identifier. Users initiate a connection request to a database service by providing a connect string with the CONNECT command on the command line. A connect string includes a username and password, along with a connect identifier.

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is service registration?

September 3rd, 2009

A listener is configured with one or more listening protocol addresses, information about supported services, and listener parameters that control the listener’s run-time behavior. The listener configuration is stored in a configuration file named listener.ora. The supported services (the services to which the listener forwards client requests) can be configured in the listener.ora file or can be dynamically registered with the listener. The dynamic registration feature is called service registration. The service registration is performed by the PMON (Process Monitor) background process of each instance of the database, which has the necessary configuration in the database’s initialization parameter file.

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is a media failure?

September 3rd, 2009

A media failure occurs when a physical problem prevents Oracle from writing or reading a database file that is required for continuing the database operation. For example, when a disk head crashes, all the database files on the disk drive are lost. Disk failure can affect a variety of files, including the data files, redo log files, and control files. Because the database instance cannot continue to function properly, it cannot write the data from the database buffer cache of the system global area (SGA) to the data files.

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

How is an Oracle shared server configured?

September 3rd, 2009

To configure an Oracle shared server, the following processes must be set to run on the server:

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is a statement failure?

September 3rd, 2009

A statement failure occurs when there is a logical failure in the handling of a statement in an Oracle program. For example, when all extents of a table (in other words, the number of extents specified in the MAXEXTENTS parameter of the CREATE TABLE statement) are allocated and completely filled with data, a valid INSERT statement cannot insert a row because no space is available. Therefore, the statement fails.

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

How are archive destinations specified?

September 3rd, 2009

When archiving redo logs, it must be decided whether to archive them to a single archive destination or multiplex them. When the archived redo logs are multiplexed, they are archived to more than one archive destination. The following two methods can be used to specify archive destinations:

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is a listener.ora file?

September 2nd, 2009

A listener.ora file is a listener configuration file that is used to configure listeners on an Oracle server. Only one listener.ora file can be configured for an Oracle server. However, a single listener.ora file contains configuration information for all the listeners configured on the Oracle server. A listener.ora file identifies the following information for a listener:

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark

What is process monitor (PMON)?

July 25th, 2009

The process monitor (PMON) is an Oracle background process that is responsible for performing the cleaning of failed user database connections. This process involves the releasing of blocks that were involved in the failed connection, from the database buffer cache. It also involves the releasing of the resources used by a user process at the time of connection failure. The resource releasing includes removing the locks from database objects that were involved in the failed connection, and removing process id’s of the failed processes from the list of active processes.

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark
uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.