Well there are many answers and my experiences have shown that it always depends on the use-cases.
What you can do to make inserts faster:
1) Bulking (if you want to make it fast, do bulking!) which reduces commits and commit time
2) Enough ITL on the block (INITRANS)
3) Depending on the size of a row: Blocksize, PCTFREE
4) No Indexing
5) No integrity checks (Foreign keys, not null constraints)
6) Buffer cache (if it's to small you'll early end up with I/O)
And the list goes on....
APPEND hint is also very useful on inserts because it's using DIRECT-PATH inserts which will append the data simply on the table. But be aware the unused space by the table will then not be filled up!
Gerald made an excellent exposition and I totally agree withg him.
From my personal experience I would recommend partitioning. But my experience is in the telecom world were we could easily make 20/30 million inserts per hour and some of these tables were partitioned by (day,hour) to improve insert speed, we had indexes and we could not use /*+append*/ because of backup restrictions.
If you need real insight or your specific case, may be you could post your full scenario.
Hi, do you have a column in the table to store the radius server id (i.ex server1, server2, ...)?
If so, is it indexed? Is it partitioned?
maybe you could consider partitioning the table according to the server. For instance
if table looks like this
c1, c2, radius_server_id, ...
You could use range or list partition by radious_server and the on each server, when you issue the insert statement you could specify the corresponding server id.
If your planning to rebuilt table and add partitions, i don't think hash would do the trick on this one...
I stand by adding a range or list partition using a column server_id and forcing each server to specify its own partition while doing the insert.
insert into abc partition (s2_server) values(1,2,'s2') ;
I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.
Organizations today rely on data integration technologies in order to gain a unified view of data coming from disparate sources for informed and timely decision making. These technologies bring together data from multiple sources and transform them into meaningful and valuable information. Oracle is one of the leading providers of data integration technologies that are widely accepted by organizations all over the world. Oracle training and certification courses in the field of data…
As you are aware that rolling forward a physical standby via an incremental SCN backup method is the simplest method of getting your standby database with lag into sync with the primary database. The lag can be due to missing archives on the primary which haven’t been shipped or applied on the standby.
With 12c, the roll forward technique is a bit different. In the prior versions, we had to initially take an incremental backup of the primary database from the SCN where the…
VirtualNuggets is Offering Instructor Led Live IBM Sterling B2B Integrator Online Training. we are the Industry leader in providing IBM Sterling B2B Integrator Tools Training Services, Offering Corporate Trainings Both In Online and In-House and Online Training for Individuals. VirtualNuggets is Offering Online Training for all IT technologies across the globe. Our IBM Sterling B2B Integrator online training methodology focused on hands on experience of Sterling Integrator. We also arrange…
VirtualNuggets is Offering Instructor Led Live IBM Integration Bus Development. VirtualNuggets is the Industry leader in providing Integration Bus Tools Training Services, Offering Corporate Trainings Both In Online and In-House and Online Training for Individuals. VirtualNuggets is Offering Online Training for all IT technologies across the globe. Our IBM Integration Bus Development online training methodology focused on hands on experience of IBM Integration Bus Development. We also…