<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[jamplon的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/jamplon</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; jamplon]]></copyright><item><title><![CDATA[ORA-01658无法为表空间中的段创建INITIAL区]]></title><link>https://blog.youkuaiyun.com/jamplon/article/details/96332251</link><guid>https://blog.youkuaiyun.com/jamplon/article/details/96332251</guid><author>jamplon</author><pubDate>Wed, 17 Jul 2019 17:31:20 +0800</pubDate><description><![CDATA[1、查看表空间使用率情况

可以看到对应的数据库表空间已经满了。

SELECT a.tablespace_name "表空间名",

   total/1024/1024 "表空间大小单位M",

   free/1024/1024 "表空间剩余大小单位M",

   (total - free)/1024/1024 "表空间使用大小单位M",

   Roun...]]></description><category></category></item><item><title><![CDATA[Oracle数据库内存使用情况分析；内存占用过高]]></title><link>https://blog.youkuaiyun.com/jamplon/article/details/88950579</link><guid>https://blog.youkuaiyun.com/jamplon/article/details/88950579</guid><author>jamplon</author><pubDate>Mon, 01 Apr 2019 16:13:05 +0800</pubDate><description><![CDATA[查看会话内存占用情况

SELECT server "连接类型",
   s.username,
   OSUSEr,
   NAME,
   VALUE/1024/1024 "占用内存MB",
   s.SID "会话ID",
   s.serial#,
   spid "操作系统进程ID",
   p.PGA_USED_MEM,
...]]></description><category></category></item><item><title><![CDATA[Oracle  归档日志已满处理方式]]></title><link>https://blog.youkuaiyun.com/jamplon/article/details/82877464</link><guid>https://blog.youkuaiyun.com/jamplon/article/details/82877464</guid><author>jamplon</author><pubDate>Fri, 28 Sep 2018 10:31:34 +0800</pubDate><description><![CDATA[show parameter db_recovery_file_dest_size;
select sum(a.BLOCK_SIZE*a.BLOCKS)/1024/1024 from v$archived_log a where a.DELETED='NO';
删除归档日志
RMAN&amp;gt;connect target /
RMAN&amp;gt;list archivelog all;
RMAN&amp;gt;...]]></description><category></category></item><item><title><![CDATA[oracle EXP-00028: 无法打开用于写入的 expdate.dmp]]></title><link>https://blog.youkuaiyun.com/jamplon/article/details/52402185</link><guid>https://blog.youkuaiyun.com/jamplon/article/details/52402185</guid><author>jamplon</author><pubDate>Thu, 01 Sep 2016 17:52:32 +0800</pubDate><description><![CDATA[用exp备份带日期格式的文件名,命令如下:

exp erpsys/12345678@mytestdafile=e:\backup\erpsys_mytestda_%date:~0,10%.dmp log=e:\backup\erpsys_mytestda_%date:~0,10%.log rows=n
 buffer=65536000 owner=erpsys

 

成功执行后文]]></description><category></category></item><item><title><![CDATA[oracle   EXP-00028: 无法打开用于写入的 expdate.dmp]]></title><link>https://blog.youkuaiyun.com/jamplon/article/details/52402173</link><guid>https://blog.youkuaiyun.com/jamplon/article/details/52402173</guid><author>jamplon</author><pubDate>Thu, 01 Sep 2016 17:50:16 +0800</pubDate><description><![CDATA[用exp备份带日期格式的文件名,命令如下:

exp erpsys/12345678@mytestdafile=e:\backup\erpsys_mytestda_%date:~0,10%.dmp log=e:\backup\erpsys_mytestda_%date:~0,10%.log rows=n
 buffer=65536000 owner=erpsys

 

成功执行后文]]></description><category></category></item><item><title><![CDATA[查看oracle表数据量]]></title><link>https://blog.youkuaiyun.com/jamplon/article/details/52275149</link><guid>https://blog.youkuaiyun.com/jamplon/article/details/52275149</guid><author>jamplon</author><pubDate>Mon, 22 Aug 2016 11:14:16 +0800</pubDate><description><![CDATA[select t.TABLE_NAME,t.NUM_ROWS  from user_tables t]]></description><category></category></item></channel></rss>