If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
- 1 Answers
- 691 Views
- I also Faced
- E-Mail Answers
Answer / Viresh Kumar
With a default pctincrease of zero, the SMON process may not be able to automatically extend tablespaces as needed. This can lead to insufficient space for data files, causing issues with database operations.
| Is This Answer Correct ? | 0 Yes | 0 No |
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
What file will give you oracle instance status information? Where is it located?
When using oracle export/import what character set concerns might come up? How do you handle them?
What is end user in database?
What is explain plan and how is it used?
What is dump destination? What are bdump, cdump and udump?
What are the roles and responsibilities of oracle dba?
What does dba stand for in technology?
How do you put database is archivelog mode, explain procedure?
If you have an example table, what is the best way to get sizing data for the production table implementation?
What is difference between logical standby database and physical standby database?
What happens when the default and temp tablespace clauses are left out from create user statements?
Oracle General 
