why do we give pctfree and pctused in create table statement?
Answer Posted / arul
pctfree and pctused only used for DMT tablespace for extent management allocations
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the operating modes in which database mirroring runs? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What types of replication are supported in sql server? : sql server DBA
internal architecture
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA