The client wants me to copy 100 billion records to an empty Oracle database. Almost all records have about 6 fields, only one of them is a varchar field, and 99.99% of these varchar fields contain zero values. He wants it done every day. Which Oracle server is needed for this, and are there any special things that I need to remember?
100 billion records per day equates to ~ 1,157,470 rows per second that are imported. Yes, this is a serious problem, and this will not be the place to get a real answer - if you have such volumes of data and a very large budget for hardware, then talk directly with Oracle to attract them to participate in the project.
, , , , - , , , . , -, , . :
, ? ?
20 ..
, , 1/2 . , .
. - .
100 billion records every day! I doubt that the customer really needs it. Ask him why, and you are likely to find an alternative solution.
If it turns out that I'm wrong, and your client really needs it, I'm curious about the reason!
You can be in the Oracle Database Machine area: http://www.oracle.com/database/exadata.html
Source: https://habr.com/ru/post/1723979/More articles:Using a hash function to create an unforgettable personality for objects - pythonWhy do Postgres refuse to start the service? - windowsGREP: how to look up a value but eliminate some matches at the same time - regexHow to export a single table from phpmyadmin to a comma delimited text file? - mysqlHow to use the interface as a map key - javaHow to get the arch string that distutils uses to build? - pythonExport custom Sharepoint list options - sharepointPHP script stops processing warning error? - phpPartial SVN Branch - branchHow to open pdf embedded in windows.forms.webbrowser management in VISTA - browserAll Articles