|
Written by Administrator
|
|
Friday, 21 October 2011 08:59 |
|
Locally vs. Dictionary Managed Tablespaces in Oracle
When Oracle allocates space to a segment (like a table or index), a group of contiguous free blocks, called an extent, is added to the segment. Metadata regarding extent allocation and unallocated extents are either stored in the data dictionary, or in the tablespace itself. Tablespaces that record extent allocation in the dictionary, are called dictionary managed tablespaces, and tablespaces that record extent allocation in the tablespace header, are called locally managed tablespaces.
|
|
Last Updated on Friday, 21 October 2011 09:19 |
|
Read more...
|
|
|
Written by Administrator
|
|
Monday, 10 October 2011 10:07 |
|
Imagine that you are receiving an alert for Tablespace PSAPSR3 usage being at 99%. What are you going to do? Definitely you have to act quickly, so extension of this tablespace is needed.
You can use the following steps to do it, which describes the method via BRTools, on an UNIX machine:
1. First of all check the available free space in the sapdata filesystems:
df -m | grep sapdata
|
|
Last Updated on Monday, 10 October 2011 11:14 |
|
Read more...
|
|
Written by Administrator
|
|
Monday, 10 October 2011 06:59 |
|
How to Resize the Oracle Redologs files
1. go to UNIX level , su to oraSID user adn login into sqlplus:
su - oraSID
sqlplus "/ as sysdba"
2. find names of redo logs and their groups:
SELECT a.group#, a.member, b.bytes FROM v$logfile a, v$log b WHERE a.group# = b.group# order by a.group# asc;
|
|
Last Updated on Monday, 10 October 2011 07:45 |
|
Read more...
|
|
|
|
|
|
|
Oracle
