Importing LOB segments

Hi there, I have been importin 2gig of LOBs and it is extremely slow, is there any way how to speed up this process... rgds jbHöstrusk och grå moln - köp en resa till solen på Yahoo! Resor

Software Owner for Oracle8 and Oracle9

Hi all, We have currently a debate ongoing on the Unix side about the issue of having 1 Oracle software owner for both Oracle 8 and 9 versus having a new software owner for 9. What comments you have, w hat might be advantages and disadvantages using one or two users... Thank you in advance, Rgds

Oracle RMAN (OmniBack) Backup Encryption

Hi all, I have a "weird" question. Do you have any experience how to encrypt the backup. Let's say I have following backup method in use: RMAN on UNIX box. I will use online backup and copy the backup set(s) either to the disk or the tape using OmniBack. How I can encrypt the backup sets

Automate an update

Hi all, I need help in order to create a following "mechanism". I have a table where is a column called window_open and it has two values 'Y' and 'N' Now I need to automate the update a single row based on following rules: If time is between 08:00-16:00 the value on that window_open column

Oracle Server / W2K

Hi all, what might be the best configuration for OLTP database if you have following components: DL380 2*1.4ghz, 2GB Mem, 6*16GB 15k Disks... And what is the correct flag for Optimize Performance for Applications or Background Processes... TIA Joshua

_filesystemio_options=setall

Hi all, has anyone checked this, is it worth to try or test... _filesystemio_options=setall rgds JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express

Performance review for

Hi all, I wonder gathering a document template in order to do some db auditing. I was wondering if anyone has a good document or a list of issues or good links what to put into performance review list. Thanks in advance, JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express

lsnrctl -utility, passing password in a command file

Hi all, is there any way how to start password protected listener from certain .bat file. I am using Windows NT and I don't know how to pass a password to lsnrctl -utility when I am doing like this lsnrctl reload PASSWORD. All tips are welcome... Rgds, Kalle

Metilinx -product!

Is anyone using this product, could I please hear your comments and thoughts. Is there other links than this http://www.metilinx.com/default.cfm rgds Joshua _ Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express Se mer på:

Oracle Audit for Failure Logins

Hi all, could someone give me an example how could I set up auditing on for failure logins. Thank you in advance, God Bless innocent people in Iraq and let the Imperialists get out there ASAP. Rgds JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express

Oracle Expert Fails

Hi all, I noticed an interesting error, I tried to use Oracle Expert in order to tune my database but it won't go further after noticing some temporary tables, and actually Expert asked to delete those objects. Is that normal behaviour or a bug. Rgds, JoshuaGå före i kön och få din sajt värderad

Space or Memory Leak

Hi all, In case you face some space or memory leak problems, how you can see the problem on OS side, I mean does it load more CPU utilization or Memory... Rgds, JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express

NLS_COMP=ANSI and NLS_SORT=GENERIC_BASELETTER

Hi, I need to do some sorts with Scandinavian characters and I need to setthese parameters NLS_COMP=ANSI and NLS_SORT=GENERIC_BASELETTER Where do I put these because I am using and application and WebLogic iscalling some programns which are actually using that sorts... Any ideas would be

DB design principles

Hi all, I need gather some principles for good db design. Do you happen to have any or do you good links where I could check some white papers etc... rgds _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the

NLS_LANG settings on MetaFrame

Hi all, I have a following problem. I have a MetaFrame -environment where I need to support to different character sets. Database is UTF8 format. Now I need to support for some users Russian Character Set and some users West European Character set. How I can define in

Oracle 9i 32bit and 64bit on the same server

Hi all, I have a following problem I hope you could help me: I have an UNIX box (Solaris8) where I have installed 9iRel2 64 bit software, also I have created two instances using that 64 bit version. Now we are also having an application which needs 32 bit 9i client software on the same server. The

Listener problem ....

Hi all, I am wondering is there something wrong with my listener settings. I mean when I type LSNRCTL servicesConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test01u)(PORT=1521)))Services Summary...Service "TEST2" has 2 instance(s). Instance "TEST2", status UNKNOWN, has 1 handler(s) for

RMAN with OmniBack on NT

Hi all, do you have good papers or good links where I can read "detailed" information concerning how to setup rman with omniback on nt. I am also very delighted to hear your comments concerning this set-up Rgds and thanks, JoshuaGratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!

Urgent: Trigger problem...

Could someone help me with this. I have a trigger in one table and the trigger should do one unix -command (tclsh). However I am facing following problem... OS return value: the Permission (java.io.FilePermission /usr/local/ActiveTcl/bin/tclsh execute) has not been granted to TEST. The PL/SQL

IMP-00098: Internal Error: impccr2

Hi all, I received quite interesting error during import. I am trying to put the dump from 8.1.6 database to 9i rel2 database on win2k server. The export dump was done with WE8ISO8859P1 character set and the target db is with UTF8 character set... Do you have any idea, or should I contact oracle

Connections with WebLogic (5.1) and Oracle 8.1.7 on Solaris

Hi all, we are facing strange problems with our environment. we are using weblogic and solaris8 with 8.1.7.3. It seems that somehow amount of cumulative connections is getting extremely high and it seems that WL is doing db connection each time user clicks the aplication. Is there any

Index Oracle-l

INDEX ORACLE-L _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Joshua=20Becker?= INET: [EMAIL PROTECTED] Fat City Network Services

Storage Recommendations

Hi all, does anyone know a good site or have good white papers or presentations concerning physical storage recommendation for different size Oracle databases... and also for different platforms (Win2000 and HP-UX and Sun Solaris...) I would be VERY grateful for all information :-) Thank you