论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2008-07-25 10:15 |只看该作者 |倒序浏览

OS:WINDOWS 2003+SP2
ASE:12.53

1> sp_helpdb DSOA
2> go
name                   db_size    owner                   dbid
      created
      status

------------------------ ------------- ------------------------ ------
      --------------
      ----------------------------------------------------------------------
-------------------------------
DSOA                      33002.0 MB sa                         4
      Jul 17, 2008
      select into/bulkcopy/pllsort, abort tran on log full

(1 row affected)
device_fragments             size       usage
      created          free kbytes
------------------------------ ------------- --------------------
      ------------------- ----------------
master                               2.0 MB data only
      Jul 17 2008  5:32PM             0
oadb                            1998.0 MB data only
      Jul 17 2008  5:32PM          209590
oadb                               500.0 MB data only
      Jul 17 2008  5:32PM          510000
oadb                            6502.0 MB data only
      Jul 17 2008  5:32PM          169774
oadb1                            9000.0 MB data only
      Jul 17 2008  5:32PM       3785388
oadb2                            2998.0 MB data only
      Jul 17 2008  5:32PM       2389010
oadb2                            5000.0 MB data only
      Jul 17 2008  5:32PM       5100000
oadb2                            1002.0 MB data only
      Jul 17 2008  5:32PM       1022040
oadb_log                         6000.0 MB log only
      Jul 17 2008  5:32PM not applicable

--------------------------------------------------------------
log only free kbytes = 6119996
(return status = 0)
1> use DSOA
2> go
1> sp_helplog
2> go
In database 'DSOA', the log starts on device 'oadb_log'.
(return status = 0)

文库|博客

donniejeck

稍有积蓄

论坛徽章:: 0

2楼 [报告]

发表于 2008-07-25 10:16 |只看该作者

而SYBASE控制台显示结果却不同

请见截图

log.JPG (24.68 KB, 下载次数: 55)

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

donniejeck

稍有积蓄

论坛徽章:: 0

3楼 [报告]

发表于 2008-07-25 10:17 |只看该作者

1> select * from master..sysusages
2> go
dbid segmap    lstart    size       vstart    pad unreservedpgs
      crdate
------ ----------- ----------- ----------- ----------- ------ -------------
      --------------------------
   1          7          0       3072          4 NULL          813
            Jul 17 2008  4:26PM
   1          7       3072    20480       6660 NULL       20400
            Jul 17 2008  4:46PM
   2          4          0       1536       4100 NULL          925
            Jul 17 2008  4:26PM
   2          7       1536    102400 100663296 NULL       102000
            Jul 17 2008  4:47PM
   3          7          0       1024       3076 NULL          415
            Jul 17 2008  4:26PM
   4          0          0       1024    27140 NULL          0
            Jul 17 2008  5:32PM
   4          3       1024    1022976 33554432 NULL       104795
            Jul 17 2008  5:32PM
   4          0    1024000    256000 34577408 NULL       255000
            Jul 17 2008  5:32PM
   4          3    1280000    3329024 34833408 NULL       84887
            Jul 17 2008  5:32PM
   4          3    4609024    4608000 50331648 NULL    1892694
            Jul 17 2008  5:32PM
   4          3    9217024    1534976 67108864 NULL    1194505
            Jul 17 2008  5:32PM
   4          0 10752000    2560000 68643840 NULL    2550000
            Jul 17 2008  5:32PM
   4          3 13312000    513024 71203840 NULL       511020
            Jul 17 2008  5:32PM
   4          4 13825024    3072000 83886080 NULL    3059984
            Jul 17 2008  5:32PM
  31513          7          0       1024       5636 NULL          391
            Jul 17 2008  4:26PM
  31514          7          0    61440 16777216 NULL       34067
            Jul 17 2008  4:26PM

(16 rows affected)

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

donniejeck

稍有积蓄

论坛徽章:: 0

4楼 [报告]

发表于 2008-07-25 10:19 |只看该作者

1> select * from master..sysdatabases
2> go
name                         dbid suid       status version logptr
      crdate                   dumptrdate                status2
      audflags deftabaud defvwaud defpraud def_remote_type
      def_remote_loc

      status3    status4
------------------------------ ------ ----------- ------ ------- -----------
      -------------------------- -------------------------- -------
      ----------- ----------- ----------- ----------- ---------------
      -----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------
      ----------- -----------
DSOA                               4          1    4    1 13825063
            Jul 17 2008  4:49PM       Jul 25 2008  9:37AM    1
               0          0          0          0          NULL
      NULL

               0          0
master                            1          1    0    1       3003
            Jul 17 2008  4:26PM       Jul 17 2008  4:44PM  -32768
               0          0          0          0          NULL
      NULL

               0          0
model                            3          1    0    1       624
            Jul 17 2008  4:26PM       Jul 17 2008  4:27PM  -32768
               0          0          0          0          NULL
      NULL

               0          0
sybsystemdb                   31513          1    0    1       632
            Jul 17 2008  4:26PM       Jul 17 2008  4:44PM  -32768
               0          0          0          0          NULL
      NULL

               0          0
sybsystemprocs                31514          1    8    1    28548
            Jul 17 2008  4:26PM       Jul 17 2008  4:45PM  -32768
               0          0          0          0          NULL
      NULL

               0          0
tempdb                            2          1    12    1       662
            Jul 25 2008  9:39AM       Jul 25 2008  9:57AM  -32768
               0          0          0          0          NULL
      NULL

               0          0

(6 rows affected)