PL/SQL (MOSC)

MOSC Banner

Bulk insert from collection parameter in stored procedure

edited Dec 2, 2015 10:02AM in PL/SQL (MOSC) 1 commentAnswered

I have an interesting scenario where a data collection device inserts sensor data into a custom database.  The programming environment of the data collection platform limits its interaction with the database to either straight up DML (e.g. INSERT) or calling stored procedures.  The original use case was to accept approximately 30 transactions per second.  We created a stored procedure to accept a single data point, perform some validations and ultimately insert the reading into the database.  This design works very well.  A new requirement increases the number of transactions per second to about 10,000 for a very short duration (e.g.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center