DBAÓ¦¸ÃÕÆÎÕµÄSQLÓï¾ä
1.¹ØÓÚÊý¾Ý¿â¹¹¼ÜÌåϵ
¢Ù±í¿Õ¼äµÄ¼à¿ØÊÇÒ»¸öÖØÒªµÄÈÎÎñ£¬ÎÒÃDZØÐëʱ¿Ì¹ØÐıí¿Õ¼äµÄÉèÖã¬ÊÇ·ñÂú×ãÏÖÔÚÓ¦
ÓõÄÐèÇó£¬ÒÔϵÄÓï¾ä¿ÉÒÔ²éѯµ½±í¿Õ¼äµÄÏêϸÐÅÏ¢¡£
SQL code
SELECT TABLESPACE_NAME,
INITIAL_EXTENT,
NEXT_EXTENT,
MIN_EXTENTS,
MAX_EXTENTS,
PCT_INCREASE,
MIN_EXTLEN,
STATUS,
CONTENTS,
LOGGING,
EXTENT_MANAGEMENT, -- Columns not available in v8.0.x
ALLOCATION_TYPE, -- Remove these columns if running
PLUGGED_IN, -- against a v8.0.x database
SEGMENT_SPACE_MANAGEMENT --use only in v9.2.x or later
from DBA_TABLESPACES
ORDER BY TABLESPACE_NAME;
¢Ú¶ÔÓÚijЩÊý¾ÝÎļþûÓÐÉèÖÃΪ×Ô¶¯À©Õ¹µÄ±í¿Õ¼äÀ´Ëµ£¬Èç¹û±í¿Õ¼äÂúÁË£¬¾Í½«Òâζ×Å
Êý¾Ý¿â¿ÉÄÜ»áÒòΪûÓÐ¿Õ¼ä¶øÍ£Ö¹ÏÂÀ´¡£¼à¿Ø±í¿Õ¼ä£¬×îÖ÷ÒªµÄ¾ÍÊÇ¼à¿ØÊ£Óà¿Õ¼äµÄ´ó
С»òÕßÊÇʹÓÃÂÊ¡£ÒÔÏÂÊÇ¼à¿Ø±í¿Õ¼äʹÓÃÂÊÓëÊ£Óà¿Õ¼ä´óСµÄÓï¾ä¡£
SQL code
SELECT D.TABLESPACE_NAME,
SPACE "SUM_SPACE(M)",
BLOCKS SUM_BLOCKS,
SPACE - NVL(FREE_SPACE, 0) "USED_SPACE(M)",
ROUND((1 - NVL(FREE_SPACE, 0) / SPACE) * 100, 2) "USED_RATE(%)",
FREE_SPACE "FREE_SPACE(M)"
from (SELECT TABLESPACE_NAME,
ROUND(SUM(BYTES) / (1024 * 1024), 2) SPACE,
SUM(BLOCKS) BLOCKS
&
Ïà¹ØÎĵµ£º
ÔÚWhere×Ó¾äÖУ¬¿ÉÒÔ¶Ôdatetime¡¢char¡¢varchar×Ö¶ÎÀàÐ͵ÄÁÐÓÃLike×Ó¾äÅäºÏͨÅä·ûѡȡÄÇЩ“ºÜÏñ...”µÄÊý¾Ý¼Ç¼£¬ÒÔÏÂÊÇ¿ÉʹÓõÄͨÅä·û£º
% Áã»òÕß¶à¸ö×Ö·û
_ µ¥Ò»ÈκÎ×Ö·û£¨Ï»®Ïߣ©
\ ÌØÊâ×Ö·û
[] ÔÚijһ·¶Î§ÄÚµÄ×Ö·û£¬Èç ......
µÚÒ»Ìõ£º
select * from where field in (1,2,3) ÕâÖÖд·¨Ó¦¸ÃÉáÆúÁË£¬¶øÓ¦¸ÃÕâÑùд£º
select * from table where field = 1 or field = 2 or field = 3
ÎªÊ²Ã´ÄØ£¿
·²ÊÂÖ»ÓÐ×ö¹ý²ÅÖªµÀ£¬×Ô¼º½¨¸ö±í£¬²åÈë10WÌõ²âÊÔÊý¾Ý£¬ÓÃsql²âÊÔһϱãÖª£¬ÒòΪ¹¤×÷±ãÀû£¬ÎÒÔÚ²úÆ·»úºÍÍâÍø²âÊÔ»ú¶¼ÒѾ²âÊÔ¹ý£ ......
Five basic search conditions are summarized here:
1) Comparison test
2) Range test
3) Set membership test
4) Pattern matching test (Like)
The pattern matching test checks to see whether the data value in a column matches a specified pattern
% mathes any se ......
SQL Lite
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
It is a open source product and can be downloaded from http://www.sqlite.org/ . SQL Lite is best suited in Smart Client architecture, where we can locally store all ......
¿´µ½±ðÈËÔÚÂÛ̳µÄÌáÎÊ£º
Ò»¸ö±íµÄЧÂÊÎÊÌâ
½ñÌìÅöµ½2Õűí
1ÕÅ ÓÐ×Ö¶Î
±íAÓÐ
jtbh(¼ÒÍ¥±àºÅ) hzxm(»§Ö÷ÐÕÃû) hnbh(»§ÄÚ×î´ó±àºÅ)
1000 ÕÅÈý 03
1001 ÕÔÁù..........................
±í ......