Re: SQL Query (Sorting)

select decode(substr(col1,1,1),'+',substr(col1,2,1)||'+','-',substr(col1,2,1)||'-', col1) from test order by to_number(decode(substr(col1,1,1),'+',substr(col1,2,1),'-',substr(col1,2,1), col1)) / This will do the thing Regards Arun Aggarwal Aithent Technologies (P) Ltd. [EMAIL PROTECTED] +91-11-

RE: TABLE CACHE

It is based in the amount of blocks that the table consumes. For this you need to query the view dba_segments. Then with that value go and add it to the parameter cache_size_threshold. Regards. > -Mensaje original- > De: mala singh [SMTP:[EMAIL PROTECTED]] > Enviado el: miércoles 7 d

Insert data into LOB column

Hi! I am new to working with LOBs. I want to insert data (through SQL or PL/SQL) into a table that looks like this: column1 varchar2(100) column2 BLOB column3 number How can I insert data into that table directly? insert into table (column1, colum2, column3) values ('sample text', ?,

Re: SQL Query (Sorting)

Use decode function in the Order by clause, if the possible values of the column are limited. Message History Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Hi, I have a table with a fiel

SQL Query (Sorting)

BDY.RTF

Re: steve adams' site

http://www.ixora.com.au/home.htm Oracle8i Internal Services, O'Reilly - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, February 07, 2001 8:35 PM > Hello, > > Can any one tell me steve adams web site and also his book name? > > rgds, > >

RE: steve adams' site

Hi Raja site - http://www.ixora.com.au/home.htm book - http://www.ixora.com.au/resources/index.htm With regards Alex Afanassiev Oracle DBA, Internet.Operations/iFactory/Area63 Tel:(03) 8 661 20 61 Fax:(03) 9 650 36 74 > -Original Message- > From: Viraj Luthra [SMTP:[EMAIL PROT

A Solaris question on memory usage

Good day, I am looking at how Oracle and other applications running on a Solaris 2.6 server are using memory. The server has 512 MB of RAM. I issued the "/usr/proc/bin/pmap $pid" command to display memory usage info and used the figure from the "total KB" line of the output (the last line of the

RE: Unix SysAdmin Book??

Also, check out bestbookbuys.com for pricing comparison. --- David Barbour <[EMAIL PROTECTED]> wrote: > O'Reilly - My bible for basics cross-platform > Essential System > Administration > O'Reilly - Great intro to scripting Learning the > Korn > Shell > > Sun Specific - Sun Performance and

Re: Extent Allocation

Hi, Oracle allocates blocks to an extent in multiple of 5. -- Neena -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: TIL-TEC INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re:RE: final frontier / RE: RE: RE: OT NT2K vs Unix.

Dick, I'll ask for the details. Might take a while since there is a river next to the campus, and they might want to do extensive "proof of concept" testing prior to releasing internal specifications to the general public. I'll volunteer to bring my kayak for the testing, but it will have to

steve adams' site

Hello, Can any one tell me steve adams web site and also his book name? rgds, raja Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTEC

Re:

to port or starboard? [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] On 7 Feb 2001, at 14:41, Travis Scrivner wrote: > list ... > --

RE:

And more lists David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 07, 2001 4:29 PM To: Multiple recipients of list ORACLE-L lists -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Travis Scr

RE: ORA-12514 TNS names could not resolve service name

Thanks for the tip - we just installed 8.1.6 on NT this afternoon and had the problem. Your solution did the trick!!! Laura H. Myers AT&T Solutions-ITS [EMAIL PROTECTED] Phone: (336) 698-2375 Fax: (336) 698-2385 > -- > From: Ruiz, Mary A (CAP, CDI)[SMTP:[EMAIL PROTECTED]

Re: enqueue waits from statspack report

CI - Cross-instance Call Invocatiom UL - User-defined locks [EMAIL PROTECTED] wrote: > > The following is from a Statspack report from an 8.0.5 database on a Sun > server during a load test. > Can anyone explain what type of enqueues these are and where I can find some > doco on them? I did loo

Re: NESTED MINUS?

Thanks Elliott, Jack and Krishna. Well I don't know... after I received your responses I tried in again and it worked!!! Some missing comma or something. Elliot, this was only an example query, the really query is a little trickier. I am using the minus because using the "not in" (my first choic

enqueue waits from statspack report

The following is from a Statspack report from an 8.0.5 database on a Sun server during a load test. Can anyone explain what type of enqueues these are and where I can find some doco on them? I did look on MetaLink and Steve Adams' site. Thanks. Enqueue activity for DB Enqueue

No Subject

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

USE_SHARED_SOCKET on 8.1.5 & 8.1.6

I'm trying to activate port sharing under Win NT 4.0 SP 5. I've set the USE_SHARED_SOCKET to TRUE in Control Panel, System environment. Connected to database from a client. Stopped the listener on the server. But my client connection didn't terminate. I think my connection should have termi

No Subject

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

RE: re: cron script (fwd)

You could also check to see if your crontab file exists under /usr/spool/cron/crontabs directory -- Deepak --- "Molina, Gerardo" <[EMAIL PROTECTED]> wrote: > Try: > > ps -ef |grep cron > > you should see: > > /usr/sbin/cron > > as one of the entries. If not, then your cron > daemon is not

BSM and Legato

Hello Gurus I am asking a question which is little off topic, please forgive me. I am in the process of upgrading legato networker 5.1 to 6.0.1. I am now running 5.1 with BSM for oracle on my HPUX box running 10.20 OS. My question is in the process of upgrading networker , do I have to remove and

RE: 8.1.7 install

Isn't original question ask to select a path, where to instal java as an independent product? This location will be used to setup Oracle's java Be careful, don't overwrite yours. Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, February 07, 2001 11:31 AM To: Multiple recipi

RE: NESTED MINUS?

The syntax is only OK without the "table"'s in it. I think you might be seeing some extra underscores where they aren't. If I run the sql exactly as it is in this message, I get the same error message stated here. Here is the output: 1 select * from table A where A.f1 in ( 2

RE: Extent allocation

Title: Extent allocation It is a big clue.  Oracle rounds to multiples of 5 extents to prevent the existence of a free extent of fewer than 5 blocks, which is unlikely to be usable.   Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile)

RE: Oracle on Unix

I did this about 4 months ago. Oracle has probably tired of geting the irate phone calls on switching CD's. ;) -Original Message- Sent: Wednesday, February 07, 2001 3:35 PM To: Multiple recipients of list ORACLE-L FYI, the box of 817 CDs I got included a sheet of paper warning you to c

RE: NESTED MINUS?

Mike, It's not only possible, but I do it all the time. In fact I just did a query against our database that had a Union nested within a Minus nested within an Intersect - not often I get to use all three in the same statement! This particular Select hit several tables of over a million rows ea

RE: NESTED MINUS?

Try taking out the "table"'s . This is illegal syntax. select * from A where A.f1 in ( select f1 from A minus select f1 from B); The sql above is also very inefficient. You don't need to do the minus. Here is the correct syntax: select * from A where A.f1

Re: TABLE CACHE

Hi select blocks from dba_segments where segment_name ='' shows the size of your table. oli On Wednesday 07 February 2001 19:54, [EMAIL PROTECTED] wrote: > Hi DBAs > I have one large table.I want to keep it into memory thru > alter table cache; > Is there any computation formula how much ram

RE: oracle on win2k

the machine is not in the network. --- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > did it give anymore detail? Is the machine on a > network? > > -Original Message- > aradhyula > Sent: Wednesday, February 07, 2001 2:26 PM > To: Multiple recipients of list ORACLE-L > > > i installed 8.

RE: oracle on win2k

timing mismatch ... and status goes into starting --- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > did it give anymore detail? Is the machine on a > network? > > -Original Message- > aradhyula > Sent: Wednesday, February 07, 2001 2:26 PM > To: Multiple recipients of list ORACLE-L > >

Extent allocation

Title: Extent allocation Hi - I am confused now about how oracle actually determines the size an extent should be.  I have db_block_size set at 8192 and have defined a tablespace (and tables) at initial and next extents of 128K.  When I do a show parameter db_file_multiblock_read_count it sa

RE: Oracle on Unix

FYI, the box of 817 CDs I got included a sheet of paper warning you to cd out of the cdrom directory before trying to switch CDs. Jim >>> [EMAIL PROTECTED] 02/07/01 03:45PM >>> Yes, The java installer is the same look and feel across all platforms. With 8.1.7 you have 2 CD's on some systems.

iFS1.1: penguin gets slaughtered

Hi, I've played a little bit with ifs1.1. O.K. the penguin is a little bit lightweighted for this task (EE8.1.7, SuSE7.0, kernel 2.4.1, 512 MB RAM, 600 MHz PIII) They say that's the minimal configuration for iFS (2 users, 2 protocols) but anyway I only try it out. Now the machine is in polling

RE: TABLE CACHE

It will take the same amount of memory that it currently is taking in disk space. You will need to increase your cache until it is at least as large as the number of blocks that are in the table. If you are running Oracle 8, then there is a new feature that allows you to assign specific pools to

RE: Bstat/Estat File -> Table?

I would put it the other way around. If you need that information in tables (which I agree is much better than in the report.txt file) edit the utlestat and put the result in a table, or at least create a file in a loadable format (series of inserts or file suitable for Sql*Loader), and not go to

Re:Oracle on Unix

Same screen on HP-UX. Only problem is that you HAVE to have an Xterminal or emulator, damn it. Dick Goulet Reply Separator Author: "Nosie" <[EMAIL PROTECTED]> Date: 2/7/2001 12:00 PM Dear All, I've been working with Oracle on NT for years, never h

8.1.7 DB and auto registration with Listener

Hello All, While using the default port number and default listener name with Oracle 8.1.7, the automatic service registration takes place when the database is started after starting the 8.1.7 Listener. But if the listener is bounced then the 8.1.7 database does not auto register. However, other

Re: 8.1.7 install

Hi, I was also confused by the installer too -Oracle ships a IBM 1.1.8 jre on the disk. But I found a jdf 1.2.2 under /usr/local and have this used instead. oli On Wednesday 07 February 2001 15:46, [EMAIL PROTECTED] wrote: > 8.1.7 install prompts for location of a JDK and then falls over when

RE: Database Startup Trigger is not pinning all packages

In order to get the startup trigger to fire correctly, you need to grant "EXECUTE ANY PROCEDURE" to the SYS user. Startup and login triggers fire before any role grants take place, so the privileges have to be granted explicitly. > -Original Message- > From: Mohammad Rafiq [SMTP:[EMAIL P

RE: Oracle on Unix

Yes, The java installer is the same look and feel across all platforms. With 8.1.7 you have 2 CD's on some systems. Therefore in order to switch CD's mid install you need to issue the runInstaller command from a directory other than the CD-ROM. Such as: $ cd /home/oracle $ /cdro

Re:Vendor Package Implementation Strategy

Lisa, I assume your meaning is NT vs. Unix not NT vs Oracle. But you do bring a point. There are up and down sides all over the place. Most vendors would prefer that you handle their application as needing a separate instance & server. Well that can cost since you need an Oracle license f

NESTED MINUS?

Hi all, can you use the minus operator in nested sql eg select * from table A where A.f1 in ( select f1 from table A minus select f1 from table B); I'm getting a "missing right parenthesis" error, so I think it may not be possible! Thanks Mike -- Please see t

ora-12547: TNS: lost contact

Oracle 8.1.5, Solaris. The "oracle" user has no trouble connecting to the local database via the bequeath adapter. However, another user, using the same .profile as the oracle user, gets: SQL*Plus: Release 8.1.5.0.0 - Production on Wed Feb 7 15:30:21 2001 (c) Copyright 1999 Oracle Corporati

Bstat/Estat File -> Table?

Hi,   Just curious if anyone has a script(s) that will take the contents of the report.txt file and turn it into loadable files or something along those lines. I know about 'statspack' but many companies are hesitant to permit the creation of  tables for storing statistics on their productio

Oracle on Unix

Dear All, I've been working with Oracle on NT for years, never had the one on unix. Now, I am trying to use the one on Linux. I see that the installation screen is just the same as on NT. Is this also the same with other unix platform such as AIX, Solaris, HP-UX, etc? TIA Nosie Think

RE: oracle on win2k

did it give anymore detail? Is the machine on a network? -Original Message- aradhyula Sent: Wednesday, February 07, 2001 2:26 PM To: Multiple recipients of list ORACLE-L i installed 8.1.6 on windows 2000 it installed succesfully. when i tried to start the service it gave the ERROR - 10

Oracle on Unix

Dear All, I've been working with Oracle on NT for years, never had the one on unix. Now, I am trying to use the one on Linux. I see that the installation screen is just the same as on NT. Is this also the same with other unix platform such as AIX, Solaris, HP-UX, etc? TIA Nosie Think

Oracle on Unix

Dear All, I've been working with Oracle on NT for years, never had the one on unix. Now, I am trying to use the one on Linux. I see that the installation screen is just the same as on NT. Is this also the same with other unix platform such as AIX, Solaris, HP-UX, etc? TIA Nosie Think

RE: RE: controlfile schema global enqueue lock

Hi Joan, Please ignore all lock types other than ST and CF. Please capture all sessions. It is important to see which session is holding the CF or ST lock when others are waiting. Sid 111 has had a TX lock for 1007 seconds, and has been waiting for the CF enqueue for 3 seconds - this is because

Oracle on Unix

Dear All, I've been working with Oracle on NT for years, never had the one on unix. Now, I am trying to use the one on Linux. I see that the installation screen is just the same as on NT. Is this also the same with other unix platform such as AIX, Solaris, HP-UX, etc? TIA Nosie Think

Oracle on Unix

Dear All, I've been working with Oracle on NT for years, never had the one on unix. Now, I am trying to use the one on Linux. I see that the installation screen is just the same as on NT. Is this also the same with other unix platform such as AIX, Solaris, HP-UX, etc? TIA Nosie Think

RE: Vendor Package Implementation Strategy

Lisa, The last company I was at had up to 4 different versions of Oracle on the same server. We had 7.3.4 for one package, 8.0.6 for another, 8.1.5 for another and were doing development on 8.1.6 databases. There were a total of 3 development servers with, at one point in time, 30 databases.

RE: How to use Export Transportable Tablespaces

This process was repeated monthly. So, all references in the target database were dropped each time the process was performed. >>> [EMAIL PROTECTED] 02/07/01 11:56AM >>> Thanks a whole bunch Tim, but one final question. Why did you drop the tablespaces "; echo ; exit 1; fi # # The table

ORA-12547: TNS:lost contact at execution of svrmgrl/sqlplus

Hi all, We are running Oracle 8.1.5 on HP-UX 11.0. Recently we started getting an error 'ORA-12547: TNS:lost contact' whenever trying to connect to svrmgrl. No upgrades on the server, it was working fine before. I searched the metalink and tried everything (relinking). The listener starts/stop

Re: Vendor Package Implementation Strategy

Lisa, We have just been upgrading the majority of our applications that run on Oracle from 7.3.4 to 8.1.5. Some of the apps do not run on 8.1.5 or are not certified. Our solution has been to leave some apps where they are on 7.3.4, have some at 8.0.4 and some at 8.1.5. In other words, we have mu

RE: Crontab ,HELP!!!

I use the following method to execute the profile so environment variables are all set just like when you manually run the script on the command line.   00 01 * * * ksh -c ". $HOME/.profile; /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup"   Richard Ji -Original Message-From: [EM

Re: Database Startup Trigger is not pinning all packages

Why do you want to pin through trigger. Put it into sql file and run it as @file_name at startup. For example: ORACLE_SID=OPRO4; export ORACLE_SID . oraenv svrmgrl < Date: Wed, 07 Feb 2001 08:50:30 -0800 Greetings, I have a database startup trigger which is created from the sys account. The tri

Re: Sql Tuning help

Instead of customer_id in...try where exists (select 'x' from customers where sb_bets.customer_id = customers.customer_id and sb_bets.customer_id and LICENSEE_ID=6130) >>> [EMAIL PROTECTED] 02/07/01 08:30AM >>> I have been having some problems with this statement SELECT to_char(NVL(SUM(bet_amo

Re: Database Startup Trigger is not pinning all packages

Did you use 'dbms_shared_pool.keep' package to ping your objects? and did you include schema name with the object name. Below is one example I am using to keep objects in the shared poll immediately after database startup. execute dbms_shared_pool.keep ('SWBAPPS.SWSP_TULEAD_PKG'); Eveleen

RE: Crontab ,HELP!!!

My god, I almost had a cow when I came in this morning. All my mail that has cron in it goes to its own folder as I have all oracle server mail routed to my exchange mail. I thought I was having system problems. -Original Message- Sent: Tuesday, February 06, 2001 8:35 PM To: Multiple

RE: RE: controlfile schema global enqueue lock

Hi Steve, I still couldn't figure out why we have cf enqueue lock. As you suggest, I run your script repeatedly to see how long the problem persists. All the cf lock associated locks are tx and tm. Here I choose 4 sid to run. I didn't find any st lock, but we do have ts and MR lock. RESOURCE

RE: Sql Tuning help

Try joining the 2 tables as below. I think the IN will do a FTS always. Correct me if I'm wrong. Rick SELECT to_char(NVL(SUM(a.bet_amount),0)) FROM sb_bets a, customer b WHERE a.processed_DATE >= add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19-1) AND a.processed_DATE < add_months(T

oracle on win2k

i installed 8.1.6 on windows 2000 it installed succesfully. when i tried to start the service it gave the ERROR - 1053 from the windows admin Servives, where is the problem __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices

RE: re: cron script (fwd)

Try: ps -ef |grep cron you should see: /usr/sbin/cron as one of the entries. If not, then your cron daemon is not running. If it is, then it may be the syntax of your crontab entry. Try: crontab -l > cron.txt Post your cron.txt to the list and we'll have a look. HTH Gerardo -Origina

Re: NOT COMPLETE LOG

Hello Waleed. Set the follwoing parameters. - LOG_CHECKPOINT_INTERVAL >= the number of OS blocks identical to the redo log file size. It starts a checkpoint only on each switched log file. - LOG_CHECKPOINT_TIMEOUT = 0. This disables the checkpointing based on time interval. After these two

TABLE CACHE

Hi DBAs I have one large table.I want to keep it into memory thru alter table cache; Is there any computation formula how much ram this table takes. Please help me.Thanks in advance. Regards -Mala _ Get Your Private, Free E-

RE: NT/8.1.6/XML Parser not loading.

Argh. I knew I shouldn't have worked that late last night. I could have sworn there was nothing in Metalink, but there is. Apparently, you have to run a missing step... $ORACLE_HOME/javavm/init_security.sql ...and then it works. Sorry for the bother. -Original Message- Sent: Wedne

RE: Sql Tuning help

Try turning the subquery into a join like this. Also make sure you've got sufficient hash_area_size to do a hash join instead of a sort/merge join. 20m should be plenty. If you have to, put a use_hash hint on the query to force it to a hash join. SELECT  to_char(NVL(SUM(bet_amount),0))FROM   sb_bet

RE: NOT COMPLETE LOG

This note is from MetaLink Rick CHECKPOINT NOT COMPLETE === At times you may see "checkpoint not complete" messages in the alert log as follows: Thread 1 advanced to log sequence 248 Current log# 2 seq# 248 mem# 0: /prod1/oradata/logs/redologs02.log Threa

Re: NOT COMPLETE LOG

1-Your log files are small. 2-If message is coming constantly, then you have to increase size of log files. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 07 Feb 2001 05:00:53 -0800 MY DB 8.1.6 ON 3 SERVERS WORK WITH OAS DURIN

Re: problem displaying umlaut character

Hi Gary and all,   Thank you very much for the replies. Setting the environment variable NLS_LANG=AMERICAN_AMERICA.UTF8 solved the problem.   I'm still a little confused as to how all this NLS stuff works, though. In the database, we had:   nls_language    string  AMERIC

Re: Crontab ,HELP!!!

 The script probably needs to set up the oracle environment variables before it will work. Try this. 1) In the oraenv script that's either in /opt/bin or /usr/local/bin depending on your platform, look for the comment that says "Install any custom code here" and insert right after it the following

NT/8.1.6/XML Parser not loading.

Hello all, I am attempting to load the XML Parser into an Oracle 8.1.6 database on NT. My basic command is... loadjava -user scott/tiger -r -v xmlparserv2.jar and I am getting back a series of... ORA-29545: badly formed class: User has attempted to load a class(oracle.xmluser), loadclassInPac

RE: How to use Export Transportable Tablespaces

Thanks a whole bunch Tim, but one final question. Why did you drop the tablespaces "; echo ; exit 1; fi # # The tablespaces should always be transported from Stage to Cars databases. # if [ `echo $1|grep stage >/tmp/log 2>/tmp/err; echo $?` -eq 1 ] || [ `echo $2|grep cars >/tmp/log 2>/t

Vendor Package Implementation Strategy

Title: Vendor Package Implementation Strategy Hi everyone - I posted this some time ago and didn't really get much response, so I'm trying again.  For those of you that are implementing multiple application packages, how to you determine how many Oracle instances and servers to use?  For exa

RE: Sql Tuning help

Try one of these variations SELECT TO_CHAR(NVL(SUM(sb.bet_amount),0)) FROM sb_betssb ,customers c WHERE sb.processed_date >= ADD_MONTHS(TO_DATE('07011999 00','MMDD HH24MISS'),19-1) AND sb.processed_date < add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19) AND s

RE: RMAN

Title: RE: RMAN That's my dilemma - I would have to install both .. but I have not heard anything good about version 8.1.5.  I don't want to install it and have to deal with all kinds of issues. Does anyone know - is RMAN always going to be this way (that you need a catalog for each speci

RE: 8.1.7 install

Does oracle user have permissions to write into /opt/java ? -Original Message- Sent: Wednesday, February 07, 2001 5:36 AM To: Multiple recipients of list ORACLE-L 8.1.7 install prompts for location of a JDK and then falls over when I use the default /opt/java Platform is AIX 4.3.3 Wha

RE: NOT COMPLETE LOG

Implies that Oracle has to switch the current redo but it hasn't accomplished a checkpoint that it's been working on. It is a warning that denotes performance problems. You should increase the size of your redo logs. Regards. > -Mensaje original- > De: Waleed Haggagy ( Nile Networks )

RE: Sql Tuning help

Here's some thoughts.   I don't know if between is faster, but it might be, and won't a straight join do the same as your subquery?   SELECT   to_char(NVL(SUM(bet_amount),0)) FROM   sb_bets WHERE   processed_DATE between add_months(    .) and add_months(   ..) AND   c

RE: V$log Status

Hi Ray, There are two different fields in v$log ARCHIVED - tells us if the log is archived or not STATUS - tells us status of data in the log - CURRENT - LGWR is currently writing this log - ACTIVE - the transactions from this log aren't written to the datafil

OEM Management Server

Hey guys, I have a quick question about the management server service: Oracle 8.1.6 R2 Win2K box. I have just installed OEM 2.1 on my machine, and when trying to start the management server I get the following error: Could not start the OracleOraHome81ManagementServer service on Local C

RE: LMT's Question

  "Kirsh, Gary" <[EMAIL PROTECTED]> wrote: Terry,I've seem LMT's used in standby db's without a problem. As a matter offact, if you ever want to use the standby in read-only mode, the temptablespace needs to be a LMT, otherwise any query resulting in a sort todisk will fail.Gary KirshNext Extent

Re:RE: RE: RE: OT NT2K vs Unix.

They're suppose to be in the vendors area of the upcoming IOUG-A, which I hope to get to. Wonder if they can do wireless networking from the middle of the lake? Dick Goulet Reply Separator Author: Suhen Pather <[EMAIL PROTECTED]> Date: 2/6/2001 1:47

Re:RE: STOMACH WRENCHINGLY OFFTOPIC RE: RE: RE: OT NT2K vs

Okay, Someone pass the 40 ft pole!! Reply Separator Author: "Kevin Kostyszyn" <[EMAIL PROTECTED]> Date: 2/6/2001 1:56 PM RE: RE: RE: OT NT2K vs Unix.i wasn't gonna say it, I knew someone would and it wasn't me...whoo h -Original Message

RE: recovery catalog creation

Hi, You dont have "database" in your tnsnames.ora or whatever name service you use. Sure, sqlplus user/user@database will give you the same. You need to add this entry to your service list on this machine, for exmple into tnsnames.ora Vadim Gorbounov Oracle DBA ---

Database Startup Trigger is not pinning all packages

Greetings, I have a database startup trigger which is created from the sys account. The trigger is only designed to pin some packages in the shared pool. However, the trigger is only pinning the packages that belong to the sys account. I am getting the following error in the alert log file when

RE: Pl/SQL Dynamic SQL questions

Susan, Dynamic SQL can get pretty interesting, depending on the values of your programmer defined records. Obviously your code compiles, but when you add the variable, funny things can happen. When you break out of the routine, what line is showing as being the hangup? If it's your bigSQL, try

RE: STARTUP Force

One thing I would say Neena - ONLY use SHUTDOWN ABORT as an absolute LAST resort!! If you are shuting down the database normally, on 8, first do a SHUTDOWN TRANSACTIONAL, if you need to close the database quickly, try a SHUTDOWN IMMEDIATE, wait for 5 or so minutes, and if all else fails ONLY THEN

Detail steps for transportable tablespace

Hi, Steps for trasportable tablespaces are : 1. Make tabblespace read only. 2. Export metadata from scorce 3. Copy data files to target system 4. Trasfer export file 5. Import metadata into target 6. If necessary alter the tablespace to read write For

RE: Sql Tuning help

Matt, have you tried replacing the IN statement with an EXISTS statement? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 07, 2001 8:31 AMTo: Multiple recipients of list ORACLE-LSubject: Sql Tuning help I have been having

Re: recovery catalog creation

Psycharis, Do you have the database defined in your tnsnames.ora file? Can you connect via sql*net to this database shown behind the @ symbol? We get this error when we don't have our ORACLE_HOME set properly. We have multiple versions of Oracle on the same Unix box. Cherie Psycharis Nekta

RE: RE: STOMACH WRENCHINGLY OFFTOPIC RE: RE: RE: OT NT2K vs

I think I will add stomach to my e-mail exclude list. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 10:11 AM To: Multiple recipien

8.1.7 install

8.1.7 install prompts for location of a JDK and then falls over when I use the default /opt/java Platform is AIX 4.3.3 What is the pathor do I need to install a JDK? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fa

Sql Tuning help

I have been having some problems with this statement SELECT to_char(NVL(SUM(bet_amount),0))FROM sb_betsWHERE processed_DATE >= add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19-1) AND processed_DATE < add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19) AND customer

Re: RMAN

You have to use a version of rman which is at least at the level of the hightest level database in the catalog. E.g., if you have 8.1.7 and 8.0.5 put the rman catalog in at 8.1.7 database. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tues

NOT COMPLETE LOG

MY DB 8.1.6 ON 3 SERVERS WORK WITH OAS DURING FOLLOW UP MY ALERT LOG FOUND LINES 'CHECKPOINT NOT COMPLETE' 'Thread 1 cannot allocate new log, sequence 609'

HELP! Re: Dynamic SQL- Issue a connect stmt.

Could anybody think of any other way to open a session from within a procedure, by accepting userid and password from the user. Sarah, thanks very much trying. Radhika. >From: Sarah Satterthwaite <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAI

  1   2   >