Home » RDBMS Server » Performance Tuning » Consider of load-test invoking only one insert statement (Oracle 11g, any platform)
Consider of load-test invoking only one insert statement [message #676348] Mon, 03 June 2019 23:33 Go to previous message
Messages: 742
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member

I have a case to think about, however, I need your help

- We have a compress partitioned table named as "TBL_MT_BROADCAST", the table will done as following logic: Insert -> select .. where -> update into another table.
- The TBL_MT_BROADCAST is just only automatic partitioning by day. And we have got only one statement insert, we do not allow to change any thing value

	values (SEQ_TBLMT.nextval,'84856775877','9096',to_date('04-JUN-19','DD-MON-RR'),to_date('04-JUN-19','DD-MON-RR'),'Xin_chao_Viet_nam>',63082224,'PhaiManh','PhaiManh','70609a7f0b8736b28c9d47d164b1f3c3',1,1,0,null,'MEDIA','PHAIMANH','PUSH_PHAIMANH',0,-1,'TEXT','','MEDIA',1555639389482);

So, my question is:
- Do I use something or some-tool to insert 1 million to 5 million statement at once as simulator?
- Or may you help me to write procedure to test?

Thank you very much.
Read Message
Read Message
Previous Topic: improve performance on updating clob data
Next Topic: Slow query with hash clustering (latch free - multiblock read objects)
Goto Forum:

Current Time: Sat Sep 19 01:13:21 CDT 2020