|
| | 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 | | | | | | | | |
|
|
| | Some useful resources for webmasters and marketers
Here's a list of some resources, websites / software that may be useful for webmasters and SEO marketers.
http://www.webmasterworld.com
Great resource for webmasters, technical and marketing forums.
http://www.copyscape.com
Allows to search the web for copies of your website.
http://home.snafu.de/tilman/xenulink.html
Xenu's Link Sleuth allows to check a website for broken links. Download and install the software on ... | | More...
11/28/05 | | | | | | | | |
|
| | mod_rewrite on Windows (overwrite URLs)
Can't get mod_rewrite (rewriting URLs) working on Windows? The solution is fairly simple. Make sure you have the following in your httpd.conf. Replace "C:/www" with the directory under your DocumentRoot where you placed .htaccess file. Once you've copied the lines below into Apache configuration file restart web server and URL ... | | 
More...
11/28/05 | | | | | | | | |
|
| | Oracle Virtual Indexes - How to
Virtual index is a feature of Oracle 10 and Oracle 9. The purpose of virtual indexes is simulate the existence of an index, without actually building it, so you can explain plan as if the index existed. It is important to drop the index after you're done with it.
To build ... | | More...
11/24/05 | | | | | | | | |
|
| | How to register database with RMAN recovery catalog
Replace username/password with the actuall username and password for recovery catalog; and MYDB with the name of the recovery catalog database
1. Change SID to the database you want to register
. oraenv
ORACLE_SID
2. Connect to RMAN catalog database
rman target / catalog username/password@MYDB
3. Register database
RMAN> register database;
| |
More...
11/23/05 | | | | | | | | |
|
|
| | Rebuilding index partitions / subpartitions with corrupted block
This procedure assumes you had this error (corrupted block in index partition):
ORA-01578: ORACLE data block corrupted (file # 459, block # 15)
ORA-01110: data file 459: '/path/to/datafile.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
1. Find out which partition has corrupted block
select distinct partition_name, index_name
from dba_ind_subpartitions
where subpartition_name in
(
select partition_name
from dba_segments
where tablespace_name ... | |
More...
11/17/05 | | | | | | | | |
|
<< 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Page 11 | 12 | 13 | 14 | 15 | 16 >>
|
