Are there waiting for log buffer space
FROM v $ session_wait
WHERE event = 'log buffer space';
Example 1:
SQL> SELECT sid, event, seconds_in_wait, state
2 FROM v $ session_wait
3 WHERE event = 'log buffer space';
no rows selected
Example 2:
SQL> select sid, event, seconds_in_wait, state
2 from v $ session_wait
3 where event = 'log buffer space';
SID EVENT SECONDS_IN_WAIT STATE
------ ------------------------------- ------------- - ------
5 log buffer space 110 WAITING
In the view V $ SESSION_WAIT If the log buffer space event SECONDS_IN_WAIT value, indicating that the redo log buffer space wait to spend some time to consider
• If the log buffer size smaller increase
• the log file will be moved to a faster disk such as disk striping
Related Posts of Are there waiting for log buffer space
-
UNDO table space reconstruction
$ Sqlplus / nolog SQL> connect / as sysdba SQL> create undo tablespace UNDOTBS2 datafile '/ ora_data/UNDOTBS02.DBF' size 1M extent management local; SQL> alter system set undo_tablespace = UNDOTBS2; SQL> drop tablespace UNDOTBS1 includ
-
Oracle Sysdba certification authority management
<br /> Outlined one at ORACLE has a special level of competence - sysdba authority, sysdba privileges ORACLE systems have the highest authority, has opened the database, turn off the database, restore database, such as advanced permissions, the ...
-
Oracle Database exp imp Import Export by user examples
◆ 1. From one windows server A on Test1 export all objects in the user, and then into the linux server B on Test2 users. (Test1 known password for the system users Test1passwd or export is required) ◆ 2.B user Test2 machine does not exist, or Test2 b ...
-
Oracle Database Exp / Imp tools for performance tuning
Abstract: Oracle Exp / Imp instrument is a simple, convenient and flexible backup and restore data transfer tool, it can implement the entire class library, user-level, table-class data backup and recovery. For the amount of data in class G or G with ...
-
Detailed: database name. Instance name. ORACLE_SID. Database name
Detailed: database name, instance name, ORACLE_SID, database name, global database names, service names and hand the script to create oracle database Database name, instance name, database name, global database names, service names, This is easy for some
-
LISTENER and EZCONNECT
listener =========================== Listener should be noted that there are two methods Register: Dynamic and Static Registration Registration Registration <br /> dynamic, that is, when the listener configuration, Do not need to configure stat ...
-
Oracle10g ASM database table space maintenance
1. Default naming Oracle when using ASM + OMF management, Oracle distribution file name will automatically create the appropriate file. Our job to create table space can be simplified as follows: A command. The following are the default Oracle naming ...
-
Merge the use of (1)
Merge to select from a table update or insert some data to another table. And finally is used to update or insert depends on the conditions of the statement. rn Here's our easy to cite an example: rn rn SQL> create table merge_test1 (a number, ...
-
Oracle deadlock related
ORACLE some were killed in the process, the status was set to "killed", but the lock does not release resources for a long time, sometimes it is no way but to restart the database. Now offers a way to solve this problem, that is, in the kil ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
Leave a Reply