面這些dbcc command有些是沒有官方支持的，不建議初學者使用。切記小心使用，不過有很多還是非常有用，有興趣的可以測試看看！
Unauthorized
of Sybase DBCC Commands
Use them at your own risk!
dbcc allocdump ( dbid, page )
Displays all extents on an allocation page.
Parameters
dbid database ID
page allocation page number
dbcc allocmap ( dbid, one_all, allocpg, bit_stat )
Display or modify status of allocation bitmaps used to detect full allocation
pages.
Parameters
ParamDescriptionValid Values
dbid database ID
one_all bitmap(s) to check/modify 0 entire allocation map
1 single allocation map
allocpg allocation page, if one_all = 1
bit_stat status of the bits 0 check the status
1 set the bit(s)
2 clear the bit(s)
dbcc bhash ( print, bucket_limit )
Check integrity of and optionally print the buffer hash table.
Parameters
ParamDescriptionValid Values
print print option print_bufs display all buffers (default)
no_print display only buffers with problems
bucket_limit number of buffers allowed in a bucket. default = 0
dbcc bufcount ( n_chains )
Print up to 10 longest buffer chains and average chain length.
Parameters
ParamDescriptionValid Values
n_chains the number of chains to print 1-10
dbcc buffer ( [ dbid ][, objid ][, nbufs ], printopt, buftype )
Prints buffer headers and pages from the buffer cache.
Parameters
ParamDescriptionValid Values
dbid (optional) database name or database ID 0 will show data for all
databases.
objid (optional) object ID 0 will show data for all objects.
nbufs&n
您正在看的Sybase教程是:一些未認證的dbcc指令（慎用）。
