UNIX Tips
|
Install Tips
|
Database Tips
|
|
Cron Jobs
|
Check OS Block_Size
|
Writing to the alert log
|
|
Deleting
Files according to dates (example 5 days old)
|
Pin Objects at Startup
|
Connect as SYSDBA
|
|
Switching ORACLE_HOME and
Oracle_SID
|
Delete DB during Creation
|
Outer Join - Usage and
Efficiency
|
|
uname: Finding O/S Version
|
Start DB Listener boot
time
|
Managing Dates - Extract
Date Information
|
|
nslookup: Finding ip address
|
Setting umask and access
|
Adding SID to the SQL
Prompt (glogin)
|
|
ps: Finding ps id for trace or
other exec
|
Setting TWO_TASK
|
Move tables
|
|
Zip or Tar a directory
|
Listener - Starting, Stopping
|
Rebuild Indexes
|
|
Change DISPLAY
|
Find an available port
|
Rebuild
Index? There is an alternative
|
|
cp: Copying a directory to
another location
|
Change
Ownership
Of Oracle Software On Unix
|
Enable/Disable Archiving
|
|
df -tk: Available space on UNIX
|
OS Authentication
|
Recompile
Schema
Objects
|
|
du -sk: Size of directory
|
Deleting
Files from Windows
|
DBMS_XPLAN
|
|
grep: Some useful grep options
|
Load
Balancing and Increase SQL*NET Performance |
Delete duplicate
Records
|
|
wc: Count files in a directory
|
Change
Oracle UID and GIP (Userid and Group ID) |
Shrink Datafiles
and reduce UNDO - TEMP
|
|
wall: Sending message to all users
on UNIX
|
Command
History on SQL Plus (rlwrap)
|
Transportable
Tablespaces
|
|
rm: Deleting backup files to
free space
|
EZSQL on Oracle 10g
|
Orakill Utility
|
|
Check memory in CPU
|
SSH Tunnel to DB Server
|
rap Utility
|
|
lpstat: Finding available printers
|
|
Copy Command
|
|
rcp: Setting up system to do
remote copy
|
Speed Up Oracle in
your Laptop
|
Authid Current_User vs Authid
Definer
|
|
vi: Doing a search and
replace in vi
|
|
What is locking table?
|
|
tr -d: Stripping control chars from
ascii file
|
|
Select Randomly from
Table
|
|
ipcs: Cleaning up memory when a
db process is killed
|
|
Space needed for
Archive Log Files
|
|
co/ci: Locking/Unlocking archive
files
|
|
Unlock users
|
| Use rlwap to get
Command History in SQL*Plus |
|
dbms_utility.get_time
|
Performing Loop
Actions with Files
|
|
Orapwd
File
|
| Changing Group
ID or User ID in Unix |
|
Change DB
Name and data file paths
|
| Run Commands in
Background |
|
Get IP Address and
Name of DB Server
|
| Examples of the FIND
command |
|
Create SCOTT Example Schema
|
|
|
Install Oracle Java |
|
|
Pivot
Table
|
|
|
What code is
executed? |
|
|
Export Data to Excel |
|
|
ORA-00257
- Arch Log Full
|
|
|
Managing Redo Log
Files and Groups
|
|
|
Working with Sequences |
|
|
Restrict Access by IP
Address |
|
|
Connect to a DB
without TNSNAMES |
|
|
Flush the
Buffer and Shared Pool |