Can 't Create table??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Can 't Create table??

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Can 't Create table??

    I am trying to create a table and the session is just sitting there. I cancel the create table and restarted the database and tried again an it is just sitting there.

    I did a select on wait events and I get the following

    7 MYUSER sqlplus@dev01 (TNS V1-V3) ACTIVE log file sync
    7 MYUSER sqlplus@dev01 (TNS V1-V3) ACTIVE db file sequential read
    7 MYUSER sqlplus@dev01 (TNS V1-V3) ACTIVE db file scattered read
    7 MYUSER sqlplus@dev01 (TNS V1-V3) ACTIVE file open


    Any idea how to debug what the heck is going on?

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    WAITEVENT: "db file sequential read"
    This signifies a wait for an I/O read request to complete.
    Sequential read reads data into contiguous memory, usually a single-block read, although it is possible to see sequential reads for more than one block.

    WAITEVENT: "db file scattered read"
    This wait happens when a session is waiting for a multiblock IO to complete.
    This typically occurs during full table scans or index fast full scans. Oracle reads up to DB_FILE_MULTIBLOCK_READ_COUNT consecutive blocks at a time and scatters them into buffers in the buffer cache.

    WAITEVENT: "log file sync"
    When a user session COMMITs (or rolls back), the sessions redo information needs to be flushed to the redo logfile. The user session will post the LGWR to write all redo required from the log buffer to the redo log file. When the LGWR has finished it will post the user session. The user session waits on this wait event while waiting for LGWR to post it back to confirm all redo changes are safely on disk.


    Start investigating...
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width