While running the Hammerora workload against the database that I had created. I noticed that though the workload was running, the "Transaction Counter" was still showing 0.
I looked into the alert log of the database instance, and notice lots of ORA-1654 being generated.
To fix the issue I first found the datafile names and there sizes for the USERS tablespace.
Next, I increased the size of the datafiles as follows.
Voila, we were back on track.
I looked into the alert log of the database instance, and notice lots of ORA-1654 being generated.
ORA-1654: unable to extend index TPCC.ORDERS_I1 by 128 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 8192 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 128 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 8192 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 128 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 8192 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 128 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 8192 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 128 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 8192 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 128 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 8192 in tablespace USERS ORA-1654: unable to extend index TPCC.ORDERS_I1 by 128 in tablespace USERS |
To fix the issue I first found the datafile names and there sizes for the USERS tablespace.
SQL> select file_name,bytes/1024/1024 "Megs" from dba_data_files where tablespace_name= 2 'USERS'; SQL> select file_name,bytes/1024/1024 "Megs" from dba_data_files where tablespace_name='USERS'; FILE_NAME -------------------------------------------------------------------------------- Megs ---------- /oracle_mvfs/testorcl/users01.dbf 32735 /oracle_mvfs/testorcl/users02.dbf 30720 /oracle_mvfs/testorcl/users03.dbf 30720 .......... .......... .......... |
Next, I increased the size of the datafiles as follows.
SQL> alter database datafile '/oracle_mvfs/testorcl/users20.dbf' resize 32735M; Database altered. SQL> alter database datafile '/oracle_mvfs/testorcl/users19.dbf' resize 32735M; Database altered. |
Voila, we were back on track.
2 comments:
its works. thx a lot
You have datafiles as users[01-03].dbf but you altered files users[19-20].dbf... do u add new files or alter the original ones?
Post a Comment