ORA-00257 A scheduler job which is refreshing materialized views threw an error ORA-00257 in the alert log like this: ORA-12012: error on auto execute of… Read More »How to Resolve ORA-00257: archiver error. Connect internal only, until freed.
Here I demonstrate how to remove files with names containing special characters: $ echo "Hello" > "177" $ ls -il total 2 234981… Read More »How to Remove Files with Names Containing Special Characters
Mostly, we can monitor overall IO activities by using "top" in Solaris, in there, an indicator called "iowait" can be a good target to watch:$… Read More »How to Monitor IO Performance and Disks Activities on Solaris
External procedures are very special procedures stored outside of the database, and it can be coded by C or Java language. Since the external libraries… Read More »External Procedures May Consume a Lot of Memory
You might want to comment out some lines of shell script code during debug-time, you can just add a pound sign # to the head… Read More »How to Comment Out a Huge Block of Shell Code
If the database server was in performance bottlenecks, there could be various kinds of errors. Here is one case of low memory. First of all,… Read More »ksbsrv: No Startup Acknowledgement From Forked Process After 30 Seconds
OP usually have been told and trained to use "top" command to monitor the overall status of a server, the "top" command can show many… Read More »How to Monitor UNIX CPU Usage by Process
There is no direct FTP command that can recursively download a directory, so don't expect that you can do this operation in one or few… Read More »How to Retrieve a Directory Recursively by FTP Alternatively