https://blog.youkuaiyun.com/biti_rainyzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/biti_rainy/article/details/106397https://blog.youkuaiyun.com/biti_rainy/article/details/106397biti_rainyThu, 16 Sep 2004 11:55:00 +0800https://blog.youkuaiyun.com/biti_rainy/article/details/83612https://blog.youkuaiyun.com/biti_rainy/article/details/83612biti_rainyTue, 24 Aug 2004 17:39:00 +0800sys@OCN>ALTER SESSION SET EVENTS  2      1652 trace name errorstack level 1;Session altered.select">sys@OCN>]]>https://blog.youkuaiyun.com/biti_rainy/article/details/71778https://blog.youkuaiyun.com/biti_rainy/article/details/71778biti_rainyWed, 11 Aug 2004 22:04:00 +0800https://blog.youkuaiyun.com/biti_rainy/article/details/57932https://blog.youkuaiyun.com/biti_rainy/article/details/57932biti_rainySun, 01 Aug 2004 15:04:00 +0800https://blog.youkuaiyun.com/biti_rainy/article/details/53209https://blog.youkuaiyun.com/biti_rainy/article/details/53209biti_rainyTue, 27 Jul 2004 13:13:00 +0800>   在我的测试中，由于我降低了SGA的起点(降低SGA起点和本文章没有实质上的关系，仅仅因为我的测试数据库正好是被降低了sga起点而已)，从0x5000000降低到0x42000000,也就是说，当没有降低的时候，SGA的理论极限值是约小于1.75G,我降低起点后，SGA的极限值大约是1.95G。 show">sys@OCN> s]]>https://blog.youkuaiyun.com/biti_rainy/article/details/52010https://blog.youkuaiyun.com/biti_rainy/article/details/52010biti_rainyMon, 26 Jul 2004 13:02:00 +0800https://blog.youkuaiyun.com/biti_rainy/article/details/39503https://blog.youkuaiyun.com/biti_rainy/article/details/39503biti_rainyMon, 12 Jul 2004 11:58:00 +0800 select * from all_users;  USERNAME USER_ID CREATED  ------------------------------ ---------- ----------  SYS 0 14-11月-00  SYST]]>https://blog.youkuaiyun.com/biti_rainy/article/details/39500https://blog.youkuaiyun.com/biti_rainy/article/details/39500biti_rainyMon, 12 Jul 2004 11:54:00 +0800https://blog.youkuaiyun.com/biti_rainy/article/details/39496https://blog.youkuaiyun.com/biti_rainy/article/details/39496biti_rainyMon, 12 Jul 2004 11:53:00 +0800 desc obj$   名称                                     空?      类型   ---------------------------------------- -------- ---------------------------   OBJ#                                     NOT NULL N]]>https://blog.youkuaiyun.com/biti_rainy/article/details/39490https://blog.youkuaiyun.com/biti_rainy/article/details/39490biti_rainyMon, 12 Jul 2004 11:49:00 +0800 desc sys.dbms_shared_pool PROCEDURE ABORTED_REQUEST_THRESHOLD   Argument Name                  Type                    In/Out Default?   ------------------------------ ----------------------- ---]]>https://blog.youkuaiyun.com/biti_rainy/article/details/39489https://blog.youkuaiyun.com/biti_rainy/article/details/39489biti_rainyMon, 12 Jul 2004 11:47:00 +0800 select * from t where object_id=100;     OBJECT_ID OWNER]]>https://blog.youkuaiyun.com/biti_rainy/article/details/39476https://blog.youkuaiyun.com/biti_rainy/article/details/39476biti_rainyMon, 12 Jul 2004 11:36:00 +0800 select * from v$waitstat;   CLASS                   COUNT       TIME ------------------ ---------- ---------- data block                  2          1 sort block                  0     ]]>https://blog.youkuaiyun.com/biti_rainy/article/details/39473https://blog.youkuaiyun.com/biti_rainy/article/details/39473biti_rainyMon, 12 Jul 2004 11:34:00 +0800https://blog.youkuaiyun.com/biti_rainy/article/details/39466https://blog.youkuaiyun.com/biti_rainy/article/details/39466biti_rainyMon, 12 Jul 2004 11:29:00 +0800 alter session set cursor_sharing = similar;   Session altered. SQL> select name,value from v$sysstat where name like %parse%;   NAME                                   ]]>https://blog.youkuaiyun.com/biti_rainy/article/details/39445https://blog.youkuaiyun.com/biti_rainy/article/details/39445biti_rainyMon, 12 Jul 2004 11:09:00 +0800https://blog.youkuaiyun.com/biti_rainy/article/details/39437https://blog.youkuaiyun.com/biti_rainy/article/details/39437biti_rainyMon, 12 Jul 2004 11:03:00 +0800https://blog.youkuaiyun.com/biti_rainy/article/details/38151https://blog.youkuaiyun.com/biti_rainy/article/details/38151biti_rainyFri, 09 Jul 2004 21:11:00 +0800 create table t as select * from all_objects where rown]]>https://blog.youkuaiyun.com/biti_rainy/article/details/35188https://blog.youkuaiyun.com/biti_rainy/article/details/35188biti_rainyTue, 06 Jul 2004 12:51:00 +0800https://blog.youkuaiyun.com/biti_rainy/article/details/34554https://blog.youkuaiyun.com/biti_rainy/article/details/34554biti_rainyMon, 05 Jul 2004 18:14:00 +0800https://blog.youkuaiyun.com/biti_rainy/article/details/34544https://blog.youkuaiyun.com/biti_rainy/article/details/34544biti_rainyMon, 05 Jul 2004 18:03:00 +0800