SQL Performance (MOSC)

MOSC Banner

Generate load on HR schema in Oracle 19c

in SQL Performance (MOSC) 1 commentAnswered ✓

Dear all,

I am trying to generate some load on HR schema tables to test a particular scenario in Oracle 19c. So I have used below - insert statement to have at least 7GB of size for one table and like this I have 10 tables and total size approx 70GB-

But now I wanted to test it aggressively and need at least 1TB of data in multiple tables. Could anyone please advise what is the best approach to make 1TB sample data in HR schema?


SET AUTOCOMMIT 50000
BEGIN
 FOR i IN 207..90000000 LOOP
  INSERT INTO employees_copy (employee_id, first_name, last_name, email, hire_date, job_id, salary)
  VALUES (i, 'employee#'||i,'temp_emp','abc@xmail.com',sysdate,'IT_PROG',1000);
 END LOOP;
END; 
/

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