UNIX Tips
|
Install Tips
|
Database Tips
|
| Cron Jobs |
Check OS Block_Size |
What is locking table? |
| Deleting Files according
to dates (example 5 days old) |
Pin Objects at Startup
|
Add/Remove Services to Oracle Names Server |
| Switching ORACLE_HOME and Oracle_SID
|
Delete DB during Creation
|
Connect as SYSDBA |
| uname: Finding O/S Version
|
SGA Size |
Managing Dates
|
| nslookup: Finding ip address |
Setting umask and access |
Context Server |
| ps: Finding ps id for trace or other exec
|
Listener - Starting, Stopping
|
Move tables |
| Zip or Tar a directory |
Net Listener - Starting, Stopping
|
Rebuild Indexes |
| Change DISPLAY |
Find an available port |
Rebuild Index?
There is an alternative |
| cp: Copying a directory to another location
|
Restore DB & change DB name
|
Archiving ON |
| df -tk: Available space on UNIX
|
Appending Directory to $PATH
|
Archiving OFF |
| du -sk: Size of directory |
Setting TWO_TASK |
Running Trace |
| grep: Some useful grep options
|
|
Recompile scripts |
| wc: Count files in a directory
|
|
Shrinking Datafiles
|
| wall: Sending message to all users on UNIX
|
|
Transportable Tablespaces
|
| co/ci: Locking/Unlocking archive files
|
|
Adding SID to the SQL Prompt
|
| rm: Deleting backup files to free space
|
|
Set Timing ON |
| Check memory in CPU
|
|
Wrap Utility |
| lpstat: Finding available printers
|
|
Copy Command |
| rcp: Setting up system to do remote
copy |
|
Delete duplicate Records
|
| vi: Doing a search and replace in
vi |
|
Finding and
Eliminating BIG Duplicate Data |
| tr -d: Stripping control chars from ascii
file |
|
Turning Archiving On and Off
|
| ipcs: Cleaning up memory when a db process
is killed |
|
Space
needed for Archive Log Files |
|
|
Unlock users |
|
|
Wake up SMON to clean up temp segments |
|
|
Select Randomly from
Table |
|
|
Writing to the alert
log |
|
|
Update DB Version |
|
|
Change DB Name
and data file paths
|