²éѯOracle×ÊԴʹÓÃÇé¿ö
SELECT trim(NAME) ||' '|| VALUE from v$parameter
WHERE NAME IN ('sga_max_size','db_cache_size','shared_pool_size',
'shared_pool_reserved_size','large_pool_size','java_pool_size',
'db_block_size','db_block_buffers','log_buffer','sort_area_size',
'sort_area_retained_size','hash_area_size','sessions','open_cursors')
ORDER BY NAME;
TRIM(NAME)||''||VALUE
--------------------------------------------------------------------------------
db_block_buffers 0 0
db_block_size 8192 8192
db_cache_size 2,281,701,376 8,589,934,592
hash_area_size 4194304 131072
java_pool_size &
Ïà¹ØÎĵµ£º
Oracle°²×°Æª
°æ±¾£ºwin32_11gR1_database_1013
ϵͳ£ºwin7
Äڴ棺3g£¨Å¼×Ô¼ºµØ-0-£©
1¡¢ÒòΪ²Ù×÷ϵͳѡÔñÁËwin7£¬ËùÒÔÔÚ°²×°Ö®Ñ¡ÐèÒªÐÞ¸ÄÒ»ÏÂÅäÖÃÎļþ£¬database\stage\prereq\db\refhost.xml
2¡¢ÐÞ¸ÄÍêÅäÖÃÎļþºó£¬µãinstall°²×°¼´¿É£¬µÈdos½çÃæ¼ÓÔØÍêºóÌø³öÈçϽçÃæ
3¡¢ÏÂÒ»²½
4¡¢Ñ¡ÔñÆóÒµ°æ£¬È»ºó ......
£££££¹ØÓÚ·Ö×éºó×Ö¶ÎÆ´½ÓµÄÎÊÌâ
À´×Ô:www.itpub.net
×î½üÔÚÂÛ̳ÉÏ£¬¾³£»á¿´µ½¹ØÓÚ·Ö×éºó×Ö¶ÎÆ´½ÓµÄÎÊÌ⣬
´ó¸ÅÊÇÀàËÆÏÂÁеÄÇéÐΣº
SQL> select no,q from test
2 /
NO Q
---------- ------------------------------
001 n1
001 n2
001 n3
001 n4
001 n5
002 m1
003 t1
003 t2
003 t3
003 ......
1£¬oracle tools£ºOUI¡¢DBCA¡¢OEM¡¢SQL*PLUS¡¢NETCA¡¢µÚÈý·½¹¤¾ß£¨toad¡¢PL\SQL developer£©
2£¬¿ÉʹÓÃresponsefile¿ìËÙȥͼÐΰ²×°oracle£¬ÔÚÔ´°²×°Îļþ/responseÀïÃæÓÐһЩģ°åÅäÖÃrpsÎļþ
3£¬Ô¤ÖÃÓû§ÊÇsysÓû§ÓësystemÓû§£ºsysÊÇoracleÊý¾Ý¿â
ÖÐȨÏÞ×î¸ßµÄÕʺţ¬¾ßÓÐcreate
databaseµÄȨÏÞ£¬¶øsystemûÓÐÕâ¸öȨÏÞ£ ......
1.asp.netÁ¬½Óoracle·þÎñÆ÷ÐèÒªÌí¼ÓSytem.Data.OracleClientÃüÃû¿Õ¼ä£¬½«System.Data.OracleClient.dll¼ÓÈëµ½ÏîÄ¿ÖС£
2.Á¬½ÓʱÐèÒªConnectionString×Ö·û´®£¬³öÏÖÔÚweb.configÎļþÖУ¬ÈçÏÂËùʾ£º
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=( ......