sql loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: sql loader

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    Which v$ view do I need to query to monitor the status of the load taking place in sql loader?

  2. #2
    Join Date
    Feb 2001
    Posts
    163
    Your question stumped me. I dont know of any view within oracle to show the sql loader process status. SQL Loader command line parameter log=xxx.log will create a log file and you can view that log to see the progress.

    dba

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Otherwise

    select count(*) from table to which sql*ldr is loading.

    "ps -ef|grep sql*ldr" to see the loading is done or not.

  4. #4
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    If you are exucuting a direct load then check this views:
    V$LOADCSTAT and/or V$LOADTSTAT
    ..you will find records only at the same time of load execution..

  5. #5
    Join Date
    Feb 2001
    Posts
    2
    Interesting topic

  6. #6
    Join Date
    Nov 2000
    Posts
    344
    You can probably query the v$SQL view to see the SQL Stmts that SQL Loader is executing and the number of times it has executed them. (unless you are using the DIRECT=Y parameter, which does not insert data with SQL stmts)

    Also, this query will show you disk I/O by session. It could
    easily be modified to show only the session that you are interested in once you know the SID from v$SESSION.

    select s.username "Oracle User", s.sid "Session",
    i.block_gets "Block Gets", i.consistent_gets "Consistent Gets",
    i.physical_reads "Physical Reads", i.block_changes "Block Changes",
    i.consistent_changes "Consistent Changes",
    s.machine "Computer", s.program "Program", s.logon_time "Logon Time"
    from sys.v_$sess_io i, sys.v_$session s
    where i.sid = s.sid
    and s.username is not null
    ORDER BY 3 desc


  7. #7
    Join Date
    Feb 2001
    Posts
    2
    Interesting topic

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