oracleͨ¹ýÊý¾Ý×Öµä²éѯ¿´Ö´Ðмƻ®
SELECT a.ADDRESS,
sql_text,
executions,
rows_processed,
cpu_time,
a.DISK_READS,
a.BUFFER_GETS,
a.ELAPSED_TIME,
a.*
from V$SQLAREA a
WHERE sql_text LIKE '%mazhanling%'
AND sql_text NOT LIKE '%SQLAREA%';
select lpad(' ', 2 * (level - 1)) || operation "Operation",
options "Options",
decode(to_char(id),
'0',
'Cost=' || nvl(to_char(position), 'n/a'),
object_name) "Object Name",
substr(optimizer, 1, 6) "Optimizer"
from v$sql_plan a
start with address = '0700001054479520'
and id = 0
connect by prior id = a.parent_id
and prior a.address = a.address
and prior a.hash_value = a.hash_value;
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ʹÓÃjava + oracle²åÈëclobÀàÐ͵ÄÊý¾Ý£¬ÐèÒªÓÃÒÔϵIJ½Ö裺
1¡¢½«Êý¾Ý²åÈëÊý¾Ý¿â£¬¶ÔÓÚclob×ֶΣ¬Ê¹ÆäΪ¿ÕclobÊý¾Ý¡£ÀýÈ磺insert into test values(1,empty_clob())";
2¡¢´ÓÊý¾Ý¿âÖÐÈ¡³ö²åÈëµÄclob×ֶΣ¬²¢½«Æä¸³Öµ¸øoracle.sql.clobÀàÐ͵ıäÁ¿¡£ÀýÈç
String sqll="select content from test where id=1 for upda ......
41.SYSDATE
ÓÃÀ´µÃµ½ÏµÍ³µÄµ±Ç°ÈÕÆÚ
SQL> select to_char(sysdate,dd-mm-yyyy day) from dual;
TO_CHAR(SYSDATE,
-----------------
09-05-2004ÐÇÆÚÈÕ
trunc(date,fmt)°´ÕÕ¸ø³öµÄÒªÇó½«ÈÕÆÚ½Ø¶Ï,È ......
oracle×÷ΪһÖÖ´óÐÍÊý¾Ý¿â£¬¹ã·ºÓ¦ÓÃÓÚ½ðÈÚ¡¢Óʵ硢µçÁ¦¡¢Ãñº½µÈÊý¾ÝÍÌÍÂÁ¿¾Þ´ó£¬¼ÆËã»úÍøÂç¹ã·ºÆÕ¼°µÄÖØÒª²¿ÃÅ¡£¶ÔÓÚϵͳ¹ÜÀíÔ±À´½²£¬ÈçºÎ±£Ö¤ÍøÂç
Îȶ¨ÔËÐУ¬ÈçºÎÌá¸ßÊý¾Ý¿âÐÔÄÜ£¬Ê¹Æä¸ü¼Ó°²È«¸ßЧ£¬¾ÍÏÔµÃÓÈÎªÖØÒª¡£×÷ΪӰÏìÊý¾Ý¿âÐÔÄܵÄÒ»´óÒòËØ--Êý¾Ý¿âË鯬£¬Ó¦µ±ÒýÆðdbaµÄ×ã¹»ÖØÊÓ£¬¼°Ê±·¢ÏÖ²¢
ÕûÀíË鯬ÄËÊÇdbaÒ»Ïî ......
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%--
ʹÓÃJDBCÁ¬½ÓOracleÊý¾Ý¿â
--%>
<%!
String DBDRIVER="oracle.jdbc.driver.OracleDriver";
String URL="jdbc:oracle:thin:@localhost:1521:orcl";
String USER="scott ......