Interested to Buy Any Domain ? << Click Here >> for more details...
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
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What authentication modes does sql server support? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how does an oracle clusterware manage crs resources?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what are the types of connection load-balancing?
What the different components in replication and what is their use? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What are the different ways you can create databases in sql server? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to start SQL Server in minimal configuration mode?
