Project is more than I do systems integration projects, I'm just one of them, in SIRS system in

Situations like this, our system is fixed at 12 o 'clock in the morning? Conducted at 7 o 'clock this morning, there will be a mass of data to update the database table, delete, insert,
I responsible for the system, the ORCALE table is about more than two thousand, in the amount of data is huge!

One day, our system is a problem with the input data, the cause to check the day into data,
So the database administrator privileges, whether can query the 12 o 'clock in the morning? At 7 o 'clock in the morning this time period, what are the table on the "gain" "delete" operation "to"??
I don't want to be in more than two thousand tables, each with a SELECT statement to query the update time (already deleted data also can not use the SELECT query)

CodePudding user response:

1, the trigger mode, if it is 2000 form a large amount of data is written to, may affect your database performance,
2, the audit, it is recommended to use this,
3, analysis the log, a bit more complicated on the operation,

CodePudding user response:

dbms_logmnr

CodePudding user response:

reference 1st floor selling fruit net reply:

1, the trigger mode, if it is 2000 form a large amount of data is written to, may affect your database performance,
2, the audit, it is recommended to use this,
3, analysis the log, a bit more complicated on the operation,

Reply thank moderator,

I management of the project is a national banking system, Banks, amount of data is very large, only the database is divided into ORACLE, DB2, MONGO,
For ORACLE is divided into multiple SCHEMA of the system, and we are more than 2000 tables are independent SCHEMA belongs to our system management
I have engaged in JAVA and SHELL, the database is not my tube, we have specialized in foreign DBA

But for the problem of data to make a solution plan,
This plan, drawn up by the us to plan and implement scheme are we submitted to the foreign DBA for implementation,
So, first of all, I'm really for DBA ORACEL ability is limited, need help; Second, also want to know what what method can solve the query to the table is made changes

CodePudding user response:

The banking system should have a master file and move files
See good move files
No delete function, the banking system is merely note to delete

CodePudding user response:

reference 4 floor wilson1966 response:

banking system should have a master file and move files
See good move files
No delete function, the banking system is note to delete it

Is not does not delete, but will remove,
In business, the system will be a temporary table, after the temporary table in the main table, data of temporary tables will be physically deleted,

The problem now is not a system crash, but the system normal operation, but the data has a problem, so also does not have a problem and move files

CodePudding user response:

Don't know what's your system, but the bank system, should be very large, and there will be some specification, will not easily let you change some contents on the database,
So, increase the trigger scheme, both in terms of the stability of the database, or in terms of efficiency, are not feasible,
Generally speaking, the project like this database, the data is not directly with physical DELETE DELETE, is in the list, add DELETE_FLAG flags, to realize the data of physical DELETE, temporary table another matter, and temporary table data, statistics to also do not have what meaning,
Will there be any CREATE_TIME and UPDATE_TIME to record the data creation time and the last update time,
You can according to the three fields, without modifying an existing database under the condition of any content, the statistics of the data you need,

CodePudding user response:

SELECT * FROM USER_TAB_MODIFICATIONS;