How to optimize the oracle insertion speed-CodePudding

Question 1: oracle bulk insert, such as article 30000 submitted, this article 30000 is existing in database_cache yao,
Question 2 insert performance is slow, generally can be from what respect to optimize?

CodePudding user response:

For question 1: before have not been submitted, the old value is placed on the UNDO, new value is in the db buffer cache, that you look at oracle's concept,
For problem 2: insert performance problems caused many reasons, there is no way to answer

CodePudding user response:

reference 1st floor ghx287524027 response:

for question 1: have not been submitted before, the old value is on the UNDO and the new value is in the db buffer cache, that you look at oracle's concept,
For problem 2: insert performance problems caused many reasons, there is no way to answer

- thank you for your guidance, the influence of the insertion speed is many, many factors such as network ah machine performance disk IO, actually simple parameters to tune the database, get the effect of the rare,

CodePudding user response:

refer to the second floor qq_35686181 response:

Quote: refer to 1st floor ghx287524027 response:

For question 1: before have not been submitted, the old value is placed on the UNDO, new value is in the db buffer cache, that you look at oracle's concept,
For problem 2: insert performance problems caused many reasons, there is no way to answer

- thank you for your guidance, the influence of the insertion speed is many, many factors such as network ah machine performance disk IO, actually simple parameters to tune the database, get the effect of the rare,

Not only these, light database in the aspects of the causes of performance problems is very much also, so that performance is not good, only said that if the body uncomfortable, totally do not know how to start

CodePudding user response:

refer to the second floor qq_35686181 response:

Quote: refer to 1st floor ghx287524027 response:

For question 1: before have not been submitted, the old value is placed on the UNDO, new value is in the db buffer cache, that you look at oracle's concept,
For problem 2: insert performance problems caused many reasons, there is no way to answer

- thank you for your guidance, the influence of the insertion speed is many, many factors such as network ah machine performance disk IO, actually simple parameters to tune the database, get the effect of the rare,

In fact, I think the database part performance to do optimization, but the hardware performance is bad, no matter how to how to optimize, is equal to talk, the parameters of the oracle is also need the hardware to do backup power,

CodePudding user response:

reference ghx287524027 reply: 3/f

Quote: refer to the second floor qq_35686181 response:

Quote: refer to 1st floor ghx287524027 response:

For question 1: before have not been submitted, the old value is placed on the UNDO, new value is in the db buffer cache, that you look at oracle's concept,
For problem 2: insert performance problems caused many reasons, there is no way to answer

- thank you for your guidance, the influence of the insertion speed is many, many factors such as network ah machine performance disk IO, actually simple parameters to tune the database, get the effect of the rare,

Not only these, light database in the aspects of the causes of performance problems is very much also, so that performance is not good, only said that if the body uncomfortable, completely not start ah

- good friend meet these problems commonly, generally from what respect to analysis, sequence,

CodePudding user response:

reference 4 floor qq_35686181 response:

Quote: refer to the second floor qq_35686181 response:

Quote: refer to 1st floor ghx287524027 response:

For question 1: before have not been submitted, the old value is placed on the UNDO, new value is in the db buffer cache, that you look at oracle's concept,
For problem 2: insert performance problems caused many reasons, there is no way to answer

- thank you for your guidance, the influence of the insertion speed is many, many factors such as network ah machine performance disk IO, actually simple parameters to tune the database, get the effect of the rare,

In fact, I think the database part performance to do optimization, but the hardware performance is bad, no matter how to how to optimize, is equal to talk, the parameters of the oracle is also need the hardware to do reserve forces,

Is both supplement each other, in fact, we want to get a Oracle server, also won't take a 7200 RPM disk, 4 g memory machine can act as a server,

CodePudding user response:

NOLOGGING
APPEND
The PARALLEL

CodePudding user response:

In addition to the upstairs said, it is also, insert before delete indexes on the table, upon the completion of the insert, rebuild index again,