A log switch occurs when the log writer (LGWR) finishes writing redo entries to the current online redo log file group and starts writing to the next online redo log file group. By default, a log switch occurs automatically when the current online redo log file group is full. A log switch can also be forced by executing the ALTER SYSTEM SWITCH LOGFILE; statement, regardless of whether or not the current online redo log file group is full.
Download free practice test for ocp-dba9i OCP DBA 9i exam. Download free practice test for 1Z0-031 Oracle9i Database: Fundamentals I exam.Archive for the ‘OCA DBA 9i’ category
What is a log switch?
October 31st, 2009
OCP 1z0-047 Short Notes: Exam passing tips
October 3rd, 2009- /*…*/ and — are used to put comments in an Oracle program.
- The CREATE TABLE does not end immediately with a semicolon, and a column name cannot start with a numeric value. However, a numeric value can be used in between a column name.
What is the REMOTE_OS_AUTHENT parameter?
September 30th, 2009The REMOTE_OS_AUTHENT parameter in the parameter file of the database specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter or not. The type of the REMOTE_OS_AUTHENT parameter is Boolean, the default value is false, and the parameter class is static. The REMOTE_OS_AUTHENT parameter is case sensitive on some operating systems. The flow diagram below may help a user understand the role of the REMOTE_OS_AUTHENT parameter for a remote database:
What is log writer (LGWR)?
September 8th, 2009The 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.
- Best exam simulation Oracle oca-dba9i download free trial.
- Get certified in first attempt download ocp-dba9i - OCP DBA 9i simulation.
- Download practice question and study guide for 1Z0-031 for exam.
- Pass Oracle 1Z0-032 - Oracle9i Database: Fundamentals II
- Click here to get free 1Z0-033 Oracle9i DB: Performance Tuning exam practice questions.
- Pass OCA, 10g New Feature for Administrator in first attampt.
- Click here to get free 1Z0-042 Oracle Database 10g: Admin - I exam practice questions.
- Download free practice test for Oracle Oracle Database 10g: Admin - II exam.
- Download free practice test for 1Z0-045 OCA, 10g New Feature for Oracle 8i Ocp exam.
- Click here to get free 1Z0-047 Oracle Database SQL Expert exam practice questions.
- Pass OCA: Oracle Database 11g: Administration I in first attampt.
What is DBMS_SESSION PL/SQL package?
September 8th, 2009The DBMS_SESSION PL/SQL package is used to provide access to the ALTER SESSION and ALTER SYSTEM statements. This package is also used for gathering session related information. The DBMS_SESSION PL/SQL package uses the privileges of the user executing this package, instead of using privileges of the user SYS.
- Get certified in first attempt download oca-dba10g - OCA DBA 10g simulation.
- Get certified in first attempt download oca-dba-11g - OCA DBA 11g simulation.
- Download free practice test for Oracle OCA DBA 9i exam.
- Download free practice test for oca-pl-sql OCA PL/SQL Developer exam.
- Get certified in first attempt download ocp-dba10g - OCP DBA 10g simulation.
- Get certified in first attempt download ocp-dba-11g - OCP DBA 11g simulation.
- Click here to get free ocp-dba9i OCP DBA 9i exam practice questions.
- Download free practice test for ocp-pl-sql OCP PL/SQL Developer exam.
- Download free practice test for ocm-10g Oracle Certified Master 10g exam.
- Download practice question and study guide for oracle-pl-sql for exam.
- Best exam simulation Oracle performance-tuning-certified-expert-11g download free trial.
- Pass Oracle rac-administrator-certified-experts-10g - RAC Certified Expert 10g
- Pass SQL Certified Expert 10g in first attampt.
- Download free practice test for Oracle SQL Certified Expert 11g exam.
- Best exam simulation Oracle 1Z0-033 download free trial.
- Best exam simulation Oracle 1Z0-042 download free trial.
- Become Oracle Oracle Database SQL Expert certified.
- Become Oracle OCA: Oracle Database 11g-SQL Fundamentals-I certified.
What is an online redo log group?
September 2nd, 2009An online redo log group consists of an online redo log file that may or may not be multiplexed. In other words, an online redo log group may be a single online redo log file or a set of identical copies of an online redo log file. Each copy of an online redo log file in an online redo log group is called a member.
What is an undo segment?
September 2nd, 2009An undo segment holds all undo data of a database when the database is running in automatic undo management mode. An undo segment is internally similar to a rollback segment that is used to hold undo data of a database when the database is running in manual undo management mode.
What is Oracle’s password aging and expiration feature?
September 2nd, 2009Oracle’s password aging and expiration feature ensures that the password of a user account expires after a specified number of days. The user or the database administrator must change the password once it has expired. The PASSWORD_LIFE_TIME parameter is used to specify the number of days after which a user account’s password expires.
What is Oracle’s password complexity verification feature?
September 2nd, 2009Oracle’s password complexity verification feature ensures that a password is too complex to be guessed easily. The complexity of a password can be verified before a user can set the password for his account. The PASSWORD_VERIFY_FUNCTION parameter specifies a PL/SQL script that is used to verify the complexity of a password. Oracle provides a default PL/SQL script for this purpose. However, users can also create their own scripts. For example, a script can be created to verify that a password has a minimum length of four characters, the password is not the same as the account’s name, the password has at least one alphabetical, one numeric, and one punctuation mark character, the password is not a simple or obvious word, and the password differs from the previous password by at least three characters.
Get certified in first attempt download ocp-dba9i - OCP DBA 9i simulation. Get certified in first attempt download 1Z0-031 - Oracle9i Database: Fundamentals I simulation.What is DECODE function?
September 1st, 2009The DECODE function decodes a column value or an expression and compares it with each specified search value, one by one. If the expression matches a search value, a result value corresponding to the matching search value is returned. If no match is found, a default result value, if included, is returned. However, if no default value is included, a NULL value is returned. The DECODE function is one of the few single-row functions that directly deal with NULL values. It can compare two NULL values and can return a NULL value.