What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?207
What is the difference between rman and a traditional hotbackup?1 581
When using oracle export/import what character set concerns might come up? How do you handle them?222
Post New Oracle DBA (Database Administration) Questions
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
What is tkprof and how is it used?
How can you determine the number of sqlnet users logged in to the unix system?
What is the difference between cold backup and hot backup?
How can you determine the space left in a file system?
What does dba stand for in technology?
What degree do database administrators need?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What do you mean by oracle dba?
What is the difference between raid 5 and raid 10? Which is better for oracle?
How do I become a dba?
I have applied the following commands: now what will happen, will the database will give an error / it will work?
What do you mean by oracle dba and what is its role?
How many databases should a dba manage?