{"id":60717,"date":"2026-01-16T08:57:19","date_gmt":"2026-01-16T00:57:19","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/60717.html"},"modified":"2026-01-16T08:57:19","modified_gmt":"2026-01-16T00:57:19","slug":"%e8%be%be%e6%a2%a6%e6%95%b0%e6%8d%ae%e5%ba%93-%e5%ad%a6%e4%b9%a0-41-%e8%a1%a8%e5%a4%a7%e5%b0%8f%e5%bf%ab%e9%80%9f%e4%bc%b0%e7%ae%97","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/60717.html","title":{"rendered":"\u8fbe\u68a6\u6570\u636e\u5e93-\u5b66\u4e60-41-\u8868\u5927\u5c0f\u5feb\u901f\u4f30\u7b97"},"content":{"rendered":"

\u76ee\u5f55<\/p>\n

\n

\u4e00\u3001\u73af\u5883\u4fe1\u606f<\/p>\n

\u4e8c\u3001\u4ecb\u7ecd<\/p>\n

\u4e09\u3001\u529f\u80fd\u4ecb\u7ecd<\/p>\n

1\u3001\u5b9a\u4e49<\/p>\n

2\u3001\u81ea\u8c03\u6574<\/p>\n

3\u3001\u63d0\u793a<\/p>\n

\u56db\u3001\u5b9e\u9a8c<\/p>\n

1\u3001\u6d4b\u8bd5\u6570\u636e<\/p>\n

2\u3001\u89c6\u56fe\u67e5\u770b\u8868\u5927\u5c0f<\/p>\n

3\u3001\u533f\u540d\u5757\u8ba1\u7b97\u8868\u5927\u5c0f<\/p>\n

\n

\u4e00\u3001\u73af\u5883\u4fe1\u606f<\/h2>\n\n\n\n\n\n\n\n\n
\u540d\u79f0<\/td>\n\u503c<\/td>\n<\/tr>\n
CPU<\/td>\n12th Gen Intel(R) Core(TM) i7-12700H<\/td>\n<\/tr>\n
\u64cd\u4f5c\u7cfb\u7edf<\/td>\nCentOS Linux release 7.9.2009 (Core)<\/td>\n<\/tr>\n
\u5185\u5b58<\/td>\n4G<\/td>\n<\/tr>\n
\u903b\u8f91\u6838\u6570<\/td>\n4<\/td>\n<\/tr>\n
DM\u7248\u672c<\/td>\n1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0DM Database Server 64 V8 2 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0DB Version: 0x7000d 3 \u00a0 \u00a0 \u00a0 \u00a0 \u00a003134284336-20250218-260144-20132 4 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Msg Version: 32 5 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Gsu level(5) cnt: 0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4e8c\u3001\u4ecb\u7ecd<\/h2>\n

\u6700\u8fd1\u5728\u4f7f\u7528\u8fbe\u68a6\u6570\u636e\u5e93\u7684\u65f6\u5019，\u53d1\u73b0\u5220\u9664\u6570\u636e\u540e，\u8fc7\u4e00\u6bb5\u65f6\u95f4，\u8868\u5927\u5c0f\u4e0d\u56de\u7f29，\u5224\u65ad\u8fbe\u68a6\u5728\u5220\u9664\u6570\u636e\u65f6，\u548cPG\u6570\u636e\u5e93\u7c7b\u4f3c，\u4e0d\u4f1a\u7acb\u9a6c\u5220\u9664\u6570\u636e，\u53ea\u662f\u6253\u4e86\u6807\u8bb0，\u9700\u8981\u8fdb\u884c\u7a7a\u6d1e\u7387\u6e05\u7406\u624d\u53ef\u4ee5\u91ca\u653e\u7a7a\u95f4，\u6e05\u7406\u524d\u5360\u75281.4T，\u91cd\u5efa\u8868\u540e\u4e3a140G，\u6240\u4ee5\u5199\u4e86\u4e00\u4e2a\u533f\u540d\u5757\u5b9e\u73b0\u8868\u5927\u5c0f\u5feb\u901f\u4f30\u7b97，\u56e0\u4e3a\u5f88\u591a\u751f\u4ea7\u73af\u5883\u662f\u4e0d\u5141\u8bb8\u521b\u5efa\u5b58\u8fc7\u7684\u3002<\/p>\n

\u4e09\u3001\u529f\u80fd\u4ecb\u7ecd<\/h2>\n

1\u3001\u5b9a\u4e49<\/h3>\n

–SET SERVEROUTPUT ON<\/p>\n

\/*\u6b64\u533f\u540d\u5757\u4e0d\u8ba1\u7b97\u5b57\u6bb5\u548c\u5b57\u6bb5\u7684\u5b57\u8282\u586b\u5145（\u5b57\u8282\u5bf9\u9f50）\u3002*\/
\nDECLARE
\n UserName VARCHAR(50) := 'SYSDBA';
\n TabName VARCHAR(50) := 'SUN';<\/p>\n

TYPE HashTabT IS TABLE OF INT INDEX BY VARCHAR2(50);
\n TYPE StrArrayT IS TABLE OF VARCHAR2(50) INDEX BY PLS_INTEGER;<\/p>\n

TypeMap HashTabT; \/*\u7c7b\u578b\u6620\u5c04\u8868\u3002*\/
\n ColSets StrArrayT; \/*\u5b9e\u65f6\u8ba1\u7b97\u5b57\u6bb5\u8868\u3002*\/
\n ColSetsIdx INT := 0; \/*\u5b9e\u65f6\u8ba1\u7b97\u5b57\u6bb5\u8868\u7684\u7d22\u5f15\u3002*\/
\n ComputeFlag INT := -1; \/*\u6253\u4e86\u6b64\u6807\u8bb0\u7684\u5217，\u5b9e\u9645\u8ba1\u7b97\u5927\u5c0f\u3002*\/
\n PartComputeFlag INT := -2; \/*\u6253\u4e86\u6b64\u6807\u8bb0\u7684\u5217，\u90e8\u5206\u8ba1\u7b97\u5927\u5c0f，\u6839\u636e\u5217\u957f\u5ea6\u3002*\/
\n OneRowSize INT := 0; \/*\u4e00\u884c\u7684\u5b57\u8282\u6570\u603b\u548c，\u4e0d\u5305\u542b ComputeFlag\u3002*\/
\n ColSize PLS_INTEGER := 0; \/*\u4e00\u5217\u7684\u5b57\u8282\u6570\u3002*\/
\n TotalSize BIGINT := 0; \/*\u8868\u6574\u4f53\u5b57\u8282\u6570\u3002*\/
\n CntSql VARCHAR(200) := 'SELECT COUNT(*) FROM '||UserName||'.'||TabName;
\n Cnt BIGINT := 0; \/*\u8868\u884c\u6570\u3002*\/
\n ComputeSql TEXT := 'SELECT SUM(';
\n ComputeSize BIGINT := 0; \/*\u8868\u9700\u5b9e\u65f6\u8ba1\u7b97\u5b57\u6bb5\u603b\u548c\u5b57\u8282\u6570\u3002*\/
\nBEGIN
\n DBMS_OUTPUT.ENABLE;<\/p>\n

DBMS_OUTPUT.PUT_LINE('UserName : '||UserName);
\n DBMS_OUTPUT.PUT_LINE('TabName : '||TabName);<\/p>\n

\/*\u521d\u59cb\u5316HASH\u6876\u3002*\/
\n TypeMap('CHAR') := PartComputeFlag;
\n TypeMap('VARCHAR') := ComputeFlag;
\n TypeMap('VARCHAR2') := ComputeFlag;
\n TypeMap('TINYINT') := 1;
\n TypeMap('BIT') := 1;
\n TypeMap('BYTE') := 1;
\n TypeMap('SMALLINT') := 2;
\n TypeMap('INT') := 4;
\n TypeMap('BIGINT') := 8;
\n TypeMap('REAL') := 4;
\n TypeMap('FLOAT') := 8;
\n TypeMap('DOUBLE') := 8;
\n TypeMap('DOUBLE PRECISION') := 8;
\n TypeMap('DEC') := ComputeFlag; \/*1~22 \u4e2a\u5b57\u8282 ，\u53d6\u4e2a\u4e2d\u95f4\u503c*\/
\n TypeMap('DECIMAL') := ComputeFlag; \/*1~22 \u4e2a\u5b57\u8282 ，\u53d6\u4e2a\u4e2d\u95f4\u503c*\/
\n TypeMap('NUMERIC') := ComputeFlag; \/*1~22 \u4e2a\u5b57\u8282 ，\u53d6\u4e2a\u4e2d\u95f4\u503c*\/
\n TypeMap('NUMBER') := ComputeFlag; \/*1~22 \u4e2a\u5b57\u8282 ，\u53d6\u4e2a\u4e2d\u95f4\u503c*\/
\n TypeMap('BINARY') := ComputeFlag;
\n TypeMap('VARBINARY') := ComputeFlag;
\n TypeMap('DATE') := 3;
\n TypeMap('TIME') := 5;
\n TypeMap('TIMESTAMP') := 8;
\n TypeMap('DATETIME') := 8;
\n TypeMap('TIME WITH TIME ZONE') := 7;
\n TypeMap('TIMESTAMP WITH TIME ZONE') := 10;
\n TypeMap('DATETIME WITH TIME ZONE') := 10; \/*\u53c2\u8003\u7c7b\u578b TIMESTAMP WITH TIME ZONE*\/
\n TypeMap('INTERVAL YEAR') := 12;
\n TypeMap('INTERVAL MONTH') := 12;
\n TypeMap('INTERVAL YEAR TO MONTH') := 12;
\n TypeMap('INTERVAL DAY') := 24;
\n TypeMap('INTERVAL HOUR') := 24;
\n TypeMap('INTERVAL MINUTE') := 24;
\n TypeMap('INTERVAL SECOND') := 24;
\n TypeMap('INTERVAL DAY TO HOUR') := 24;
\n TypeMap('INTERVAL DAY TO MINUTE') := 24;
\n TypeMap('INTERVAL DAY TO SECOND') := 24;
\n TypeMap('INTERVAL HOUR TO MINUTE') := 24;
\n TypeMap('INTERVAL HOUR TO SECOND') := 24;
\n TypeMap('INTERVAL MINUTE TO SECOND') := 24;
\n TypeMap('BLOB') := ComputeFlag;
\n TypeMap('IMAGE') := ComputeFlag;
\n TypeMap('LONGVARBINARY') := ComputeFlag;
\n TypeMap('CLOB') := ComputeFlag;
\n TypeMap('TEXT') := ComputeFlag;
\n TypeMap('LONGVARCHAR') := ComputeFlag;<\/p>\n

\/*\u83b7\u53d6\u4e00\u5217\u7684\u5b57\u8282\u6570，\u4e0d\u5305\u542b\u9700\u8ba1\u7b97\u5217\u3002*\/
\n FOR I IN (SELECT COLUMN_ID,COLUMN_NAME,DATA_TYPE,DATA_LENGTH FROM DBA_TAB_COLUMNS WHERE OWNER = UserName AND TABLE_NAME = TabName ORDER BY COLUMN_ID) LOOP<\/p>\n

\/*\u5224\u65ad\u5217\u7c7b\u578b\u662f\u5426\u5b58\u5728\u3002*\/
\n IF !(TypeMap.EXISTS(I.DATA_TYPE)) THEN
\n DBMS_OUTPUT.PUT_LINE('ColId : '||I.COLUMN_ID);
\n DBMS_OUTPUT.PUT_LINE('Col : '||I.COLUMN_NAME);
\n DBMS_OUTPUT.PUT_LINE('Unknown Type : '||I.DATA_TYPE);
\n DBMS_OUTPUT.PUT_LINE('Len : '||I.DATA_LENGTH);
\n RETURN;
\n END IF;<\/p>\n

ColSize = TypeMap(I.DATA_TYPE);<\/p>\n

\/*\u6839\u636e\u4e0d\u540c\u7c7b\u578b\u8fdb\u884c\u4e0d\u540c\u7684\u5904\u7406\u3002*\/
\n IF ColSize = PartComputeFlag THEN
\n ColSize := I.DATA_LENGTH;
\n ELSIF ColSize = ComputeFlag THEN
\n ColSize := 0;
\n ColSets(ColSetsIdx) := I.COLUMN_NAME;
\n ColSetsIdx := ColSetsIdx + 1;
\n ELSE
\n ColSize := TypeMap(I.DATA_TYPE);
\n END IF;<\/p>\n

OneRowSize := OneRowSize + ColSize;<\/p>\n

— DBMS_OUTPUT.PUT_LINE('ColId : '||I.COLUMN_ID);
\n — DBMS_OUTPUT.PUT_LINE('Col : '||I.COLUMN_NAME);
\n — DBMS_OUTPUT.PUT_LINE('Type : '||I.DATA_TYPE);
\n — DBMS_OUTPUT.PUT_LINE('Len : '||I.DATA_LENGTH);
\n — DBMS_OUTPUT.PUT_LINE('ColSize : '||ColSize);
\n — DBMS_OUTPUT.PUT_LINE('======================================');
\n END LOOP;<\/p>\n

DBMS_OUTPUT.PUT_LINE('OneRowSize(Bytes) : '||OneRowSize);<\/p>\n

\/*OneRowSize \u4e0d\u53ef\u80fd\u4e3a0，\u8bf4\u660e\u6a21\u5f0f\u6216\u8868\u4e0d\u5b58\u5728\u3002*\/
\n IF OneRowSize = 0 THEN
\n DBMS_OUTPUT.PUT_LINE('The user or table does not exist.');
\n RETURN;
\n END IF;<\/p>\n

\/*\u8ba1\u7b97\u8868\u7684\u603b\u6761\u6570\u3002*\/
\n EXECUTE IMMEDIATE CntSql INTO Cnt;<\/p>\n

DBMS_OUTPUT.PUT_LINE('Cnt : '||Cnt);
\n — DBMS_OUTPUT.PUT_LINE('ColSetsIdx : '||ColSetsIdx);<\/p>\n

\/*\u5224\u65ad\u662f\u5426\u9700\u8981\u8fdb\u884c\u5b9e\u9645\u8ba1\u7b97\u3002*\/
\n IF (ColSetsIdx > 0) AND (Cnt > 0) THEN<\/p>\n

ColSetsIdx := ColSetsIdx – 1;<\/p>\n

FOR Y IN 0..ColSetsIdx LOOP
\n ComputeSql := ComputeSql||'NVL(LENGTHB('||ColSets(Y)||'),0)';
\n IF Y != ColSetsIdx THEN
\n ComputeSql := ComputeSql||' + ';
\n END IF;
\n END LOOP;<\/p>\n

ComputeSql := ComputeSql||' ) AS TOTAL_SIZE FROM '||UserName||'.'||TabName;
\n — DBMS_OUTPUT.PUT_LINE('ComputeSql : '||ComputeSql);<\/p>\n

EXECUTE IMMEDIATE ComputeSql INTO ComputeSize;
\n END IF;<\/p>\n

DBMS_OUTPUT.PUT_LINE('ComputeSize(Bytes) : '||ComputeSize);<\/p>\n

\/*\u6240\u6709\u7ed3\u679c\u6c47\u603b\u3002*\/
\n TotalSize := OneRowSize * Cnt + ComputeSize;<\/p>\n

DBMS_OUTPUT.PUT_LINE('TotalSize(G) : '|| trunc(TotalSize \/ 1024.0 \/ 1024 \/ 1024 , 3));
\nEND; <\/p>\n

2\u3001\u81ea\u8c03\u6574<\/h3>\n

\u67d0\u4e9b\u53d8\u957f\u7c7b\u578b\u6211\u4eec\u662f\u5b9e\u9645\u8ba1\u7b97\u7684，\u5927\u5bb6\u53ef\u4ee5\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u7ed9\u4e00\u4e2a\u4f30\u7b97\u503c，\u65b9\u4fbf\u5feb\u901f\u8ba1\u7b97\u51fa\u7ed3\u679c\u3002<\/p>\n

\u5f00\u5934\u7684\u7528\u6237\u540d\u548c\u8868\u540d\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u8c03\u6574\u3002<\/p>\n

3\u3001\u63d0\u793a<\/h3>\n

\u53ea\u505a\u4e86\u63d2\u5165\u7684\u8868，\u548c\u89c6\u56fe\u67e5\u8be2\u51fa\u7684\u5b9e\u9645\u5927\u5c0f\u5199\u4f1a\u6709\u5dee\u5f02，\u56e0\u4e3a\u5e95\u5c42\u8ba1\u7b97\u65b9\u5f0f\u53ef\u80fd\u4e0d\u540c，\u4f8b\u5982\u53ef\u80fd\u4f1a\u8ba1\u7b97：<\/p>\n

（1）\u5b57\u6bb5\u548c\u5b57\u6bb5\u7684\u5b57\u8282\u586b\u5145，\u4e3a\u4e86\u5b57\u8282\u5bf9\u9f50，\u63d0\u5347\u6548\u7387\u3002<\/p>\n

（2）\u5757\u5934\u3002<\/p>\n

（3）\u884c\u5934\u3002<\/p>\n

\u56db\u3001\u5b9e\u9a8c<\/h2>\n

1\u3001\u6d4b\u8bd5\u6570\u636e<\/h3>\n

DROP TABLE IF EXISTS SUN;
\nCREATE TABLE SUN (T0 SMALLINT,
\n T1 INT,
\n T2 BIGINT,
\n T3 NUMERIC(20,6),
\n T4 DECIMAL(30,8),
\n T5 REAL,
\n T6 DOUBLE PRECISION,
\n T7 SMALLINT,
\n T8 INT,
\n T9 BIGINT,
\n T10 CHAR(10),
\n T11 VARCHAR(4000),
\n T12 TEXT,
\n T13 BLOB,
\n T14 FLOAT,
\n T15 TIMESTAMP,
\n T16 TIMESTAMP WITH TIME ZONE,
\n T17 DATE,
\n T18 TIME,
\n T19 TIME WITH TIME ZONE,
\n T20 INTERVAL YEAR,
\n T21 CHAR(1),
\n T22 VARCHAR(100),
\n T23 CHAR(20),
\n T24 BIGINT);
\nINSERT INTO SUN (T0,T1,T2,T3,T4,T5,T6,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22,T23,T24) VALUES
\n(1,2,918118131,1.1, NULL, 0 ,0.123456789123456789 ,'1','SUN','BJ','18',1.1,'2025-09-26 09:16:25.674136','2025-09-26 09:16:25.674136+08','1995-09-18','13:36:00.036269','15:09:34.266988+08','1 YEAR 1 MONTH 1 DAY 01:01:01.1','T','LXG','A',1);
\nINSERT INTO SUN (T0,T1,T2,T3,T4,T5,T6,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22,T23,T24) VALUES
\n(1,2,918118131,0, 12345678910111213.12345678,0.12345678910,0 ,'2','LZL','WZ','19',0,'2025-09-25 09:16:25.674136','2025-09-26 09:16:25.674136+09','1995-05-17','13:36:00.000009','15:09:34.000008+08','2 YEAR 1 MONTH 1 DAY 01:01:01.01','F','LLX','B',2);
\nINSERT INTO SUN (T0,T1,T2,T3,T4,T5,T6,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22,T23,T24) VALUES
\n(1,2,918118131,0.12345, 10000000000000003.12345678,0.123456789 ,1234567893.12456789 ,'3','CLX','BJWZQZ','20',22,'2025-09-26 09:16:25.123456','2025-09-26 10:16:25.674136+08','1995-01-18','01:30:00.036269','12:09:34.266988+08','1 YEAR 2 MONTH 1 DAY 01:01:01.001','T','ZXJ','C',3);
\nINSERT INTO SUN (T0,T1,T2,T3,T4,T5,T6,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22,T23,T24) VALUES
\n(1,2,918118131,1234.1234, 10000000005000000.00050000,123.4567 ,1234567894.123456789 ,'4','LDQ','WZ',NULL,1.66,'2025-09-26 09:06:25.674136','2025-09-26 09:16:25.674136+08','2024-01-31','05:30:00.036269','01:09:34.266988+08','1 YEAR 1 MONTH 2 DAY 01:01:01.0001','T','LDQ','D',11);
\nINSERT INTO SUN (T0,T1,T2,T3,T4,T5,T6,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22,T23,T24) VALUES
\n(1,2,918118131,12345.123, 12345678910111213.12345678,1234.5678910 ,1234567895.123456789 ,'5',NULL,NULL,'30',0.55555,'2025-11-26 09:06:25.674136','2025-09-26 09:16:25.674136+08','1995-09-18','13:36:00.036269','00:09:34.266988+08','1 YEAR 1 MONTH 1 DAY 02:01:01','T','CZG','E',22);<\/p>\n

INSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nINSERT INTO SUN SELECT * FROM SUN;
\nCOMMIT; <\/p>\n

2\u3001\u89c6\u56fe\u67e5\u770b\u8868\u5927\u5c0f<\/h3>\n

SELECT
\n OWNER,
\n SEGMENT_NAME,
\n SEGMENT_TYPE,
\n ROUND(SUM(BYTES) \/ 1024.0 \/ 1024 \/ 1024, 3) AS TOTAL_SIZE
\nFROM DBA_SEGMENTS
\nWHERE
\nOWNER = 'SYSDBA' AND SEGMENT_NAME = 'SUN'
\nGROUP BY OWNER, SEGMENT_NAME, SEGMENT_TYPE;<\/p>\n

\u884c\u53f7 OWNER SEGMENT_NAME SEGMENT_TYPE TOTAL_SIZE
\n———- —— ———— ———— ———-
\n1 SYSDBA SUN TABLE 0.059<\/p>\n

\u5df2\u7528\u65f6\u95f4: 771.536(\u6beb\u79d2). \u6267\u884c\u53f7:10112. <\/p>\n

3\u3001\u533f\u540d\u5757\u8ba1\u7b97\u8868\u5927\u5c0f<\/h3>\n

SET SERVEROUTPUT ON<\/p>\n

\/*\u6b64\u533f\u540d\u5757\u4e0d\u8ba1\u7b97\u5b57\u6bb5\u548c\u5b57\u6bb5\u7684\u5b57\u8282\u586b\u5145（\u5b57\u8282\u5bf9\u9f50）\u3002*\/
\nDECLARE
\n UserName VARCHAR(50) := 'SYSDBA';
\n TabName VARCHAR(50) := 'SUN';<\/p>\n

TYPE HashTabT IS TABLE OF INT INDEX BY VARCHAR2(50);
\n TYPE StrArrayT IS TABLE OF VARCHAR2(50) INDEX BY PLS_INTEGER;<\/p>\n

TypeMap HashTabT; \/*\u7c7b\u578b\u6620\u5c04\u8868\u3002*\/
\n ColSets StrArrayT; \/*\u5b9e\u65f6\u8ba1\u7b97\u5b57\u6bb5\u8868\u3002*\/
\n ColSetsIdx INT := 0; \/*\u5b9e\u65f6\u8ba1\u7b97\u5b57\u6bb5\u8868\u7684\u7d22\u5f15\u3002*\/
\n ComputeFlag INT := -1; \/*\u6253\u4e86\u6b64\u6807\u8bb0\u7684\u5217，\u5b9e\u9645\u8ba1\u7b97\u5927\u5c0f\u3002*\/
\n PartComputeFlag INT := -2; \/*\u6253\u4e86\u6b64\u6807\u8bb0\u7684\u5217，\u90e8\u5206\u8ba1\u7b97\u5927\u5c0f，\u6839\u636e\u5217\u957f\u5ea6\u3002*\/
\n OneRowSize INT := 0; \/*\u4e00\u884c\u7684\u5b57\u8282\u6570\u603b\u548c，\u4e0d\u5305\u542b ComputeFlag\u3002*\/
\n ColSize PLS_INTEGER := 0; \/*\u4e00\u5217\u7684\u5b57\u8282\u6570\u3002*\/
\n TotalSize BIGINT := 0; \/*\u8868\u6574\u4f53\u5b57\u8282\u6570\u3002*\/
\n CntSql VARCHAR(200) := 'SELECT COUNT(*) FROM '||UserName||'.'||TabName;
\n Cnt BIGINT := 0; \/*\u8868\u884c\u6570\u3002*\/
\n ComputeSql TEXT := 'SELECT SUM(';
\n ComputeSize BIGINT := 0; \/*\u8868\u9700\u5b9e\u65f6\u8ba1\u7b97\u5b57\u6bb5\u603b\u548c\u5b57\u8282\u6570\u3002*\/
\nBEGIN
\n DBMS_OUTPUT.ENABLE;<\/p>\n

DBMS_OUTPUT.PUT_LINE('UserName : '||UserName);
\n DBMS_OUTPUT.PUT_LINE('TabName : '||TabName);<\/p>\n

\/*\u521d\u59cb\u5316HASH\u6876\u3002*\/
\n TypeMap('CHAR') := PartComputeFlag;
\n TypeMap('VARCHAR') := ComputeFlag;
\n TypeMap('VARCHAR2') := ComputeFlag;
\n TypeMap('TINYINT') := 1;
\n TypeMap('BIT') := 1;
\n TypeMap('BYTE') := 1;
\n TypeMap('SMALLINT') := 2;
\n TypeMap('INT') := 4;
\n TypeMap('BIGINT') := 8;
\n TypeMap('REAL') := 4;
\n TypeMap('FLOAT') := 8;
\n TypeMap('DOUBLE') := 8;
\n TypeMap('DOUBLE PRECISION') := 8;
\n TypeMap('DEC') := ComputeFlag; \/*1~22 \u4e2a\u5b57\u8282 ，\u53d6\u4e2a\u4e2d\u95f4\u503c*\/
\n TypeMap('DECIMAL') := ComputeFlag; \/*1~22 \u4e2a\u5b57\u8282 ，\u53d6\u4e2a\u4e2d\u95f4\u503c*\/
\n TypeMap('NUMERIC') := ComputeFlag; \/*1~22 \u4e2a\u5b57\u8282 ，\u53d6\u4e2a\u4e2d\u95f4\u503c*\/
\n TypeMap('NUMBER') := ComputeFlag; \/*1~22 \u4e2a\u5b57\u8282 ，\u53d6\u4e2a\u4e2d\u95f4\u503c*\/
\n TypeMap('BINARY') := ComputeFlag;
\n TypeMap('VARBINARY') := ComputeFlag;
\n TypeMap('DATE') := 3;
\n TypeMap('TIME') := 5;
\n TypeMap('TIMESTAMP') := 8;
\n TypeMap('DATETIME') := 8;
\n TypeMap('TIME WITH TIME ZONE') := 7;
\n TypeMap('TIMESTAMP WITH TIME ZONE') := 10;
\n TypeMap('DATETIME WITH TIME ZONE') := 10; \/*\u53c2\u8003\u7c7b\u578b TIMESTAMP WITH TIME ZONE*\/
\n TypeMap('INTERVAL YEAR') := 12;
\n TypeMap('INTERVAL MONTH') := 12;
\n TypeMap('INTERVAL YEAR TO MONTH') := 12;
\n TypeMap('INTERVAL DAY') := 24;
\n TypeMap('INTERVAL HOUR') := 24;
\n TypeMap('INTERVAL MINUTE') := 24;
\n TypeMap('INTERVAL SECOND') := 24;
\n TypeMap('INTERVAL DAY TO HOUR') := 24;
\n TypeMap('INTERVAL DAY TO MINUTE') := 24;
\n TypeMap('INTERVAL DAY TO SECOND') := 24;
\n TypeMap('INTERVAL HOUR TO MINUTE') := 24;
\n TypeMap('INTERVAL HOUR TO SECOND') := 24;
\n TypeMap('INTERVAL MINUTE TO SECOND') := 24;
\n TypeMap('BLOB') := ComputeFlag;
\n TypeMap('IMAGE') := ComputeFlag;
\n TypeMap('LONGVARBINARY') := ComputeFlag;
\n TypeMap('CLOB') := ComputeFlag;
\n TypeMap('TEXT') := ComputeFlag;
\n TypeMap('LONGVARCHAR') := ComputeFlag;<\/p>\n

\/*\u83b7\u53d6\u4e00\u5217\u7684\u5b57\u8282\u6570，\u4e0d\u5305\u542b\u9700\u8ba1\u7b97\u5217\u3002*\/
\n FOR I IN (SELECT COLUMN_ID,COLUMN_NAME,DATA_TYPE,DATA_LENGTH FROM DBA_TAB_COLUMNS WHERE OWNER = UserName AND TABLE_NAME = TabName ORDER BY COLUMN_ID) LOOP<\/p>\n

\/*\u5224\u65ad\u5217\u7c7b\u578b\u662f\u5426\u5b58\u5728\u3002*\/
\n IF !(TypeMap.EXISTS(I.DATA_TYPE)) THEN
\n DBMS_OUTPUT.PUT_LINE('ColId : '||I.COLUMN_ID);
\n DBMS_OUTPUT.PUT_LINE('Col : '||I.COLUMN_NAME);
\n DBMS_OUTPUT.PUT_LINE('Unknown Type : '||I.DATA_TYPE);
\n DBMS_OUTPUT.PUT_LINE('Len : '||I.DATA_LENGTH);
\n RETURN;
\n END IF;<\/p>\n

ColSize = TypeMap(I.DATA_TYPE);<\/p>\n

\/*\u6839\u636e\u4e0d\u540c\u7c7b\u578b\u8fdb\u884c\u4e0d\u540c\u7684\u5904\u7406\u3002*\/
\n IF ColSize = PartComputeFlag THEN
\n ColSize := I.DATA_LENGTH;
\n ELSIF ColSize = ComputeFlag THEN
\n ColSize := 0;
\n ColSets(ColSetsIdx) := I.COLUMN_NAME;
\n ColSetsIdx := ColSetsIdx + 1;
\n ELSE
\n ColSize := TypeMap(I.DATA_TYPE);
\n END IF;<\/p>\n

OneRowSize := OneRowSize + ColSize;<\/p>\n

— DBMS_OUTPUT.PUT_LINE('ColId : '||I.COLUMN_ID);
\n — DBMS_OUTPUT.PUT_LINE('Col : '||I.COLUMN_NAME);
\n — DBMS_OUTPUT.PUT_LINE('Type : '||I.DATA_TYPE);
\n — DBMS_OUTPUT.PUT_LINE('Len : '||I.DATA_LENGTH);
\n — DBMS_OUTPUT.PUT_LINE('ColSize : '||ColSize);
\n — DBMS_OUTPUT.PUT_LINE('======================================');
\n END LOOP;<\/p>\n

DBMS_OUTPUT.PUT_LINE('OneRowSize(Bytes) : '||OneRowSize);<\/p>\n

\/*OneRowSize \u4e0d\u53ef\u80fd\u4e3a0，\u8bf4\u660e\u6a21\u5f0f\u6216\u8868\u4e0d\u5b58\u5728\u3002*\/
\n IF OneRowSize = 0 THEN
\n DBMS_OUTPUT.PUT_LINE('The user or table does not exist.');
\n RETURN;
\n END IF;<\/p>\n

\/*\u8ba1\u7b97\u8868\u7684\u603b\u6761\u6570\u3002*\/
\n EXECUTE IMMEDIATE CntSql INTO Cnt;<\/p>\n

DBMS_OUTPUT.PUT_LINE('Cnt : '||Cnt);
\n — DBMS_OUTPUT.PUT_LINE('ColSetsIdx : '||ColSetsIdx);<\/p>\n

\/*\u5224\u65ad\u662f\u5426\u9700\u8981\u8fdb\u884c\u5b9e\u9645\u8ba1\u7b97\u3002*\/
\n IF (ColSetsIdx > 0) AND (Cnt > 0) THEN<\/p>\n

ColSetsIdx := ColSetsIdx – 1;<\/p>\n

FOR Y IN 0..ColSetsIdx LOOP
\n ComputeSql := ComputeSql||'NVL(LENGTHB('||ColSets(Y)||'),0)';
\n IF Y != ColSetsIdx THEN
\n ComputeSql := ComputeSql||' + ';
\n END IF;
\n END LOOP;<\/p>\n

ComputeSql := ComputeSql||' ) AS TOTAL_SIZE FROM '||UserName||'.'||TabName;
\n — DBMS_OUTPUT.PUT_LINE('ComputeSql : '||ComputeSql);<\/p>\n

EXECUTE IMMEDIATE ComputeSql INTO ComputeSize;
\n END IF;<\/p>\n

DBMS_OUTPUT.PUT_LINE('ComputeSize(Bytes) : '||ComputeSize);<\/p>\n

\/*\u6240\u6709\u7ed3\u679c\u6c47\u603b\u3002*\/
\n TotalSize := OneRowSize * Cnt + ComputeSize;<\/p>\n

DBMS_OUTPUT.PUT_LINE('TotalSize(G) : '|| trunc(TotalSize \/ 1024.0 \/ 1024 \/ 1024 , 3));
\nEND;
\n\/<\/p>\n

UserName : SYSDBA
\nTabName : SUN
\nOneRowSize(Bytes) : 132
\nCnt : 327680
\nComputeSize(Bytes) : 12255232
\nTotalSize(G) : 0.051<\/p>\n

DMSQL \u8fc7\u7a0b\u5df2\u6210\u529f\u5b8c\u6210
\n\u5df2\u7528\u65f6\u95f4: 00:00:01.160. \u6267\u884c\u53f7:10113.<\/p>\n

0.059\u548c0.051\u76f8\u5dee\u4e0d\u5927，\u8bf4\u660e\u6211\u4eec\u5b9e\u73b0\u7684\u76f8\u5bf9\u51c6\u786e\u3002<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

\u76ee\u5f55 \u4e00\u3001\u73af\u5883\u4fe1\u606f
\n\u4e8c\u3001\u4ecb\u7ecd
\n\u4e09\u3001\u529f\u80fd\u4ecb\u7ecd
\n1\u3001\u5b9a\u4e49
\n2\u3001\u81ea\u8c03\u6574
\n3\u3001\u63d0\u793a
\n\u56db\u3001\u5b9e\u9a8c
\n1\u3001\u6d4b\u8bd5\u6570\u636e
\n2\u3001\u89c6\u56fe\u67e5\u770b\u8868\u5927\u5c0f
\n3\u3001\u533f\u540d\u5757\u8ba1\u7b97\u8868\u5927\u5c0f \u4e00\u3001\u73af\u5883\u4fe1\u606f
\n\u540d\u79f0\u503cCPU12th Gen Intel(R) Core(TM) i7-12700H\u64cd\u4f5c\u7cfb\u7edfCentOS Linux release 7.9.2009 (Core)\u5185\u5b584G\u903b\u8f91\u6838\u65704DM\u7248\u672c1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0DM Database Server 64 V8 2 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0DB Version<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[58,768,371,100,44],"topic":[],"class_list":["post-60717","post","type-post","status-publish","format-standard","hentry","category-server","tag-linux","tag-sql","tag-371","tag-100","tag-44"],"yoast_head":"\n\u8fbe\u68a6\u6570\u636e\u5e93-\u5b66\u4e60-41-\u8868\u5927\u5c0f\u5feb\u901f\u4f30\u7b97 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/60717.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u8fbe\u68a6\u6570\u636e\u5e93-\u5b66\u4e60-41-\u8868\u5927\u5c0f\u5feb\u901f\u4f30\u7b97 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u76ee\u5f55 \u4e00\u3001\u73af\u5883\u4fe1\u606f \u4e8c\u3001\u4ecb\u7ecd \u4e09\u3001\u529f\u80fd\u4ecb\u7ecd 1\u3001\u5b9a\u4e49 2\u3001\u81ea\u8c03\u6574 3\u3001\u63d0\u793a \u56db\u3001\u5b9e\u9a8c 1\u3001\u6d4b\u8bd5\u6570\u636e 2\u3001\u89c6\u56fe\u67e5\u770b\u8868\u5927\u5c0f 3\u3001\u533f\u540d\u5757\u8ba1\u7b97\u8868\u5927\u5c0f \u4e00\u3001\u73af\u5883\u4fe1\u606f \u540d\u79f0\u503cCPU12th Gen Intel(R) Core(TM) i7-12700H\u64cd\u4f5c\u7cfb\u7edfCentOS Linux release 7.9.2009 (Core)\u5185\u5b584G\u903b\u8f91\u6838\u65704DM\u7248\u672c1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0DM Database Server 64 V8 2 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0DB Version\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/60717.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-16T00:57:19+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/60717.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/60717.html\",\"name\":\"\u8fbe\u68a6\u6570\u636e\u5e93-\u5b66\u4e60-41-\u8868\u5927\u5c0f\u5feb\u901f\u4f30\u7b97 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-01-16T00:57:19+00:00\",\"dateModified\":\"2026-01-16T00:57:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/60717.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/60717.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/60717.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u8fbe\u68a6\u6570\u636e\u5e93-\u5b66\u4e60-41-\u8868\u5927\u5c0f\u5feb\u901f\u4f30\u7b97\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u8fbe\u68a6\u6570\u636e\u5e93-\u5b66\u4e60-41-\u8868\u5927\u5c0f\u5feb\u901f\u4f30\u7b97 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/60717.html","og_locale":"zh_CN","og_type":"article","og_title":"\u8fbe\u68a6\u6570\u636e\u5e93-\u5b66\u4e60-41-\u8868\u5927\u5c0f\u5feb\u901f\u4f30\u7b97 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u76ee\u5f55 \u4e00\u3001\u73af\u5883\u4fe1\u606f \u4e8c\u3001\u4ecb\u7ecd \u4e09\u3001\u529f\u80fd\u4ecb\u7ecd 1\u3001\u5b9a\u4e49 2\u3001\u81ea\u8c03\u6574 3\u3001\u63d0\u793a \u56db\u3001\u5b9e\u9a8c 1\u3001\u6d4b\u8bd5\u6570\u636e 2\u3001\u89c6\u56fe\u67e5\u770b\u8868\u5927\u5c0f 3\u3001\u533f\u540d\u5757\u8ba1\u7b97\u8868\u5927\u5c0f \u4e00\u3001\u73af\u5883\u4fe1\u606f \u540d\u79f0\u503cCPU12th Gen Intel(R) Core(TM) i7-12700H\u64cd\u4f5c\u7cfb\u7edfCentOS Linux release 7.9.2009 (Core)\u5185\u5b584G\u903b\u8f91\u6838\u65704DM\u7248\u672c1 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0DM Database Server 64 V8 2 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0DB Version","og_url":"https:\/\/www.wsisp.com\/helps\/60717.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-01-16T00:57:19+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"8 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/60717.html","url":"https:\/\/www.wsisp.com\/helps\/60717.html","name":"\u8fbe\u68a6\u6570\u636e\u5e93-\u5b66\u4e60-41-\u8868\u5927\u5c0f\u5feb\u901f\u4f30\u7b97 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-01-16T00:57:19+00:00","dateModified":"2026-01-16T00:57:19+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/60717.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/60717.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/60717.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u8fbe\u68a6\u6570\u636e\u5e93-\u5b66\u4e60-41-\u8868\u5927\u5c0f\u5feb\u901f\u4f30\u7b97"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/60717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=60717"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/60717\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=60717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=60717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=60717"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=60717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}