| | How to find unused indexes
To determine if your indexes are being used or you can drop them use index monitoring (this feature is available from Oracle 9 onwards).
1. To start index monitoring:
SQL> alter index SAMPLE_INDEX monitoring usage;
If this statement fails with
ORA-00054: resource busy and acquire with NOWAIT specified
The index is already being used, so ... | |  
More...
01/24/06 | | | | | | | | |
|
| | How to remove a parameter from spfile
This feature is available in Oracle 9 and Oracle 10. To remove a parameter from spfile and reset it to default value run the following command:
alter system reset "_db_block_lru_latches" scope=spfile sid='*';
| | 
More...
01/23/06 | | | | | | | | |
|
| | Special syntax for searches in Google
This is a list of special commands to use for search on Google. They could greatly improve the quality of search results, filtering sites you are not interested in.
1. Search for something in the page title
intitle:
2. Restrict your search to the URL of websites
inurl:
3. Only search in the context of ... | | More...
01/17/06 | | | | | | | | |
|
|
| | View the process tree on Unix
To see the process tree i.e. display all children of a process use ptree
This will show all processes and their children:
$ ptree
- or -
This will show tree for a specific process
$ ptree [process id] | |
More...
12/16/05 | | | | | | | | |
|
| | Probe for devices and reconfigure
This command will probe for devices under /dev and /devices directories and update /etc/path_to_inst file. Have a look at the manual page for command line options.
devfsadm | | More...
12/12/05 | | | | | | | | |
|
|
| | How to find all hard links to a file
Use find command to get a list of all hard links to a file.
1. Find out the inode number for the file
ls -asldi [filename]
2. Run find
find . -inum [inode number]
| |
More...
12/12/05 | | | | | | | | |
|
| | Kill Oracle sessions from OS level
When shutdown immediate does not work this command may help (replace DBNAME with ORACLE_SID of database you are trying to shutdown):
kill -9 `ps -ef | grep DBNAME | grep 'LOCAL=' | awk '{printf("%s ", $2);}'` | |
More...
12/04/05 | | | | | | | | |
|
|
<< 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | Page 15 | 16 | 17 | 18 | 19 | 20 | 21 >>
|
