StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
265536
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2008-11-05T15:45:02.967
FavoriteCount
0
LastActivityDate
2008-11-05T15:45:02.967
LastEditDate
LastEditorUserId
0
OwnerUserId
10397
ParentId
264914
PostTypeId
2
Score
29
ViewCount
0
LastEditorDisplayName
text
Body
<p>First off, I would generally caution that gathering table statistics in order to do space analysis is a potentially dangerous thing to do. Gathering statistics may change query plans, particularly if the DBA has configured a statistics gathering job that uses non-default parameters that your call is not using, and will cause Oracle to re-parse queries that utilize the table in question which can be a performance hit. If the DBA has intentionally left some tables without statistics (common if your <code>OPTIMIZER_MODE</code> is CHOOSE), gathering statistics can cause Oracle to stop using the rule-based optimizer and start using the cost-based optimizer for a set of queries which can be a major performance headache if it is done unexpectedly in production. If your statistics are accurate, you can query <code>USER_TABLES</code> (or <code>ALL_TABLES</code> or <code>DBA_TABLES</code>) directly without calling <code>GATHER_TABLE_STATS</code>. If your statistics are not accurate, there is probably a reason for that and you don't want to disturb the status quo.</p> <p>Second, the closest equivalent to the SQL Server <code>sp_spaceused</code> procedure is likely Oracle's <code>DBMS_SPACE</code> package. Tom Kyte has a nice <a href="http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:231414051079" rel="noreferrer"><code>show_space</code> procedure</a> that provides a simple interface to this package and prints out information similar to what <code>sp_spaceused</code> prints out.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow do I calculate tables size in Oracle
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJustin Cave
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTDownMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.