²éѯ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Ö±·½Í¼½âÎö
Ò»¡¢ ºÎνֱ·½Í¼£º
Ö±·½Í¼ÊÇÒ»ÖÖͳ¼ÆÑ§ÉϵŤ¾ß£¬²¢·ÇOracleרÓС£Í¨³£ÓÃÓÚ¶Ô±»¹ÜÀí¶ÔÏóµÄij¸ö·½ÃæµÄÖÊÁ¿Çé¿ö½øÐйÜÀí£¬Í¨³£Çé¿öÏÂËü»á±íÏÖΪһÖÖ¼¸ºÎͼÐÎ±í£¬Õâ¸öͼÐαíÊǸù¾Ý´Óʵ¼Ê»·¾³ÖÐËùÊÕ¼¯À´µÄ±»¹ÜÀí¶ÔÏóij¸ö·½ÃæµÄÖÊÁ¿·Ö²¼Çé¿öµÄÊý¾ÝËù»æÖƳɵģ¬Í¨³£»á»³ÉÒÔÊýÁ¿Îªµ×±ß£¬ÒÔÆ ......
sql*plus ÃüÁî
//Ö´Ðнű¾
@ºÍstart d:/a.txt;
//Ð޸Ľű¾
edit d:/a.txt;
//½«ÄÚÈÝÊäÈëµ½Îı¾ÖÐ
sloop d:/a.txt; //¿ªÊ¼¼Ç¼ÆÁÄ»ÄÚÈÝ
sloop off; //¼Ç¼½áÊø
//Á´½ÓµÇ¼Êý¾Ý¿â
connect system/919959 as sysdba/sysoper; //ȨÏÞ×î´ódba
connect sys/919959;
connect scott/ti ......
oracleÊý¾Ý¿âµÄ±¸·ÝÓë»Ö¸´
---- µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊǿɿ¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨°üÀ¨»úÆ÷¹ÊÕÏ¡¢½éÖʹÊÕÏ¡¢Îó²Ù×÷µÈ£©£¬Êý¾Ý¿âÓÐʱҲ¿ÉÄÜÔâµ½ÆÆ»µ£¬ÕâʱÈçºÎ¾¡¿ì»Ö¸´Êý¾Ý¾Í³ÉΪµ±ÎñÖ®¼±¡£Èç¹ûƽʱ¶ÔÊý¾Ý¿â×öÁ˱¸·Ý£¬ÄÇô´Ëʱ»Ö¸´Êý¾Ý¾ÍÏԵúÜÈÝÒס£Óɴ˿ɼû£¬×öºÃÊý¾Ý¿âµÄ±¸·ÝÊǶ ......
1.asp.netÁ¬½Óoracle·þÎñÆ÷ÐèÒªÌí¼ÓSytem.Data.OracleClientÃüÃû¿Õ¼ä£¬½«System.Data.OracleClient.dll¼ÓÈëµ½ÏîÄ¿ÖС£
2.Á¬½ÓʱÐèÒªConnectionString×Ö·û´®£¬³öÏÖÔÚweb.configÎļþÖУ¬ÈçÏÂËùʾ£º
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=( ......
¶ÔÓÚORACLEÊý¾Ý¿âµÄÊý¾Ý´æÈ¡£¬Ö÷ÒªÓÐËĸö²»Í¬µÄµ÷Õû¼¶±ð£¬µÚÒ»¼¶µ÷ÕûÊDzÙ×÷ϵͳ¼¶°üÀ¨Ó²¼þƽ̨,µÚ¶þ¼¶µ÷ÕûÊÇORACLE RDBMS¼¶µÄµ÷Õû,µÚÈý¼¶ÊÇÊý¾Ý¿âÉè¼Æ¼¶µÄµ÷Õû,×îºóÒ»¸öµ÷Õû¼¶ÊÇSQL¼¶¡£Í¨³£ÒÀ´ËËļ¶µ÷Õû¼¶±ð¶ÔÊý¾Ý¿â½øÐе÷Õû¡¢ÓÅ»¯£¬Êý¾Ý¿âµÄÕûÌåÐÔÄÜ»áµÃµ½ºÜ´óµÄ¸ÄÉÆ¡£ÏÂÃæ´Ó¼¸¸ö²»Í¬·½Ã ......