Here's a little insight from T2 Systems Support on your Oracle database.
How often do you look at your Oracle database with Enterprise Manager? Have you recently? In the last week? month? year?
A few simple tips that can help you with some of your longer running tasks:
Check your tablespace free space for your USERS, TEMP, and UNDO tablespaces. Are they at 99%? If so, you could be seeing slow import times, update times, when adding records.
Deciding how much new free space to give your tablespace has a lot to do with how often it is growing and at what rate. As a rule of thumb, you can start with a few hundred megs of free space to start, and then watch how fast each is growing. If you have plenty of free disk space on your server's hard drive that stores your Oracle database, then you could consider giving the USERS tablespace an extra gig of space. You can click on the tablespaces tab in the Enterprise Manager to see the free space (a graph and percentage will be displayed) and this is where you can reset the size to a larger size. Click on the USERS tablespace, for example, and then change the size to a higher size (i.e., if your users tablespace is 2 GB - change the new size to 3 GB and then click 'apply' to increase the size.
How does this help you? When the tablespace is full, and it needs to grow on a large import, for example, Oracle has to pause to increase the size of the tablespace very often during the import. If you go ahead and increase it ahead of time, then there won't be a delay during the import process.
If you need help with this task- or any other T2 Systems related issues including handheld ticketwriters and T2 Flex - give us a call at 800-434-1501 or by email at support@t2systems.com.
-Mark
How often do you look at your Oracle database with Enterprise Manager? Have you recently? In the last week? month? year?
A few simple tips that can help you with some of your longer running tasks:
Check your tablespace free space for your USERS, TEMP, and UNDO tablespaces. Are they at 99%? If so, you could be seeing slow import times, update times, when adding records.
Deciding how much new free space to give your tablespace has a lot to do with how often it is growing and at what rate. As a rule of thumb, you can start with a few hundred megs of free space to start, and then watch how fast each is growing. If you have plenty of free disk space on your server's hard drive that stores your Oracle database, then you could consider giving the USERS tablespace an extra gig of space. You can click on the tablespaces tab in the Enterprise Manager to see the free space (a graph and percentage will be displayed) and this is where you can reset the size to a larger size. Click on the USERS tablespace, for example, and then change the size to a higher size (i.e., if your users tablespace is 2 GB - change the new size to 3 GB and then click 'apply' to increase the size.
How does this help you? When the tablespace is full, and it needs to grow on a large import, for example, Oracle has to pause to increase the size of the tablespace very often during the import. If you go ahead and increase it ahead of time, then there won't be a delay during the import process.
If you need help with this task- or any other T2 Systems related issues including handheld ticketwriters and T2 Flex - give us a call at 800-434-1501 or by email at support@t2systems.com.
-Mark
Powered by Compendium
Comments for Oracle database tablespaces - health check?