1 | How does one prevent tablespace fragmentation? |
2 | How does one coalesce free space? |
3 | Where can one find the high water mark for a table? |
4 | How are extents allocated to a segment? |
5 | Can one rename a database user (schema)? |
6 | How does one see the uptime for a database? |
7 | Where are my TEMPFILES, I don't see them in V$DATAFILE or DBA_DATA_FILE? |
8 | How do I find used/free space in a TEMPORARY tablespace? |
9 | How can one see who is using a temporary segment? |
10 | How does one get the view definition of fixed views/tables? |