一行最大column数和row piece-概念

Oracle concepts中,表中的一行最大1000 column,每255 column会分成一个row piece,下面使用实验来证明它


创建一个1000 column的行
SQL> begin
  2    execute immediate 'create table t(col1 char)';
  3     for i in 2 .. 1000 loop
  4         execute immediate 'alter table t add (col'||i||' char)';
  5    end loop;
  6  end;
  7  /

PL/SQL procedure successfully completed.

结果可以创建。再创建一个1001 column的行

SQL> drop table t;

Table dropped.

SQL> begin
  2    execute immediate 'create table t(col1 char)';
  3     for i in 2 .. 1001 loop
  4         execute immediate 'alter table t add (col'||i||' char)';
  5    end loop;
  6  end;
  7  /
begin
*
ERROR at line 1:
ORA-01792: maximum number of columns in a table or view is 1000
ORA-06512: at line 4

结果创建到1001个时报错


接下来创建一个260 column的行的表,再insert数据,dump出来看一行是不是分为两个row piece

SQL> drop table t;

Table dropped.

SQL> begin
  2    execute immediate 'create table t(col1 number)';
  3     for i in 2 .. 260 loop
  4         execute immediate 'alter table t add (col'||i||' number)';
  5    end loop;
  6  end;
  7  /

PL/SQL procedure successfully completed.

insert into t values(
1,
2,
3,
4


(省略)


253,
254,
255,
256,
257,
258,
259,
260);

SQL> select dbms_rowid.rowid_relative_fno(rowid),dbms_rowid.rowid_block_number(rowid) from t;

DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID) DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------ ------------------------------------
                                  16                                  406

SQL> alter system dump datafile 16 block 406;

System altered.

查看DUMP文件

[oracle@myora10 udump]$ more myora10_ora_31787.trc
/d01/app/oracle/admin/myora10/udump/myora10_ora_31787.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /d01/app/oracle/product/10.2.0
System name:    Linux
Node name:      myora10
Release:        2.6.9-67.ELsmp
Version:        #1 SMP Fri Nov 16 12:48:03 EST 2007
Machine:        i686
Instance name: myora10
Redo thread mounted by this instance: 1
Oracle process number: 17
Unix process pid: 31787, image: oracle@myora10 (TNS V1-V3)


(省略)


block_row_dump:
tab 0, row 0, @0x1be1
tl: 927 fb: -----L-- lb: 0x1  cc: 255
col  0: [ 2]  c1 07
col  1: [ 2]  c1 08
col  2: [ 2]  c1 09
col  3: [ 2]  c1 0a
col  4: [ 2]  c1 0b
col  5: [ 2]  c1 0c


(省略)


col 253: [ 3]  c2 03 3c
col 254: [ 3]  c2 03 3d
tab 0, row 1, @0x1bc9
tl: 24 fb: --H-F--- lb: 0x1  cc: 5
nrid:  0x04000196.0
col  0: [ 2]  c1 02
col  1: [ 2]  c1 03
col  2: [ 2]  c1 04
col  3: [ 2]  c1 05
col  4: [ 2]  c1 06
end_of_block_dump
End dump data blocks tsn: 16 file#: 16 minblk 406 maxblk 406   


从上面的DUMP文件可以看出,一个row分成了两个row piece

tab 0, row 1, @0x1bc9
tl: 24 fb: --H-F--- lb: 0x1  cc: 5
nrid:  0x04000196.0

看上面的fb,标示为H和F,H代表Head piece of row ,F代表First data piece
nrid:  0x04000196.0        下一个row piece的地址

tab 0, row 0, @0x1be1
tl: 927 fb: -----L-- lb: 0x1  cc: 255
看上面的fb,标示为L,L代表Last data piece

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8745319/viewspace-573079/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/8745319/viewspace-573079/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,以下是Python实现的五子棋游戏代码: ```python import numpy as np def create_board(): board = np.zeros((15,15)) return board def place_piece(board, row, col, piece): board[row][col] = piece def get_valid_moves(board): valid_moves = [] for row in range(15): for col in range(15): if board[row][col] == 0: valid_moves.append((row, col)) return valid_moves def check_win(board, piece): # 检查行 for row in range(15): for col in range(11): if board[row][col] == piece and board[row][col+1] == piece \ and board[row][col+2] == piece and board[row][col+3] == piece \ and board[row][col+4] == piece: return True # 检查列 for row in range(11): for col in range(15): if board[row][col] == piece and board[row+1][col] == piece \ and board[row+2][col] == piece and board[row+3][col] == piece \ and board[row+4][col] == piece: return True # 检查斜线 for row in range(11): for col in range(11): if board[row][col] == piece and board[row+1][col+1] == piece \ and board[row+2][col+2] == piece and board[row+3][col+3] == piece \ and board[row+4][col+4] == piece: return True for row in range(11): for col in range(4, 15): if board[row][col] == piece and board[row+1][col-1] == piece \ and board[row+2][col-2] == piece and board[row+3][col-3] == piece \ and board[row+4][col-4] == piece: return True return False def main(): board = create_board() game_over = False turn = 1 while not game_over: if turn == 1: row = int(input("Player 1 (black), enter row: ")) col = int(input("Player 1 (black), enter column: ")) piece = 1 else: row = int(input("Player 2 (white), enter row: ")) col = int(input("Player 2 (white), enter column: ")) piece = 2 if board[row][col] == 0: place_piece(board, row, col, piece) if check_win(board, piece): if turn == 1: print("Player 1 (black) wins!") else: print("Player 2 (white) wins!") game_over = True turn = 1 if turn == 2 else 2 else: print("That spot is taken, please try again.") if __name__ == '__main__': main() ``` 希望以上代码可以帮助您实现一个简单的五子棋游戏。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值