Windows 7 computer configuration, memory 12 g, oracle11gr2 sga5G, shared_pool_size=1.5 g, every 5 minutes to insert the 2000 data, almost down once a week, a diary is a 04031 error!

CodePudding user response:

Alter the log at ordinary times by other error or warning message?

CodePudding user response:

1/f, reference to learning turn _ response:

alter the log by other error or warning message at ordinary times?

No other error, speculation is likely to be real-time insertion without optimization of SQL statements, are the begin insert into... End this form, and has been reduced, shared_pool free today to find some materials may be a hard parse problem, can the way to the above the insert into soft? Is there some examples!

CodePudding user response:

You can use bind variables