\u4ecb\u7ecd\u4e00\u4e2aSQLPLUS\u4e2d\u7c98\u8d34SQL\u8bed\u53e5\u7684\u5c0f\u6280\u5de7\u3002
\n\u9664\u4e86Windows\u73af\u5883\u4e0b\u7684SQLPLUSW\u4e4b\u5916\uff0c\u5f53\u5728sqlplus\u4e2d\u8fd0\u884c\u4e86\u4e00\u4e2a\u5f88\u957f\u7684\u8bed\u53e5\u540e\uff0c\u5f97\u5230\u7684\u662f\u4e00\u4e2a\u5e26\u6709\u884c\u53f7\u7684SQL\uff1a<\/p>\n
SQL> select ksppinm name,\r\n2 ksppstvl value, \r\n3 ksppdesc des\r\n4 from x$ksppi x, x$ksppcv y \r\n5 where (x.indx = y.indx) \r\n6 and bitand(ksppiflg,268435456) = 0 \r\n7 and ksppinm like 'max%size';\r\nNAME VALUE DES\r\n------------------ ------------- -------------------------------\r\nmax_dump_file_size UNLIMITED Maximum size (blocks) of dump file<\/pre>\n\u5bf9\u4e8e\u4e0a\u9762\u7684\u7ed3\u679c\uff0c\u5982\u679c\u60f3\u8981\u590d\u5236\u7c98\u8d34\u5230SQLPLUS\u4e2d\u4f1a\u663e\u5f97\u975e\u5e38\u9ebb\u70e6\uff0c\u5fc5\u9700\u8981\u627e\u5230\u4e00\u4e2a\u652f\u6301\u5217\u9009\u7684\u7f16\u8f91\u5668\uff0c\u5c06\u524d\u9762\u7684\u884c\u53f7\u7f16\u8f91\u6389\uff0c\u5426\u5219\u867d\u7136\u4e5f\u53ef\u4ee5\u7c98\u8d34\u5230SQLPLUS\u4e2d\uff0c\u4f46\u662f\u8fd8\u8981\u901a\u8fc7\u884c\u7f16\u8f91\u65b9\u5f0f\u53bb\u6389\u6bcf\u884c\u7684\u884c\u53f7\uff0c\u6574\u4e2a\u64cd\u4f5c\u663e\u5f97\u5341\u5206\u70e6\u7410\uff1a<\/p>\n
SQL> select ksppinm name,\r\n2 2 ksppstvl value, \r\n3 3 ksppdesc des\r\n4 4 from x$ksppi x, x$ksppcv y \r\n5 5 where (x.indx = y.indx) \r\n6 6 and bitand(ksppiflg,268435456) = 0 \r\n7 7 and ksppinm like 'max%size' \r\n8 \r\nSQL> 2\r\n2* 2 ksppstvl value,\r\nSQL> c\/2\r\n2* ksppstvl value,\r\nSQL> 3\r\n3* 3 ksppdesc des\r\nSQL> c\/3\r\n3* ksppdesc des\r\nSQL> 4\r\n4* 4 from x$ksppi x, x$ksppcv y\r\nSQL> c\/4\r\n4* from x$ksppi x, x$ksppcv y\r\nSQL> 5\r\n5* 5 where (x.indx = y.indx)\r\nSQL> c\/5\r\n5* where (x.indx = y.indx)\r\nSQL> 6\r\n6* 6 and bitand(ksppiflg,268435456) = 0\r\nSQL> c\/6\r\n6* and bitand(ksppiflg,268435456) = 0\r\nSQL> 7 \r\n7* 7 and ksppinm like 'max%size'\r\nSQL> c\/7\r\n7* and ksppinm like 'max%size'\r\nSQL> l\r\n1 select ksppinm name,\r\n2 ksppstvl value,\r\n3 ksppdesc des\r\n4 from x$ksppi x, x$ksppcv y\r\n5 where (x.indx = y.indx)\r\n6 and bitand(ksppiflg,268435456) = 0\r\n7* and ksppinm like 'max%size'\r\nSQL> r\r\n1 select ksppinm name,\r\n2 ksppstvl value,\r\n3 ksppdesc des\r\n4 from x$ksppi x, x$ksppcv y\r\n5 where (x.indx = y.indx)\r\n6 and bitand(ksppiflg,268435456) = 0\r\n7* and ksppinm like 'max%size'\r\nNAME VALUE DES\r\n------------------ ------------- -------------------------------\r\nmax_dump_file_size UNLIMITED Maximum size (blocks) of dump file<\/pre>\n\u663e\u7136\u5982\u679c\u6ca1\u6709\u5217\u5f0f\u7f16\u8f91\uff0c\u5904\u7406\u8fd9\u79cd\u60c5\u51b5\u4f1a\u975e\u5e38\u9ebb\u70e6\uff0c\u5176\u5b9e\u6709\u4e00\u4e2a\u65b9\u6cd5\u53ef\u4ee5\u5f88\u65b9\u4fbf\u7684\u5904\u7406\u8fd9\u79cd\u60c5\u51b5\uff0c\u5148\u5c06\u7b2c\u4e00\u884c\u7c98\u8d34\u5230SQLPLUS\u4e2d\uff0c\u7136\u540e\u8f93\u5165\u4e24\u6b21\u56de\u8f66\u9000\u51fa\u5f53\u524d\u8bed\u53e5\u8f93\u5165\u6a21\u5f0f\uff0c\u7136\u540e\u5c31\u53ef\u4ee5\u76f4\u63a5\u5c06\u5269\u4e0b\u7684\u6240\u6709\u5305\u542b\u884c\u53f7\u7684\u884c\u7c98\u8d34\u5230SQLPLUS\u4e2d\uff1a<\/p>\n
SQL> select ksppinm name,\r\n2 \r\nSQL> 2 ksppstvl value, \r\nSQL> 3 ksppdesc des\r\nSQL> 4 from x$ksppi x, x$ksppcv y \r\nSQL> 5 where (x.indx = y.indx) \r\nSQL> 6 and bitand(ksppiflg,268435456) = 0 \r\nSQL> 7 and ksppinm like 'max%size';\r\nSQL> l\r\n1 select ksppinm name,\r\n2 ksppstvl value,\r\n3 ksppdesc des\r\n4 from x$ksppi x, x$ksppcv y\r\n5 where (x.indx = y.indx)\r\n6 and bitand(ksppiflg,268435456) = 0\r\n7* and ksppinm like 'max%size'\r\nSQL> r\r\n1 select ksppinm name,\r\n2 ksppstvl value,\r\n3 ksppdesc des\r\n4 from x$ksppi x, x$ksppcv y\r\n5 where (x.indx = y.indx)\r\n6 and bitand(ksppiflg,268435456) = 0\r\n7* and ksppinm like 'max%size'\r\nNAME VALUE DES\r\n------------------ ------------- -------------------------------\r\nmax_dump_file_size UNLIMITED Maximum size (blocks) of dump file<\/pre>\nOracle\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\u4f1a\u5c06\u7c98\u8d34\u8bed\u53e5\u4e2d\u7684\u884c\u53f7\u771f\u6b63\u7684\u4f5c\u4e3a\u5f53\u524d\u8bed\u53e5\u7684\u884c\u53f7\u3002\u8fd9\u53e5\u8bdd\u6bd4\u8f83\u96be\u7406\u89e3\uff0c\u5176\u5b9e\u5728Oracle\u5df2\u7ecf\u7f13\u51b2\u533a\u4e2d\u5305\u542b\u591a\u4e2a\u8bb0\u5f55\u884c\u65f6\uff0c\u53ef\u4ee5\u901a\u8fc7\u8bed\u53e5\u524d\u9762\u6dfb\u52a0\u884c\u53f7\u7684\u65b9\u5f0f\uff0c\u6307\u5b9a\u5f53\u524d\u7684\u5185\u5bb9\u66ff\u6362\u7f13\u51b2\u533a\u4e2d\u7684\u7b2c\u51e0\u884c\uff1a<\/p>\n
SQL> 8 abc\r\nSQL> l\r\n1 select ksppinm name,\r\n2 ksppstvl value,\r\n3 ksppdesc des\r\n4 from x$ksppi x, x$ksppcv y\r\n5 where (x.indx = y.indx)\r\n6 and bitand(ksppiflg,268435456) = 0\r\n7 and ksppinm like 'max%size'\r\n8* abc\r\nSQL> 5 desc\r\nSQL> l\r\n1 select ksppinm name,\r\n2 ksppstvl value,\r\n3 ksppdesc des\r\n4 from x$ksppi x, x$ksppcv y\r\n5 desc\r\n6 and bitand(ksppiflg,268435456) = 0\r\n7 and ksppinm like 'max%size'\r\n8* abc<\/pre>\n\u4f7f\u7528\u8fd9\u4e2a\u65b9\u6cd5\u70e6\u4eba\u7684\u884c\u53f7\u95ee\u9898\u5c31\u53ef\u4ee5\u65b9\u4fbf\u7684\u89e3\u51b3\u4e86\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4ecb\u7ecd\u4e00\u4e2aSQLPLUS\u4e2d\u7c98\u8d34SQL\u8bed\u53e5\u7684\u5c0f\u6280\u5de7\u3002 \u9664\u4e86Windows\u73af\u5883\u4e0b\u7684SQLPLUSW\u4e4b\u5916\uff0c\u5f53\u5728sqlplus\u4e2d\u8fd0\u884c\u4e86\u4e00\u4e2a\u5f88\u957f\u7684\u8bed\u53e5\u540e\uff0c\u5f97\u5230\u7684\u662f\u4e00\u4e2a\u5e26\u6709\u884c\u53f7\u7684SQL\uff1a SQL> select ksppinm name, 2 ksppstvl value, 3 ksppdesc des 4 from x$ksppi x, x$ksppcv y 5 where (x.indx = y.indx) 6 and bitand(ksppiflg,268435456) = 0 7 and ksppinm like ‘max%size’; NAME VALUE DES —————— ————- ——————————- max_dump_file_size … Continue reading