RMAN archive log Back up taking long time

2003-03-06 Thread ora ak
We are using rman to backup the 8.1.6 database. Sometime it is noticed that rman is taking huge time to back up some archivelog files . Generally it takes 20 seconds to backup one archivelog , but for some archivelog files it is taking more then 2 hrs . Did any of you noticed this problem before.

RE: ORA-1410 Silliness

2002-12-31 Thread ora ak
Did u do any migration recently . "Koivu, Lisa" [EMAIL PROTECTED] wrote: Well, I don't think that's the issue. I'm issuing bulk inserts and using pl/sql tables in this procedure. That functionality has been in place since February and these errors only started surfacing in the last couple of

Re: ORA-28030: Server encountered problems accessing LDAP directory service

2002-12-31 Thread ora ak
Looks like are trying to resolve service name using LDAP naming . David Mitchell [EMAIL PROTECTED] wrote: I've recently inherited an Oracle 8.1.6 system and was just trying tosetup a database link between two instances. I've granted the "createdatabase link" priv to the user account and can

Re: Versioning the Database !

2002-12-27 Thread ora ak
I generally follow as a practice to keep a variable v_version at package level or any script level . ( i have only packages ) and this v_version is nothing but $header$ in mks . This way I can always run a query to find out object versions in db . This is REALLY helpful specially when code is

Re: SID and DB_NAME

2002-10-25 Thread ora ak
Thanks Rajesh , well explained . I had same idea . that SID is instance indentifier . -oramagic . [EMAIL PROTECTED] wrote: Simply speaking, consider SID to be the name for the various backgroundprocess (DBWR, LGWR, et all) and the memory structures (SGA, PGA). A SIDneeds to be associated with a

oracle apps documentation

2002-10-25 Thread ora ak
can some one point me in right direction to look for oracle applications documentations. I am specially interested in manufacturing and financials . thanks , oramagic Do you Yahoo!? Y! Web Hosting - Let the expert host your web site

RE: oracle apps documentation

2002-10-25 Thread ora ak
menu) - E-business Suite ERP - module - Documentation (there are also other paths to follow to get to the same place). You'll find user guides and most TRMs Alsocheck out AppsNet: http://www.oracle.com/appsnet/content.html -Original Message-----From: ora ak [mailto:[EMAIL PROTECTED]]Sent: Friday,

SID and DB_NAME

2002-10-24 Thread ora ak
I know this novice question for dba's but just wanted to refresh this , what is difference between SID and DATABASE_NAME , why init.ora file shouldhave database name same as SID and in what circumstances SID and DB_NAME can be different . TIA oramagic Do you Yahoo!? Y! Web Hosting - Let the expert

Re: Connections with WebLogic (5.1) and Oracle 8.1.7 on Solaris

2002-10-16 Thread ora ak
I though WL manages connection pool. Better look into WL configurations for connection pooling . Joshua Becker [EMAIL PROTECTED] wrote: 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

Re: Difference - Rebuild and Analyze index

2002-10-16 Thread ora ak
Yes Marul , I think there is a big differenece in them . When you are rebulding the index means you are re-organzing the entries in the index , may be removing the entries for the rows deleted in past and so forth so on. But this doesn't generate any statistics about index. When you analyze index,

RE: Any way to see the currently running SQL in one session.

2002-10-16 Thread ora ak
there is a x$ table which can give u this info I am not able to recall that at the moment . oramagic Paulo Gomes [EMAIL PROTECTED] wrote: u could use top sessions-Original Message-Sent: quarta-feira, 16 de Outubro de 2002 2:28To: Multiple recipients of list ORACLE-LDear ALL,Is there any

Re: How to configure MD5 data encription in Oracle 8i

2002-10-16 Thread ora ak
why not use encryption outside the database and store encrypted string in database . We do it all the time , java application does the encrytion and authentication , db just stores the encrypted string . Just an idea . I dont the answer of your original question :) Oramagic Suman S K [EMAIL