norestlogs and resetlogs
Noresetlogs: using the redo log SCNresetlogs: using the data files SCN
引用: Solaris 内存使用的命令
Solaris 10 memory usage analysis It so happens that I need to get a bit more insight into what’s eating all the RAM on one of my solaris boxes. Whenever this happens I can never remember all the var...
鸟哥sh04.sh在Solaris上的实现
echo "You should input 2 numbers:\n"echo "First number: "read firstnumecho "Second number: "read Secondnumtotal=`expr $firstnum \* $Secondnum`echo "\n The number $firstnum * $Secondnum is ==> $total" ...
鸟哥代码sh03.sh在Solaris上实现
echo "Please input the file name: "read fileuser#Avoid the User type the 'Enter' directlyfilename=${fileuser:-"filename"}#Capture the date for three daysYesterday=`TZ=GMT+16 date +%Y%m%d`Today=`date...
普通用户访问字典表和视图
grant select on v_$session to dmteam;v_$session 是v$session的别名。因为V$session使用的是别名,所以权限不能直接赋予查询权限,需要赋予源表权限。另外一种解决方式:授予SELECT ANY DICTIONARY权限(对所...