Instance Monitoring Tools

Can anyone give me an idea of what are the best Oracle instance monitoring tools on the market? Thanks, Rick Stephenson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 Sa

Oracle Intermedia Text

I am using Oracle 8.1.7.2 on Solaris 2.8 Here is the script I am running: === create table testtext ( searchfield varchar(100)); insert into testtext values ('rstephenVb03R/o2Vi7Iwomigod/o/r/rstephen'); insert into testtext values ('gar

CLOB datatype

Does anyone have any opinions on using CLOB/NCLOB datatypes in Oracle? I am running 8.1.7.2 on Solaris. Oracle Docs state that CLOBs can handle up to 4 Gig. Are there any gotchas by using CLOBs? Thanks for any information, Rick Stephenson -- Please see the official ORACLE-L FAQ: http://www.

Clocks rolling back?

Are there any issues with Oracle that I should know about when the clocks roll back this weekend? Rick Stephenson Oracle/Sybase Database Administrator [EMAIL PROTECTED] Ovid Technologies, Inc. 9350 South 150 East, Suite 300 Sandy, UT 84070 (801) 304-3000 ext. 2593 -- Please see the official ORA

Books or Websites that discuss RMAN?

Does anyone know of a good site/book, other than Oracle Docs, that gives a good explanation of RMAN? Thanks, Rick Stephenson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-50

Searching across multiple columns

Does Oracle have a way to do a search across multiple columns/tables for specific data? I know I can issue a query with a bunch of or statements, but is there something similar to fulltext searching? Thanks for the information, Rick Stephenson -- Please see the official ORACLE-L FAQ: http://

[no subject]

SET ORACLE-L NODIGEST -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Encrypting a password

>From my understanding, the OS takes the unencrypted password, and encrypts it. It then compares that encrypted password with the password stored in the /etc/passwd file to validate the user logging in. After further review, it appears that I will have to use external procedures to accomplish t

RE: Encrypting a password

The problem is that I need one to encrypt a password in the same manner as the Sun OS. This is because we use the database to populate /etc/passwd. So if the OS can't compare passwords with what is stored in the database, then nobody will be able to log into the Unix box. Thanks for you help, R

Encrypting a password

How can I encrypt a password in Oracle that I could use to compare with an encrypted password in /etc/passwd on a Sun Unix box? I am on Solaris 2.8 running Oracle 8.1.7. I have read about encrypting and decrypting using the dbms_obfuscation package, but this does not seem to get me what I am loo