Database Administration (MOSC)

MOSC Banner

direct path insert and sga

edited Mar 20, 2015 1:53AM in Database Administration (MOSC) 4 commentsAnswered ✓

Hello,

I tried below scenario and found blocks of table in sga after doing direct path insert - Please suggest what happens in direct path insert like how it's different from conventional?

SQL>  select object_id from dba_objects where object_name='EMP_DATA2';

OBJECT_ID

----------

     16543

SQL>  select count(*) from v$bh where  OBJD=16543;

  COUNT(*)

----------

         0

SQL> insert /*+ APPEND */ into emp_data2 select * from emp_data2;

insert /*+ APPEND */ into emp_data2 select * from emp_data2

                                                  *

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> conn vishal/vishal

Error accessing PRODUCT_USER_PROFILE

Warning:  Product user profile information not loaded!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center