Data Transfer or Views from SQL Server to Oracle

Hello, SQL Server in on Windows 2000 Box. Oracle 8.1.7 is on Unix. Is there any process by which data can be transferred from SQL SERVER to ORACLE directly.. something like views / snapshots. (Requirement is almost realtime data from SQL Server to Oracle) I am initially not planning to dump the

RE: Excessive SQL*Net message from client waits

I noticed a similar problem on my last contract assignment. I was lucky as the loading process took 4 hours but only 1 hour was spent by oracle. So we knew it was application that was taking the time. running the application on a faster processor cut the time to 1/3. We also could not find any prob

RE: log buffer space

Dear AK, So far we don't know your log buffer size. Can we have a glimpse of this parameter, log_buffer ? Rajesh -Original Message- Sent: Friday, March 14, 2003 8:14 PM To: Multiple recipients of list ORACLE-L Do you guys think , adding more log file can help ? I think it should not ,

RE: 9i RAC - GFS

Yup. I believe it's something we're actively working with Sun on, because other clustered fil systems (like Compaq's) perform fine. Sun's is just too slow for some reason. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder tha

RE: Server Recommendations

Title: RE: Server Recommendations Correct answer. Here’s a little more detail to think about.   Assuming that you’re using a reasonably scalable OS (I’m honestly not sure whether MS Windows yet actually qualifies), two 1GHz CPUs will provide more scalable performance under higher concurr

9i RAC - GFS

Attached in a quote from an Oracle Rep, asking us to avoid Global file systems on Sun Cluster nodes for 9i RAC. It is very clear that binaries and/or datafiles on GFS are not supported today. The reason for this is the proxy I/O that GFS is based on can be a real performance and scalability bottle

Re: log buffer space

1 log switch per minute ;-) AK wrote: > > log buffer is 320 K and log files are 30M approx. there are about 50 log > switch /hr . > > -ak > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, March 14, 2003 9:29 AM > > > AK, > > > >

Re: Server Recommendations

If there is a lot of latch contention, choose 1 fast one. If there is no latch contention, choose 2 not so fast ones. Anjo. Tom Schruefer wrote: > > I have a question, I have to make a decision on the purchase of a new web > server for a multiteir Oracle based system. So here are my two rema

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

Scott (and others), I apologize, all I was given regarding this document was a hard copy and based on confidentiality footers, I'm don't think I'm allowed to distribute it. However, if you're on an EMC system now, I'd call or e-mail your EMC rep and ask for it. If it works as well as describe

Re: log buffer space

I'm sorry, I've missed whether this is a production database in archive log mode or not. If it is, log switches twice per hour may be too few. You should find out what your data loss tolerance is for this instance and adjust your redo log setup to accomodate that. I agree, 50 per hour is a bi

Re: log buffer space

50 log switches per hour is a LOT. Get it down to a handful or so by increasing the size of the redo logs with a factor 10 or so. Redo buffer sounds a bit small, and going to 1M in size might help a bit, although there's no guarantee for it. Mogens AK wrote: log buffer is 320 K and log fil

CBO Tutorial Day - Orlando

Arrangements are now complete for the CBO Tutorial that I will be holding in Orlando on Friday May 2nd. For further details see http://www.jlcomp.demon.co.uk/tutorial.html Jonathan Lewis http://www.jlcomp.demon.co.uk Now available One-day tutorials: Cost Based Optimisation Troubl

Re: log buffer space

Well, there lies your problem. I suggest you do the following in this order of priority and see if they resolved the problem. (1) Log buffer of 320K is definitely small. Make it 4 MB (or at least 3MB) if you have enough memory. (2) Your log switching is 50 per hour?!! That's a little too much. Are

RE: Server Recommendations

Title: RE: Server Recommendations > From: Tom Schruefer [mailto:[EMAIL PROTECTED]] > > > I have a question, I have to make a decision on the purchase > of a new web server for a multiteir Oracle based system.  So > here are my two remaining options, all other things remaining > equal, on

RE: Multiple Instances and 9iRAC

Sorry I didn't explain the configuration very well-  here is what I'm talking about:   We have an existing HP server currently running 4 instances/databases.  Sid1,sid2,sid3,sid4   Is it advisable to implement RAC for all the databases/sids on this server?   i.e.   Cluster1= Node

RE: Sun=/var/messages HP-UX=???

dmesg... now, that, I know. It needs root privs to use. And unless it is run via some automated setup (cron, as you mentioned) to create a public accessible report, we are stuck with syslog.log. At least, on most systems, it is public readable... Thanks.. - Kirti -Original Message-

Server Recommendations

I have a question, I have to make a decision on the purchase of a new web server for a multiteir Oracle based system. So here are my two remaining options, all other things remaining equal, on a system which has 100% dynamically generated web pages. 1. A server with one 2ghz CPU. or 2. A serve

Re: rollback segment

ak, Here is a query you can run to see if it is currently in use... SQL> select b.segment_name, a.xacts, a.shrinks, a.wraps, a.extends 2 from v$rollstat a, dba_rollback_segs b 3 where a.usn = b.segment_id 4 / SEGMENT_NAMEXACTSSHRINKS WRAPSEXTENDS ---

Re: rollback segment

You can take the rollback segment offline. It will not impact any currently running transactions and no new transactions will be assigned to it. Oracle will not let you drop a rollback segment while there are any active transactions writing undo to the rollback segment. IIRC, the v$rollstat.sta

Re: log buffer space

log buffer is 320 K and log files are 30M approx. there are about 50 log switch /hr . -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 9:29 AM > AK, > > Could you provide the redo log sizes and the log_buffers paramete

RE: Statspack recomendations.

I alwasys use bookfinder.com to search for books; it queries quite a few sites and generally finds the best price for me (new and/or used). Another useful site is the ISBN locator at www.isbn.nu Good luck! Rich > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Be

RE: rollback segment

AK Sometime when your system isn't at its peak, just take the segment offline. Then wait a little while and check the status. Oracle won't take the segment offline as long as active processes are using it. Oracle won't let you drop it until it is able to take it offline. Dennis Williams DBA,

rollback segment

I have recently found that one temporary rollback segment in system tablespace is having more then 600 extnets . It looks like previous dba created this rollback segment at the time of db creation and forgot to take it offline . Now how do I find it this rollback segment is being used activ

Re: db file scattered read

It's doing that because it ISN'T reading a sequential set of blocks. In my example (taken from your original list) block 14,709 is presumably already in the buffer, so Oracle has to read up to it, (which takes three blocks), skip it, and then start again at the block after. Arguably it might be

RE: Sun=/var/messages HP-UX=???

hpux 11.0 man dmesg shows the standard setup using /var/adm/messages. dmesg looks in a system buffer for recently printed diagnostic messages and prints them on the standard output. The messages are those printed by the system when unusual events occur (such as when syste

Re: constraints and optimizer

All recent versions of Oracle have used unique, pk and not-null constraints to help optimise queries - but I don't suppose you were thinking of those in particular. In general Oracle did not make use of check constraints except for partition views, but Oracle 9 can now make very good use of chec

RE: Sun=/var/messages HP-UX=???

Thanks, I looked through both files (they are both here) and the information in syslog seems more meaningfull on the HP-UX than what I see in the messages file, it is just the opposite on the Sun box. - Ethan -Original Message- Sent: Friday, March 14, 2003 10:44 AM To: Multiple recipien

Re: Standby errors

Why does the copying of archive logs to the standby have anything to do with a hot backup on the primary? They seem like unrelated events. The reason you are getting an incomplete log is that you are using 'alter system switch logfile'. This command returns before archival, so your copy can comm

Re: db file scattered read

Thanks Jonathen , But what I am pointing to is , why it is reading 3 blocks first time and then 8 blocks next time , why not 8 blocks always . Look at p3 which is no of block read . -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, Ma

RE: log buffer space

I remember seeing documentation on it for 8i as well. --- Pete Sharman <[EMAIL PROTECTED]> wrote: > Really? I thought that condition was there pre-9i as well. Maybe > I'm > mistaken. > > Pete > "Controlling developers is like herding cats." > Kevin Loney, Oracle DBA Handbook > "Oh no, it's not

RE: Sun=/var/messages HP-UX=???

What version of HP-UX? Here is what I get on HP-UX 11.0: df2hp105 [IWHA]: ll /var/adm/me* /var/adm/me* not found - Kirti -Original Message- Sent: Friday, March 14, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Actually /var/adm/messages on hpux is the message file, which my

Re: db file scattered read

The counts are inclusive: 14706 / 3 means 14,706 14,707 14,708 so you have to skip one then start again at 14,710. Yes, 'ela' is the elapsed time in 1/100 of a second. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Now available One-day tutorials: Cost Based Optimisation

RE: log buffer space

Arup I have a busy day, so the only resource I can quote without research is the Oracle Education Oracle9i Database Performance Tuning Student Guide. Lesson 5-3 reads: "When the redo log buffer is one-third full". Hope that answers your question. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch,

constraints and optimizer

Hello, Env: Oracle 9.2.0.2.0 on Solaris 9 I suspect this is a foolish question, but I will ask anyway: (It's Friday; my brain stops working after Wednesday) How much does the presence of constraints influence the optimizer, if the indexes are present? We are developing a method for transporting

RE: Backup Strategy

I have found Joe Testa's site has a good set of RMAN scripts (I think they came from Jack van Zanen off this list), quite simple but they give the syntax for most of the commands you will want The link was http://www.oracle-dba.com but that is no longer working Where have you put them Joe?? Joh

[no subject]

They have been removed due to my rman framework scripts taking the disk space. Sorry. Joe >I have found Joe Testa's site has a good set of RMAN scripts (I think >they came from Jack van Zanen off this list), quite simple but they >give the syntax for most of the commands you will want >The lin

RE: Oracle JDBC thin driver

Title: Message No, that's why it's the thin driver.  If you want TAF capability, you have to use the JDBC thick driver instead.     Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not.  It's much harder than that!" Bruce Pihlamae, long-te

Re: Fixed_date and dbms_job

Thanks!! Darrell Landrum Database Administrator Zale Corporation >>> [EMAIL PROTECTED] 03/14/03 12:44PM >>> It takes 16 failures to mark the job as "broken". Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sen

RE: File Restoration/Recovery

Title: RE: File Restoration/Recovery Schema level export can fix the *thinking* Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art

RE: segment from block#

You will need FILE_ID as well. Here is what I use: -- find_segment.sql -- Finds segment name based on file_id and block_id set Lines 132 col Owner for a10 col Segment_name for a30 col Segment_type for a20 col Tablespace_name for a30 select Owner, Segment_Name, Segment_Type,

RE: db file scattered read

For the answer to your first question, see Jeff Holt’s “Predicting Multiblock Read Size” at www.hotsos.com/catalog. Prior to Release 9, the statistic “ela= 1” means that the syscall lasted somewhere between 0.005000 and 0.014999 seconds in duration. Full details forthcoming in “Optimizing

How to get working hours ???

Hi, We have open Time for every order, ef: Open Time -- 03/12/03 11:08:07 How to calculate the working hours (8am - 5pm, no weekends) that a file remain open until now? (Sysdate - Open_Time) returns all the hours including weekend and <8am, >5pm hours. We only like to know the

Re: High current mode buffer gets on insert

Current mode gets for index inserts is one option. Another cause of CU gets is from checking referential integrity. The block holding the parent key is acquired in current mode as the child row is inserted. There is an optimisation to reduce this effect in arrays/select inserts in Oracle 9, tho

Re: Fixed_date and dbms_job

It takes 16 failures to mark the job as "broken". Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 11:24 AM > Ben, > > If this problem has not been fixed, check something else. > Run

RE: RE: why SAN ? why not external storage ?

All of the places I've worked its been sysadmins fat-fingering that has hosed or cross mounted disks. Then again, we've never had EMC... HP arrays are enough trouble. Scott Shafer San Antonio, TX 210.581.6217 > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] > Sent

RE: Organizational Challenge - Data Management Team

Ron, I think you are starting at a good place. Production DBA's worry about different things than Development DBA's. Mostly they are concerned with (in priority order) Backup schedules & Validations (make sure they are working), disk usage (make sure there is enough) and on-going tuning issues.

Re: Veritas Quick I/O for Oracle

DENNIS WILLIAMS wrote: Is anyone using Veritas Quick I/O for Oracle? We are purchasing some new Solaris systems with fiber channel and Veritas File System, and the Veritas salesperson is claiming "up to 400 times faster". I would like to know if anyone else has discovered this miracle and what bene

Re: Bypassing startup triggers

How about alter system set "_system_trig_enabled" =false chaim "Thomas Day" <[EMAIL PROTECTED]>@fatcity.com on 03/14/2003 12:04:33 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Any way to do tha

RE: log buffer space

Maybe finger stutter. I've never seen it mentioned anywhere except as 1/3. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Sent: Friday, March 1

Ignore post about startup trigger

That wasn't the problem at all. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: utl_file_dir and 9i

Nah, can't do that! It would make our training courses that use it too difficult to set up! :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message-

Re: Multiple Instances and 9iRAC

Todd,   RAC is a multi-instance database. If you have n nodes in a cluster then you generally have (although not necessarily that many) n instances accessing the same database. When you mention 3 or more Oracle instances, perhaps you mean 3 or more "databases" each in a separate cluster of 4

RE: File Restoration/Recovery

What can I say? Shoot the danged developer! No, no, no, no, no. The backup is as much use as the proverbial on a bull. Period. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Ora

Re: log buffer space

Dennis, The 1MB condition was in 8i as well, at least in 8.1.7, as I mentioned in my original post. I was always under impresssion that the flush is triggered by the buffer being 1/3rd full; but KG mentioned it was 2/3rd, not 1/3rd and I was wondering where he got that information from and if it'

Re: Bypassing startup triggers

You might try putting _system_trig_enabled=FALSE in your init file. I'd test this though to make sure. (or disable the triggers in question) >>> [EMAIL PROTECTED] 03/14/03 11:04AM >>> Any way to do that? Fast answer is appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.ora

Re: File Restoration/Recovery

Gary, I second this user's comments. Is it possible to get a valid backup while the database is up? Yes, it is but it is just plain silly (at the very least), to plan to do so. Whether or not this backup is good depends on no activity and if there's no activity, why not just shut it down and

RE: log buffer space

Title: RE: log buffer space I think this might help... http://www.ixora.com.au/tips/tuning/log_buffer_size.htm -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Friday, March 14, 2003 11:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: log b

Re: Bypassing startup triggers

alter system set _system_trig_enabled = false; Jared "Thomas Day" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/14/2003 09:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Bypassing startup

Oracle JDBC thin driver

Oracle 9.2.0.2   Can the Oracle JDBC thin driver be used with RAC to setup failover and load balancing between instances in the same way the thick driver can?   Thanks,   Rick Stephenson   This email and any files transmitted with it are confidential and intended solely for

Re:RE: why SAN ? why not external storage ?

Humm, must of missed this one on the rebound. Anyway, here Disk space is an admin nightmare. Each time we want to reassign disks from one server to another here comes EMC to re-program the Symmetrix array otherwise the SA has the possibility of assigning 2 servers to the same disk. OOPS I really

Re: Fixed_date and dbms_job

Many thanks Jared, Definitely I think this is only one away to resolve my problem. Have nice week end, Ben --- [EMAIL PROTECTED] wrote: > You can't call a job every second via DBMS_JOB. > > I believe that at best the resolution is 1 minute. > > You could just open another session and run >

RE: Multiple Instances and 9iRAC

Title: Message RAC is a multiple instance one database configuration.  Different instances on different nodes accessing a single database on shared disk.   Can you have multiple RAC databases running in a cluster?  Sure, if the machine has enough resources.  That's about as close as we can sa

RE: File Restoration/Recovery

Gary - send the developer to backup and recovery school. he is wrong. as Rachel said, *maybe* it will work once. but as a DBA, you personally can *never* support this in a real environment. you will not be able to guarantee the same results every time. Tom Mercadante Oracle Certified Professio

RE: log buffer space

Really? I thought that condition was there pre-9i as well. Maybe I'm mistaken. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- WILLIAMS Sent: F

Re: disable ODBC access to Oracle db

This was my first thought. On Friday 14 March 2003 10:48, Stephane Paquette wrote: > Access is very appreciated by our end users here. > On the most sensible systems we worked with the dev teams on the login > procedure. > We usually enable a role in the login procedure so the users can only > con

RE: Veritas Quick I/O for Oracle

Title: RE: Veritas Quick I/O for Oracle got a copy, benchmarked it.  No discernable difference for our application.  Others I know swear that it's great. So I guess it varies by the application. Matt Adams - GE Appliances - [EMAIL PROTECTED] Another month has ended.  All goals met All

RE: Standby errors

I have seen lower sequence logs complete archival after higher sequence logs. Usually coinciding with some sort of I/O bottleneck where multiple archiver processes are competing for limited bandwidth. I have not seen any sort of log corruption as a result of that process though. If the logs ar

RE: Organizational Challenge - Data Management Team

In a previous life, I worked at WilTel (very well managed), which became WorldCom (so-so), which became MCI WorldCom (no comment). I started out in WilTel's Engineering Department which (wisely) kept all of IT operations separate and independent from the grand and glorious (and huge) company IT d

Multiple Instances and 9iRAC

  My company is currently considering using Oracle 9i RAC. One of the proposed environments is to have multiple oracle instances (3 or more) configured on a 4-8 node RAC cluster. Does anyone have any insights as to the viability of this implementation?  Will the high speed inter connect be

Re: File Restoration/Recovery

you are right and the developer is not. cold backups taken with the db open are worthless. you cannot use them to open it back to a consistent state babu - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 10:44 AM > All... > >

Re: Veritas Quick I/O for Oracle

we recently moved from t64 to sun and had io related perf issues w/o quick io. once the veritas db version (which which quick io comes) was installed, the performance was back on par with t64... babu - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent:

Re:File Restoration/Recovery

Now, you could put the tablespaces in read only mode, then the copy would work.  But then again, could you put all the tablespaces in read only mode ?   h, don't think so :).>>> [EMAIL PROTECTED] 03/14/03 11:54AM >>>Gary,    Only if 1) The database is shutdown prior to the copy of the da

RE: File Restoration/Recovery

Chances are excellent, that you/oracle would not be able to recover. Oracle support might bring the super tool with the swat expert for 5000 bucks an hour...and then it might still be a mess. They would love you doing this stuff.. Brian -Original Message- Sent: Friday, March 14, 2003

RE: Is range partitioning possible on part of varchar2 column ???

This seems to be a good idea. I will see if this is acceptable to my people. Earliar I suggested to change to date field, and was not acceptable for them as there seems plenty of code needs to be changed. I will see if this change is acceptable for them. One thing I could understand clearly from

Re: segment from block#

Title: Re: segment from block# You also need to specify the file_id in the predicate. However, on anything but a micky-mouse (T) database this query will take a long time which is why I run a nightly job to populate a "extent_to_object" table which will give me that answer quickly (except f

Bypassing startup triggers

Any way to do that? Fast answer is appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: Fixed_date and dbms_job

You can't call a job every second via DBMS_JOB. I believe that at best the resolution is 1 minute. You could just open another session and run something like this: declare fd varchar2(50) := '01/01/2010 00:00:00'; v_sql varchar2(200); begin loop v_sql := 'alter system set fixed_da

RE: why SAN ? why not external storage ?

Oh, Gods forbid the sysadmins would have to do their job... HAHAHAHAHA!!! Scott Shafer San Antonio, TX 210.581.6217 > -Original Message- > From: Mogens Nørgaard [SMTP:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2003 5:25 PM > To: Multiple recipients of list ORACLE-L > Subject:

db file scattered read

Here is a part of trace file . I am finding that oracle is trying to read 8 or 3 or 7 blocks at a time . But block numbers are all sequential i.e. it will read 3 blocks starting from 14706 and then 8 blocks starting from 14710 ( 14706+3 ). Why it doesn't read 8 blcoks always it multi_block_r

Re: segment from block#

Join the file_id as well as follows   select segment_name from dba_extents where file_id = 123 and 259186 between blocks and blocks+block_id   HTH   Arup - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Friday, March 14, 2003 11:03 AM S

Re:File Restoration/Recovery

Gary, Only if 1) The database is shutdown prior to the copy of the datafiles, and everything else that compromises the database (online redo, control files, etc...) or 2) the effected tablespaces are put into hot backup mode before the copy, in which case when you restore the files Oracle will

Re[2]:File Restoration/Recovery

Gary, I had a similar "engineer" managed DB around here for a while. The problem was that 'someone' deleted a couple of the datafiles by 'mistake'. (Ever see that CDW commercial concerning the "full file server"?) Well I got asked the same question to which I had a very good laugh & told the

RE: utl_file_dir and 9i

Precisely But wouldn't it be nice if Oracle made '*', in the utl_file_dir specification, an unacceptable parameter value? - Kirti -Original Message- Sent: Friday, March 14, 2003 9:19 AM To: Multiple recipients of list ORACLE-L True, but any DBA who puts utl_file_dir=* into thei

Re: File Restoration/Recovery

As with all backup and recovery plans, you should test, document, and perhaps automate the process, with particular emphasis on the recovery. What your associate describes sounds like an very expensive B&R plan. On Fri, Mar 14, 2003 at 07:44:01AM -0800, Gary Chambers wrote: > All... > > A

Re: Oracle Development Suite for Linux?

This link is about installing on Red Hat Advanced Server. What differences will I face trying to install on Red Hat 7 (or 8 if I can get my video card working in 8)? Thanks Stephen >>> [EMAIL PROTECTED] 03/10/03 09:28PM >>> I installed 9.2 on redhat 8.0 with great luck. I installed on a 700 PC

Re: log buffer space

AK, Could you provide the redo log sizes and the log_buffers parameters, please. Also let us know the log switch frequency, too. Thanks. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 11:14 AM > Do you guys think ,

Re: High current mode buffer gets on insert

I thought I'd repost to see if I could get a response. Anyone? --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > I'm looking at a client's tkprof output, showing among other things > that the insertion of about 135,000 rows taking 450 seconds of CPU, > and > with current mode buffer gets numberin

RE: log buffer space

I think the only ways adding more log files might help is if your app is waiting on "log file switch (%)" events. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101, Mar 25-27 Oxford - Hotsos Clinic 101, Apr 8-10 Chicago -Original Message-

RE: Organizational Challenge - Data Management Team

Ron - As a solo DBA shop, I can't be much help except to point out that most of what I've heard involves the DBAs specializing between production work and development work. Some DBAs administer the production databases, others work with the developers. This also seems to suit the personality types.

Re:File Restoration/Recovery

Dick... Thanks very much for the reply! > Only if 1) The database is shutdown prior to the copy of the > datafiles, and everything else that compromises the database (online > redo, control files, etc...) I hate second-guessing myself, but this is what I've been trying to tell him. > or 2) the

Re: log buffer space

Are there any equations which can say log buffer is small or large ? I mean how to find the proper size of log buffer .   -ak - Original Message - From: Deshpande, Kirti To: Multiple recipients of list ORACLE-L Sent: Thursday, March 13, 2003 5:13 PM Subject: RE: l

RE: log buffer space

What's the size of your log buffer, and the redo log file? Do you see any errors/messages in alert.log file that are related to 'checkpoints' or 'log switching'? - Kirti -Original Message- Sent: Friday, March 14, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Do you guys thi

RE: a DIFFERENT sql question

Title: RE: a DIFFERENT sql question SELECT DISTINCT  t1.category CAT ,t2.type TYP ,SUM(DISTINCT t1.amount1) OVER(PARTITION BY t1.category) Sum1 ,SUM(t2.amount2) OVER(PARTITION BY t1.category, t2.type) Sum2 FROM  t1 ,t2 WHERE  t1.mykey1 = t2.mykey1 / CAT TYP SUM1  

RE: ODBC access to Oracle db

Access is very appreciated by our end users here. On the most sensible systems we worked with the dev teams on the login procedure. We usually enable a role in the login procedure so the users can only connect to the database via the application. Another way we had implemented security is that we p

Veritas Quick I/O for Oracle

Is anyone using Veritas Quick I/O for Oracle? We are purchasing some new Solaris systems with fiber channel and Veritas File System, and the Veritas salesperson is claiming "up to 400 times faster". I would like to know if anyone else has discovered this miracle and what benefits you are seeing. Th

RE: utl_file_dir and 9i

Title: RE: utl_file_dir and 9i Pete, At-least that way to can verify that your backup and recovery scenario's are up-to-date 8:) Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: An

Re: File Restoration/Recovery

no no no no no no If he is REALLY lucky, and no one is using the database at the instant he does all the copies (and I mean the OS as well), then MAYBE, POSSIBLY, if the Tooth Fairy and Easter Bunny are present and bless the copy, he might have a valid backup. But I wouldn't bet my job on it. H

RE: utl_file_dir and 9i

Title: RE: utl_file_dir and 9i The answer is still NO Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Messag

RE: Sun=/var/messages HP-UX=???

Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) machine is also using /var/adm/messages, maybe I changed this, I don't remember. /var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris. > -Original Message- > From: Nelson, Allan

RE: Backup Strategy

Jay If you want a good book to get up to speed on RMAN, buy Oracle9i RMAN Backup & Recovery by Robert Freeman and Matthew Hart If you want to compare the steps for various recovery scenarios between RMAN and user-managed recovery, get Oracle Backup & Recovery 101 by Smith and Haisley. It

  1   2   >