Answer Posted / guest
If we find that fragmentation of space in a tablespace is
high (contiguous space on our disk appears as
non-contiguous),we can coalesce any free space using the
ALTER TABLESPACE TABLESPACE_NAME COALESCE ; command
We must have the ALTER TABLESPACE system privilege to
coalesce tablespaces.
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
which background process invoke at the time of upgradation tell me???
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is dcl? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the steps you will take to improve performance of a poor performing query?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
