V$SESSION with no osuser and no username

Hi all, I'm using Sun Solaris 7 with Sun Clustering cluster 2.2 I have 4 strange users connected in this machine Oracle 8.1.6.0.0 (Dedicated) Characteristic of unknown users (from v$session) : - 4 of them connected without USERNAME, OSUSER, PROGRAM, TERMINAL, MACHINE (they are NULLl) -

RE: TABLESPACE PCTINCREASE?

This may be true but if a uniform extent size policy (or very close to it) is adopted (or enforced with lmt's) then there is no need to coalesce anything at all - even if chunks of free space are contiguous. hth connor --- Whittle Jerome Contr NCI [EMAIL PROTECTED] wrote: The biggest problem

Re: JDBC errors?

Title: JDBC errors? I am getting weird results while trying to connect via jdbc to an Oracle 817 db on Windows 2000. I can connect via ODBC, but not JDBC, any ideas? is the weird result accompanied by an error message?

Unix permissions

Since we use utl_file to read/write files from our application directories(which are not owned by oracle), we need to set the permissions on these directories so that Oracle has permission to read and write to them. However we run into problems because Systems Admin guys do not like : 1.

RE: JDBC errors?

Title: JDBC errors? Sorry, the errormessage is the following: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)

Re: V$SESSION with no osuser and no username

Sinard Xing wrote: Hi all, I'm using Sun Solaris 7 with Sun Clustering cluster 2.2 I have 4 strange users connected in this machine Oracle 8.1.6.0.0 (Dedicated) Characteristic of unknown users (from v$session) : - 4 of them connected without USERNAME, OSUSER, PROGRAM, TERMINAL,

stopiing write to listener.log

Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu

Stored Procedures

Well, I finally got permissions to use stored procedures in one of our projects. Problem is, I'm not all that butch when it comes to SP's, so, the question is. Do any of you have any links to good tutorials that shows how to best utilize them? Would like to see some examples on what you can do

Scrolling Sideways in SQL*Plus

Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to make it usable 8.1.6 8.1.7 Client on W2K Anybody??? TIA Jack

RE: Data Retrieval Tool

Hello Dennis We bought PlSqlDeveloper. The tool show you a list of the tables. Right click on a table and you get a menu that let you (among other things) query and update the data. If I remember correctly it cost 750$ for 10 user license. Go to http://www.allroundautomations.com . Yechiel

RE: Scrolling Sideways in SQL*Plus

Change the buffer width in the environment panel. That should do it. Cheers, Kev. -Original Message- Sent: 07 February 2002 11:08 To: Multiple recipients of list ORACLE-L Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use

Re: Oracle 8i docs

Sathish , look at http://tahiti.oracle.com Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prem J Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

RE: Ora

Thanks All Found it. The weird thing is that it was the TEMP tablespace and I have hash_multiblock_io_count to zero (0). So why am I getting this error? Increasing the extent size to 5MB solved the problem. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original

RE: stopiing write to listener.log

Lee, I really don't think that's what he was after. However he does ask an Alice (IWL) and Cheshire cat question. Although yes I did resist the temptation to reply with such flair. Peter -Message d'origine-De: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7

RE: question on EXPLAIN_PLAN

Hello Kevin you wrote: And the table and index is analyzed at same way. What way? If you use estimate you can get wrong statistics. Try to do full analysis. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: kevin wang [SMTP:[EMAIL PROTECTED]] Sent:

[Fwd: Re: STATSPACK impact?]

To get resonable results from the reports, your timing interval should be around 10 to 30 minutes. As running statspack collection every that often is likely to produce far too much data than you want to have space for, I always recommend running statspack collection in a system like this

Re: stopiing write to listener.log

Shibu , IF you type LSNRCTL HELP YOU WILL SEE THE SET OPTION THEN TYPE HELP SET you will see the log_status action .. type show log_status . and be sure that it is ON. Then try to make it OFF with the SET command ... Bunyamin - Original Message - From: [EMAIL

RE: stopiing write to listener.log

Stop the listener !! -Original Message-From: Shibu [mailto:[EMAIL PROTECTED]]Sent: 07 February 2002 10:38To: Multiple recipients of list ORACLE-LSubject: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu

Re: Scrolling Sideways in SQL*Plus

I also have sometimes this weird situation I usually set buffer width 1000 and linesize also 1000 Sometimes I cannot use scrollbar to the right but the cure for that is simple if I change the dimensions of my SQL/Plus window then all is just fine Not too often, but anyway I don't know

Re: stopiing write to listener.log

Shibu, To stop listener from writing into listener.log put the following into listener configuration file listener.ora: LOGGING_LISTENER = OFF then stop/start listener to use modified configuration file. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From:

RE: svrmgrl

Hello Rachel All Tested it and it worked. it worked so well that I could access any table (tested some). ? Where is the security? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Rachel Carmichael

Re: stopiing write to listener.log

Hi peter I have thousands of connection in my dband listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message -

Re: MC/Serviceguard vs Sun Clusters

Stay with HP Serviceguard! From experience, I rank HA solutions in this order: 1. HP serviceguard - easy and it works. 2. IBM HACMP - do it the way IBM wants it and it works. 3. Sun Cluster - get a high paid consultant to set it up and have them come back to change it :) Better yet, go with

Re: Unix permissions

I typically set utl_file to /tmp/oracle/$ORACLE_SID. The /tmp dir (setuid bit set) allows oracle to write and anyone to read. It protects users from overwriting Oracle files. Nothing for the sysadmin to change :) Gene [EMAIL PROTECTED] 02/07/02 04:53AM Since we use utl_file to read/write

RE: Limiting RMAN backup size

I have used SET LIMIT CHANNEL to limit the size of the backup pieces. I haven't used SETSIZE, which limits the total byte size of a backup set. However, I don't see how this will help, since a backup command can create many backup sets. I face the same dilema. It looks like another example

Re: svrmgrl

It's an equivalent of 'internal' login, that's why you can access any table. On NT you'll be able to do : 'connect / as sysdba', only if you are logged into NT as a member of ORA_DBA group. That's as much security as you can get. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message

RE: question on EXPLAIN_PLAN

Kevin, Have you tried it with autotrace on to see the number of reads etc? Iain -Original Message- Sent: Wednesday, February 06, 2002 10:09 PM To: Multiple recipients of list ORACLE-L Yes, Mike, I analyzed the table and PK index on the two databases at the same way, it seems that

Re[2]: stopiing write to listener.log

Shibu, To get the listener to stop logging immediately without having to bounce it: lsnrctl set log_status = off exit Now to get that to stay forever set logging_listener = off in the listener.ora. Now delete the log file your done. For normal day to day operations the log file

Re:MC/Serviceguard vs Sun Clusters

Rama, We did the MC/ServiceGuard thing some years ago. Worked well, after our SA rebuilt the servers from ground 0. Adding it on to an existing server is ok, but somewhat unstable. One item to be VERY careful of. The heartbeat cable, in our case a ethernet thin line, needs to be on a

RE: svrmgrl

Thanks Igor Checked and the NT user is indeed in ORA_DBA. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Igor Neyman [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 3:38 PM To: Multiple recipients of list ORACLE-L Subject: Re:

RE: Migration utility from 7.3.4 to 9i ??

Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration

RE: question on EXPLAIN_PLAN

I'm sure this is too simple but its not excessive extents is it? select count(*) from dba_extents where segment_name = 'PK_INDEX_NAME'; select count(*) from dba_extents where segment_name = 'TABLE_NAME'; -Original Message- Sent: Thursday, February 07, 2002 8:38 AM To: Multiple

RE: Re[2]: stopiing write to listener.log

erm. to Shibu. I forgot the smiley. It was only a joke !!! -Original Message- Sent: 07 February 2002 13:56 To: Multiple recipients of list ORACLE-L Shibu, To get the listener to stop logging immediately without having to bounce it: lsnrctl set log_status = off exit Now

Re: Scrolling Sideways in SQL*Plus

set linesize larger --- [EMAIL PROTECTED] wrote: Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to

SQL Insert question

Hi , this is puzzling me.. i have following table table name = Sierras. Columns = regno, platfrom, cost , licence_ref renewal_data i split this table up into 2: 1. Softwares cols= id, regno, platfrom, 2. Licences id, cost , licence_ref, renewal_data, i have a third table, a link table

Re:RE: Migration utility from 7.3.4 to 9i ??

Kirti, I believe the question is: is there any way to migrate from 7.3.4 directly to 9i. Assuming that to be correct the answer obviously is no, unless you want to take the export/import route. The reason is that in migrating from 7x to 8x the rowid's in the database went through a major

RE: svrmgrl

You also need to be an administrator. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Igor Neyman [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 3:38 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl It's an

Re: Scrolling Sideways in SQL*Plus

Hi, I set the linesize larger and the buffer etc.. I do get the scrollbar and there is data to the right of the screen, but the scrollbar just won't work HTH Jack Rachel Carmichael [EMAIL PROTECTED]@fatcity.com on 07-02-2002 15:08:33 Please respond to [EMAIL PROTECTED] Sent by:

RE: RE: Migration utility from 7.3.4 to 9i ??

Hi Dick, According to the 9i Migration Utility Guide, the Mig Utility that comes with 9i will migrate 7.3.x database to 9i directly. Unfortunately we had no 7.3.4 database to migrate to 9.0.1. So I have not had a chance to test it myself. We migrated several 7.3.x database to 8.x using Mig Util

RE: SQL Insert question

You could create a view across these two tables to give you the info you need. Cheers, Kev. -Original Message- Sent: 07 February 2002 14:29 To: Multiple recipients of list ORACLE-L Hi , this is puzzling me.. i have following table table name = Sierras. Columns = regno, platfrom,

Re: MC/Serviceguard vs Sun Clusters

On Thu, Feb 07, 2002 at 06:00:04AM -0800, [EMAIL PROTECTED] wrote: Consequently we abandoned ServiceGuard are going to standby databases instead. Dick Goulet I have been very pleased with standby stability, but find it a little awkward wrt maintenance as availability demands increase. I

RE: Re[2]: stopiing write to listener.log

Nice one, although the pipe still sounds interesting. Peter -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 14:56 À : Multiple recipients of list ORACLE-L Objet : Re[2]: stopiing write to listener.log Shibu, To get the listener

RE: Slightly OT: PVCS Tracker 7.0 Backup Recovery Question

You know, not to cause you to worry but I have had issues with Tracker databases. In one case I could not export fully successfully. I worked with Oracle for about a week to try and get to the cause (I don't think I had their brightest working with me). Finally, Oracle said to rebuild the

RE: svrmgrl

see? security :) --- àãø_éçéàì [EMAIL PROTECTED] wrote: You also need to be an administrator. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Igor Neyman [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 3:38 PM To:

Re: SQL Insert question

[EMAIL PROTECTED] wrote: Hi , this is puzzling me.. i have following table table name = Sierras. Columns = regno, platfrom, cost , licence_ref renewal_data i split this table up into 2: 1. Softwares cols= id, regno, platfrom, 2. Licences id, cost , licence_ref,

Re: RMAN full backup Vs Incremental level 0

You have to have an incremental level 0 in order to restore you database. If you are going to do backups once daily then you should do a level 0 one the first day of your cycle and then incremental backups after that. There are many levels of incremental and you should read about them to find

Re: Instream SQL

#/bin/ksh sqlplus -s / EOF select 'x' from dual; exit; EOF Robert Pegram Oracle DBA --- Smith, Ron L. [EMAIL PROTECTED] wrote: I have a batch script running on Unix and I need to call a short SQL script (3 or 4 lines). Can someone show me the syntax to execute an inline SQL session so

RE: JDBC errors?

Title: JDBC errors? When we had a similar problem it was cause of the JDBC driver that was being used. They had to upgrade from the one we had been using to connect to previous versions of the database. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On

RE: MC/Serviceguard vs Sun Clusters

Actually, the heartbeat has been the biggest pain in the but of ServiceGuard. Its caused 99.99% of the failures. Granted once it was a failed network card. All in all though, I have been pretty happy with ServiceGuard. And ours is dedicated and protected:-) -Original Message- [EMAIL

DLL question

Okay, I can't find where this is documented. What .dll corresponds to ora805.dll in 8.1.6? Better yet, where is that documented? Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

export/import errors

I just did my first export/import and of course I got some errors at the very end of my import log file. My problem is I don't have a clue as to what they are. Below is the last few lines of the import log file About to enable constraints... . importing DIS's objects into DIS . importing

Re: Scrolling Sideways in SQL*Plus

try exiting sql plus and login in again then set the linesize 1000 (e.g.) first before you run anything else [EMAIL PROTECTED]@fatcity.com on 07/02/2002 14:33:40 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

RE: stopiing write to listener.log

Peter, How do you set the 'Log Rotation' ? From command line utility 'lsnrctl' or is there any parameter for listener.ora ? Another thing: How do I track the exact SQLs being sent to the Oracle server ? I remember somebody on this list gave some hints in this direction. I just don't

Remote Compromise in Oracle

The post here yesterday on this topic was underwelming: NGSSoftware Insight Security Research Advisory Name:Oracle Remote Compromise Systems Affected: Oracle 9, 8 Platforms: All Operating Systems Severity: High Risk Vendor URL: http://www.oracle.com/ Author: David Litchfield ([EMAIL

What impacts index build times on partitioned tables?

We drop and recreate many indexes on our large partitioned fact table in our data warehouse nightly. The amount of data in the table increases gradually with time but there aren't huge fluctuations in the amount of data in the partitions from day to day. The problem is that the amount of time

Re: SQL Insert question

Im afraid i cant answer that question Stephane , as i dont have much to do with the design of this DB... thanks for the query... regards IA Stephane Faroult [EMAIL PROTECTED]@fatcity.com on 07/02/2002 14:53:32 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To:

Re: MC/Serviceguard vs Sun Clusters

On Thu, Feb 07, 2002 at 07:18:34AM -0800, Kimberly Smith wrote: Actually, the heartbeat has been the biggest pain in the but of ServiceGuard. butt n. The larger or thicker end of an object: the butt of a rifle. My associates tell me I am an expert in this area...

RE: export/import errors

Quick look in Metalink would suggest that this is a bug, I would report this to Oracle. I think there is a fix to it. Lee -Original Message- Sent: 07 February 2002 15:29 To: Multiple recipients of list ORACLE-L I just did my first export/import and of course I got some errors at the

RE: What impacts index build times on partitioned tables?

I think that it is related to the activity against the DB. Not only there is more load on the DB but access path that use the index can default to full table scan if the index is not available because you are rebuilding it just now. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED]

RE: stopiing write to listener.log

1) lsnrctl stop RENAME %ORACLE_HOME%\NETWORK\LOG\LISTENER.LOG OLD.LOG lsnrctl start 2) see the sample in network\admin\sample. use trace_level=user (IMHO). Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Prakriteswar Santikary

[Q] MS Access to ORACLE migration guide line?

We plan to migrate some of our MS ACCESS database (97/2000) to ORACLE 8.1.7. Can anyone tell me where can I fond migration white paper or guide line? Thanks. _ Get your FREE download of MSN Explorer at

RE: export/import errors

You have packages with status INVALID. Correct them and the errors will go away. Been there. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 5:29 PM To: Multiple recipients of

Re: export/import errors

Dave, Everyone gets these same errors. If you are not using replication then do not worry about these errors. If this is all you got then you are probably good to go. Rick

SP2-0103: Nothing in SQL buffer to run.

Hi Oracle Gurus This might be very silly problem for you gyus, but I am really geting headache. I suppose today my mind is not working in sync. I am attatching the script which i wrote. When I try to execute on sql promp, I get the result like this : SQL @c:\general\ksg\ProcDisp.sql SP2-0103:

Re: Remote Compromise in Oracle

Ray, Yes take a look at http://otn.oracle.com/deploy/security/alerts.htm they have workarounds posted with yesterdays date. ...JIM... [EMAIL PROTECTED] 2/7/02 9:55:18 AM The post here yesterday on this topic was underwelming: NGSSoftware Insight Security Research Advisory Name:Oracle

RE: export/import errors

I just opened a low level TAR on these errors just to make sure my data is ok. Thanks, Dave -Original Message- Sent: Thursday, February 07, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Quick look in Metalink would suggest that this is a bug, I would report this to Oracle. I

RE: MC/Serviceguard vs Sun Clusters

I'll second this. I worked with Sun a few years ago at another place. Here, we're an HP shop with 2 OPS clusters (2 node and 4 node). We finally moved our straggler Compaq cluster to HP a couple of months ago. I'll caveat by saying that we do have a couple of well seasoned SAs and DBAs

RE: What impacts index build times on partitioned tables?

Yechiel, There is no other activity in this warehouse database while the index builds are being done. The users access is shut off, no batch jobs for this database are running, and the nightly data loads have already finished. Thanks, Cherie

RE: SP2-0103: Nothing in SQL buffer to run.

Title: RE: SP2-0103: Nothing in SQL buffer to run. Try : SQL start c:\general\ksg\ProcDisp.sql Rivaldi -Original Message- From: Krishan Gupta [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 10:32 AM To: Multiple recipients of list ORACLE-L Subject: SP2-0103: Nothing

Re: Instream SQL

Try this: sqlplus -s EOF userid/password sql statements here ... ... EOF Venkat Somusetty Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Venkat Somusetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Breakable 9i ?

TechRepublic: www.techrepublic.com BUGS BUST OPEN 'UNBREAKABLE' ORACLE 9i TODAY'S TOP STORY U.K. security researcher David Litchfield is expected to unveil several security flaws in Oracle's flagship 9i database software at the Black Hat Windows Security Briefings conference in New Orleans

RE: deleting a datafile on OPS

It isn't an OPS issue, you can't drop a datafile without dropping the entire tablespace. This has never been possible. -Original Message- Sent: Tuesday, January 29, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Hello list, Oracle 8.1.6.3.0, on HP-UX 11.0, using Oracle

OT: Has anyone installed 9i On Win XP Pro

Title: Message Just wanted to know if anyone has created a database on Win XP Pro using Oracle 9i.Gautam

RE: Unorthodox 8i install/upgrade

I have installed 8.1.7 on a Tru64 5.1 system. I simply copied the CD's into separate directories on our NFS mounts, then logged into the system where I wanted to do the install, found the installer program, and ran it. I don't remember there being any problems. I did the same thing when I went

DB File Sequential Reads

Hi Fellas, An old SIEBEL application running against a 7.3.4 database on NT. There are performance issues. A query which runs with in no time on the QA box, takes 2 minutes on the production. Optimizer is set to RULE. The access plan is the same on both the boxed for the query. On Production,

Re: SP2-0103: Nothing in SQL buffer to run.

Krishan Gupta wrote: Hi Oracle Gurus This might be very silly problem for you gyus, but I am really geting headache. I suppose today my mind is not working in sync. I am attatching the script which i wrote. When I try to execute on sql promp, I get the result like this : SQL

RE: deleting a datafile on OPS

Jay is absolutely right. Paul, if you would like to know more about your datafile issue go to 'metalink.oracle.com' and check out 'Note:111316.1', which will explain everything about datafile re-org. --- Miller, Jay [EMAIL PROTECTED] wrote: It isn't an OPS issue, you can't drop a datafile

Re: Oracle and Document Management: any real stories?

- Original Message - TOPIC: Oracle and Document Management: any real stories or information? Does anyone have any experience with Oracle and Document Management that they're willing to share? [I'm cross-posting to Oracle Apps and Oracle Server.] check Oracle Internet File System

RE: Has anyone installed 9i On Win XP Pro

Title: Message I did, but I haven't done much with it yet. I think I used version 9.0.1.0.0, not the current release. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 07, 2002 9:21 AMTo: Multiple recipients of list ORACLE-LSubject:

RE: export/import on the same server

Rachel and everyone else, Thanks much for your help in helping me do my first import/export. It actually worked the first time like I hoped it would. I went with the import by user schema. Got a couple of errors at the end of my import on some Replication procedures that are invalid but I

RE: MC/Serviceguard vs Sun Clusters

Title: RE: MC/Serviceguard vs Sun Clusters Were you only running a single heartbeat connection? Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)

RE: Unorthodox 8i install/upgrade

We have followed the HP model and set up a software distribution (HP calls it a Software Depot) node. We copy the CDs into appropriate directories as the Oracle administrator. Then we allow NFS mounts of the SD node file systems and install from the SD node. We also are running Samba here

Advanced Queueing

Hi - Is anybody using Oracle's AQ feature with MQ Series? If so, please contact me, I have some questions on what is needed - ie. Gateway from MQ, Gateway from Oracle. Thank you! Lisa Yttri IBM Global Services Oracle Database Administration (262) 636-6797 -- Please see the official

RE: What impacts index build times on partitioned tables?

Hello Cherie Your talk about other applications made me think that you allowed the DB to be accessed during this time. Anyway, I think that you need to monitor CPU, I/O, page faults and all the other nice things in the machine. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED]

RE: Unorthodox 8i install/upgrade

I did the same thing too. One of the advantage is when all of my servers are at a data center physically located else where. I don't need to phone up a DC operator and have the CD put into the tray. Richard -Original Message- Sent: Thursday, February 07, 2002 12:33 PM To: Multiple

TFM

We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables and associated other back end stuff... anyone know where they can be found. I can find some on

Re: STATSPACK impact?

REF: PG 3 MARCH/APRIL 2000 DBAs can set specific level of running statspack. Level 0 Level 5 does not impact resource usage that much so that you notice the difference. But Oracle warns not to run Level 10 cause it is marked as resource intensive. Level 10 Statspack collects all statistics from

Re:RE: Migration utility from 7.3.4 to 9i ??

Dick, Even if you take export/import route it should be fine. As far as the rowid is concerned it should be the same as rowid in version 8. so logically there will be a conversion of the row-ids from older format(v 7.3.4) to the new format( v 8 or v 9), and nothing is needed to be done

RE: Unorthodox 8i install/upgrade

Ditto here. Me too! Me too! Me too! Bambi. -Original Message- Sent: Thursday, February 07, 2002 1:05 PM To: Multiple recipients of list ORACLE-L I did the same thing too. One of the advantage is when all of my servers are at a data center physically located else where. I don't

Re: question on EXPLAIN_PLAN

Hi, Rafiq Thank you for your advise, and thanks everyone, the handsome guys, reply me. You are right, it seems like a High Water Mark problem, after lots of other try, finally I drop that table and re-create that table, copy data, build PK index, analyzed in same way as before, and test

RE: stopiing write to listener.log

SHibu, In lsnrctl, set log_status=off. Chuan Oracle DBA Transact Communication, Ltd. -Original Message- Sent: Thursday, 7 February 2002 9:38 PM To: Multiple recipients of list ORACLE-L Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu --

Re: MC/Serviceguard vs Sun Clusters

I'm amazed that failover doesn't seem to be any more robust or reliable than the first time I worked with it 8 years ago, on some platforms anyway. Jared On Thursday 07 February 2002 08:55, Dejam, Ruth wrote: I'll second this. I worked with Sun a few years ago at another place. Here, we're

Re: question on EXPLAIN_PLAN

Re the HWM causing a slowdown: A needle in a haystack is much easier to find when the haystack has been removed. Jared On Thursday 07 February 2002 13:06, kevin wang wrote: Hi, Rafiq Thank you for your advise, and thanks everyone, the handsome guys, reply me. You are right, it seems

Re: question on EXPLAIN_PLAN

Kevin, select count(*) from table_name This was the key on the basis of that I suggested this solution...Your Test definately don't have that high water mark... As regard still some slowness, check for number of extents and it is sizing...If more extents 'select counts' goes for full table

Bitmap Indexes

Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some

Re:Breakable 9i ?

I really hate it when someone like Uncle Larry makes a claim like this. Sure enough that one claim will spur someone to find a hole that they can then rub into everyone's face. It's kind of like tossing lit matches at a can of gasoline, sooner or later your going to get burned. It's just a

RE: Oracle and Document Management: any real stories?

Internet File System Separate product, but free. Todd -Original Message- Hilary Sent: Thursday, February 07, 2002 11:21 AM To: Multiple recipients of list ORACLE-L TOPIC: Oracle and Document Management: any real stories or information? Does anyone have any experience with Oracle and

Re:Bitmap Indexes

Ethan, Our data warehouse has both bit map and b-tree indexes and we normally do not have a problem. One headache we do have is that one of the indexes is on a column that accumulates a lot on new values each time the warehouse is loaded which really makes a mess of the load process, namely

RE: What impacts index build times on partitioned tables?

Please check following Are you creating indexes with parallel clause or not? Are you using unrecoverable/nologging or not Is your sort_area_size is ok? What type of TEMP tablespace are you using with temp file or datafile and sizing of extents are proper? Is your target tablespace is not that

Re:RE: Migration utility from 7.3.4 to 9i ??

Shaibal, whenever a table is being accessed by the user for the first time after the migration, row-ids will be converted to ne format implicitly. To avoid this situation, just after migration from 7.3.4 to 8i, we normally export full database to a null device so that this issue may be

  1   2   >