Re:

That getenrated redo size for this statement was 828 bytes. If an instance ecovery is needed, redo log files will be read and your transaction will be applied. If your transaction was committed, it will not be rolled back. Redo log files are only read during recovery. There are some ramificatio

explain plan - redo size ???

Guys , my insert statement is below . explain shows 828 for redo size . does it mean the no of blocks ? what should be the ideal value for the same ? what does the value for redo size = 828 indicate ? kindly explain me. insert into MSG_History (Tel,MemNo,FromMemNo,Sex,PDate,Content,S_Name,S_

[no subject]

Guys , my insert statement is below . explain shows 828 for redo size . does it mean the no of blocks ? what should be the ideal value for the same ? what does the value for redo size = 828 indicate ? kindly explain me. insert into MSG_History (Tel,MemNo,FromMemNo,Sex,PDate,Content,S_Name,S_

How to insert Special Characters ?

I want to insert the following characters , 1.) ' 2.) " 3.) & for example i want to insert the following line as it looks... where part_no='1234' and name='guest' how to do ? can anyone help ... Regards, Prakash. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: Table Naming Conventions

That's a classic one, taught in various courses ever since version 5. The most famous example was select... where date_column='12-31-99' where date_column would be implicitly converted to varchar2. A little 'explain plan' effort and all the confusion is easily avoided. On 2002.07.31 00:08

RE: Table Naming Conventions

Rachel, one of the SQL statements in our Clinic that people find the hardest to optimize is one that has a thing that looks like "id_number = 1" in the where clause. "id_number" is the table's primary key, yet the query spends 20 seconds executing a full-table scan. Any guesses? It's because

RE: ... And another RMAN Q.

Dennis, Someone did mention that to me but found it hard to believe Oracle does not have an option to save the backupsets in the box where you initiated RMAN. Maybe Oracle thought by allowing it, it will saturate the network. Still, I would have preferred the option to be there. Rgds, Ross >

RE: ... And another RMAN Q.

Hi Tom, My backup starts on BoxA. It uses the rman binary in BoxA. So I do 'connect target user/passwd@BoxB'. Well I too thought that the backupset will be created in BoxA. Looks like backupsets gets created wherever the target db is. rgds, Ross > -Original Message- > From: Mercadante,

RE: Table Naming Conventions

I don't like such prefixes because they make it easier to lie or make mistakes. I've seen people try for hours to figure out why something doesn't make sense, only to find out that the index whose name has a 'U' in it actually wasn't created with the "UNIQUE" attribute. Names falsely cause relian

RE: ... And another RMAN Q.

Thanks Alex. Yes that thought occured in my mind but that would be my last option. I'm still trying to find other ways than remote mounting filesystems. Rgds, Ross > -Original Message- > From: Alexandre Gorbatchev [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 31 July 2002 0:03 > To: Mult

Cluster problem

All, I am having a problem with a cluster. My environment is Oracle 8.1.7 on Win2k on a COMPAQ server. This is a production DB that has been running for a year or so and I have now taken it over. My problem is that there is a table that has 1 column in a cluster. The cluster does not contain any

RE: Table Naming Conventions

I can see your point, In the data warehouse we are building here, the modeler is planning on prefixing tables with the type of table (D_ for dimension tables, F_ for fact, etc) Hm, you mean we have to go back and revisit the naming standards that they developed? Can I please suffix the column nam

RE: Table Naming Conventions

Hi Gary, In our environment, there are many applications in one database. We always create public synonym for all the tables. To avoid confusion, all the tables have to be tagged with the application prefix .eg. Student System has the prefix STD, so the tables will be STD_XXX where XXX is the tab

RE: Table Naming Conventions

Hmmm. Seems I have to play devil's advocate on this one. So, you see no purpose to index names such as: P_EMPLOYEE for a Primary key on the employee table or UM_METER_CODE for a unique index on the meter table meter_code column or FE_DEPT for a foreign key index on the employee table dept colu

RE: Ids and passwords for application users

Title: RE: Ids and passwords for application users > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > >   If a common login is used (which is the case with most > applications), > dbms_application_info can be used to set the actual username > in either the

Re: OT: plot by "elitists" confirmed...

Oh I love it! And I had forgotten about Bored of the Rings :) --- Tim Gorman <[EMAIL PROTECTED]> wrote: > ...from ... > > > > Creators admit: UNIX and C Hoax! > In a

RE: ORA-1658 even though there is enough contig free

Title: RE: ORA-1658 even though there is enough contig free Could it be because of the minimum extent size? Though I would think it unlikely that your minimum extent size would be greater than 147MB. > -Original Message- > From: Jesse, Rich [mailto:[EMAIL PROTECTED]] > > On 8.1.7.2.0

RE: Table Naming Conventions

You already know it's an index, why would you include that as part of the name? Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/30/2002 02:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:

RE: Table Naming Conventions

I ran into a problem with this once. I had a procedure that I used to monitor database statistics that I named monitor_stats. I stored that data in a table called monitor_stats (OK, I should have named the table stats, but that seemed too generic). With a procedure and table named the same, the

Re: user(s) & RBS

select c.segment_name, e.sid, e.username, b.object_name, b.object_type, d.used_urec, a.os_user_name, d.xidusn, d.start_time, e.process, e.program, e.status from v$locked_object a, dba_objects b, dba_rollback_segs c, v$transaction d, v$session e

RE: user(s) & RBS

Title: RE: user(s) & RBS > -Original Message- > From: Charlie Mengler [mailto:[EMAIL PROTECTED]] > > If I'm interested in a specific RBS, how do I determine which user(s) > are making use of this segement? > > How do I determine which RBS a particular user is using? You could try t

RE: Creating sequences on the DUAL table?

An interesting use of sequences might be to encrypt information. Properly sequenced sequences could be used to easily encode information that would be destroyed upon being read. Know, I dunno where that came from, just hit me out of the blue while reading this thread. Could be fun though. Jare

RE: Table Naming Conventions

I just think it's a waste. You can tell by context what kind of thing a thing is. For example, consider: "select a.flarg from bloing a where a.croopoo > 7". This can be understood by syntactical context (even with the nonsense names), without having to rename "bloing" to "bloing_table". Most of t

Foreign Keys and Table Locking

Hello List, Here is my question: If a composite foreign key (defined using on delete cascade) is partially indexed, will a delete operation on the referenced table use the index on the partial foreign key? More Detailed Explanation of Question Assume the following 1. A master table with column

user(s) & RBS

If I'm interested in a specific RBS, how do I determine which user(s) are making use of this segement? How do I determine which RBS a particular user is using? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scr

Re: Host System Commands from PL/SQL blocks

One solution is to write custom code to call as an external procedure. A simpler method might be to just write a daemon that starts up prior to Oracle and is controlled through data passed via a table. The daemon tries to connect periodically, and after doing so, polls the control table on a reg

RE: Hot tables and Their Costs

Title: Message You already have paret of what you need from the stats$sql_summary table which tells you how often a statement has been executed.  Bear in mind this table will truncate any statement to 1000 bytes.   You will probably also need the stats$sqltext table.  This table was added to

RE: Ids and passwords for application users

If a common login is used (which is the case with most applications), dbms_application_info can be used to set the actual username in either the module or action. As long as the application is not using dbms_application_info to set both, you should be able to get the info from v$session. R

There are even more plots to go around.

Title: Microsoft Bids to Acquire Catholic Church     Microsoft Bids to Acquire Catholic Church VATICAN CITY (AP) -- In a joint press conference in St. Peter's Square this morning, MICROSOFT Corp. and the Vatican announced that the Redmond software giant will acquire the Roman Catholic Church

Re: ORA-1658 even though there is enough contig free

Rich, 1)Run following script to check fat size which will indicate how big your initial extent may be as you are not finding contigous space in your tablespace. when it ask for value give your tablespace name.. undefine table_space set verify off prompt This script provides a report useful for

OT: plot by "elitists" confirmed...

...from ...   Creators admit: UNIX and C Hoax! In an announcement that has stunned the computer industry, Ken Thompson, Dennis Ritchie, and Brian Kernighan admitted that the Unix operating system and C programming language created by them is an

Re: Foxbase to Oracle

On Tom Kyte's site asktom.oracle.com he had a question about the cost of Oracle vs. SQL Server. The upshot was that Oracle offers some fairly inexpensive options for small applications. "Oracle SE with small numbers of users is very inexpensive. You are looking at $1,500 USD for 5 named users.

Re: Download site for Oracle 9.2.0.1 Upgrade

Carle http://otn.oracle.com/software/products/oracle9i/content.html Alessandro - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 2:09 PM Hi, Where can I find the site to download the 9.2.0.1 upgrade. We currently have 9

RE: Table Naming Conventions

Cary, you said "* Don't embed the object type in the object's name. I used to see this all the time with tablespaces called XYZ_TS, indexes called IND_THING, and so on." what's your logic behind that? Rachel --- Cary Millsap <[EMAIL PROTECTED]> wrote: > Here's a start. Not a checklist by a

RE: Slightly OT: Chart generation tool for db monitoring scripts

Ethan - I empathize with some of the monitoring issues you had trouble with. In a former life I was tasked with implementing a custom monitoring system for a shop with over 150 database servers. In fact - we dedicated a server to monitoring the others. A couple tips that saved us a lot of time:

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

Title: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA Ha! I use to bang rocks together in sea water so that the sand could be used to make the first silicon chip 1,000,000 years later. Of course that was in my younger days.. Jerry Whittle ACIFICS DBA NCI Information Sy

RE: Table Naming Conventions

Title: RE: Table Naming Conventions My supervisor/client wants object types in names - except tables like I_ for indexes.  Why do you say stay away from this? -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 5:10 PM To: Multiple recipients

ORA-1658 even though there is enough contig free

Hi all, On 8.1.7.2.0 on HP/UX 11.0, I need to create an index online. So, I see how much space I have: select max(bytes/1024/1024) from dba_free_space where tablespace_name = 'MY_IDX_TS'; ...and it returns "147.3475". So I create my index: CREATE INDEX myschema.mycoolidx ON myschema.mycoolt

RE: Why DB_Name 4 chars only.

My std. also, 4 chars for db with last char denoting db use (Production, Test, Development, Training, etc.). I started on VMS Oracle 6, seemed to be the case back then, still hold to it. I used to have dns aliases for db names, VMS node name limit was 6 chars. For example: Payroll DB Names —

Download site for Oracle 9.2.0.1 Upgrade

Hi, Where can I find the site to download the 9.2.0.1 upgrade. We currently have 9.0.1' Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED]

Importing .dbf files into Oracle

Hi, Is it possible to import .dbf files that were created in dbase III+ into Oracle? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat

RE: Table Naming Conventions

Here's a start. Not a checklist by any means, just kind of a micro pet peeves list. * Decide today whether table names will be singular or plural. Do you want a THING (singular) table? Or a THINGS (plural) table? * Don't use case-sensitive names. E.g., use THING (without quotes) in your CREATE (

Re: Host System Commands from PL/SQL blocks

Take a look at Doc Id 50868.1 on metalink Babu John Weatherman <[EMAIL PROTECTED]>@fatcity.com on 07/30/2002 02:56:37 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: OK, I checked Google and my ow

Re: Why DB_Name 4 chars only.

For most unix Platforms, the SID can be upto 8 characters in length. For NT, I think, it should be 4 mainly because of DOS file name limitations. I dont have the resources on hand, but I guess one could confirm this by just trying to mount an instance with varying SID Names, until you get the err

RE: Why DB_Name 4 chars only.

Title: RE: Why DB_Name 4 chars only. > > What is the reason behind DB_Name/SID usually 4 chars > length only. I have a customer who is asking us to > create instance/db with 6 chars length. We usually > keep instance name and db_name parameters same in .ora > file. Can someone please explain

RE: Slightly OT: Chart generation tool for db monitoring scripts

Actually it isn't that hard. 1. Stuff your data every "N" minutes into a table with time stamp. 2. Aggregate data every "N" hours and stuff in other tables (weekly, monthly, yearly). I wrote some functions that round time to nearest half hour, two hours etc...to make this easy. 3. Delete old d

RE: Why DB_Name 4 chars only.

Srinivas Some systems have trouble with long identifiers. The SID gets various prefixes and postfixes, and if you have a long SID this can cause problems for systems that have restrictions on identifiers. An example is the server processes. This can cause issues on client platforms that are net

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

At least you had a light console. -Original Message- Sent: Tuesday, July 30, 2002 2:35 PM To: Multiple recipients of list ORACLE-L coding? ha! I used to flip switches to load my programs directly into core memory! and then I had to read the results from the light console! up-hill bo

RE: Why DB_Name 4 chars only.

This relates back to the dos days (break out that chisel). 8.3 filename format requires a sid less than 5 characters, eg, init.ora Ron Thomas Hypercom, Inc [EMAIL PROTECTED] "The problem with some people is that when they aren't drunk, they're sober." --William Butler Yeats.

Re: Why DB_Name 4 chars only.

You can go to 8.  We use up to 8 character SID's here.  I have tried going 9 on an 8.0.5 system and it barfed on the create scripts. Rodd On Tue, 2002-07-30 at 15:08, Srinivas wrote: Hi, What is the reason behind DB_Name/SID usually 4 chars length only. I have a customer who is aski

Table Naming Conventions

All... Will some of you please provide some insight on your table naming conventions? I'm in the very early planning stages of what will likely be a large and complex schema (IT asset inventory). I have a chance to start it correctly. TIA Gary Chambers //-

RE: Creating sequences on the DUAL table?

To be more accurate, a sequence does not even have to be used for a table. It is a construct to populate a variable (could be a table column, could be run time) with a number that is generated in a specific order (though it may contain gaps). Dan (as he ducks a knitting needle). -Original Me

Re: Host System Commands from PL/SQL blocks

You have to write an external stored procedure (C, C++, Java) and call it from your PL/SQL block. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 3:56 PM > OK, I checked Google and

Re: Why DB_Name 4 chars only.

Database name is limited to 9 characters, see "name" column in v$database. Instance name is limited to 181 characters (at least according to inst_name in v$active_instances). All this under 8.1.5. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of l

RE: Slightly OT: Chart generation tool for db monitoring scripts

If I can write good SQL to roll up data ... and still generate the charts ... is that a bad thing? I get your point, but right now, I can't get MRTG working without a web server, and I was looking for a pure file system based solution. Raj __ R

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

Who's got time for an abacus? It takes a lot of effort to chisel those bits into the stone tablets. Used to take a lot longer before I got my electric chisel 8-) Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Messag

RE: Why DB_Name 4 chars only.

We have SIDs 9 chars long! Ron SMith -Original Message- Sent: Tuesday, July 30, 2002 3:08 PM To: Multiple recipients of list ORACLE-L Hi, What is the reason behind DB_Name/SID usually 4 chars length only. I have a customer who is asking us to create instance/db with 6 chars length. We

Why DB_Name 4 chars only.

Hi, What is the reason behind DB_Name/SID usually 4 chars length only. I have a customer who is asking us to create instance/db with 6 chars length. We usually keep instance name and db_name parameters same in .ora file. Can someone please explain the reason behind db_name 4 chars only. Is it a co

RE: Creating sequences on the DUAL table?

Cherie, Terminology -- make sure they understand that sequences are not created attached to any table and can be used for more than one table. Rachel --- [EMAIL PROTECTED] wrote: > > Dan, > > Haven't heard the why yet but I think it may be just a poorly worded > request. I suspect he want

Host System Commands from PL/SQL blocks

OK, I checked Google and my own old mail and I know I've seen this here before, but can't find my notes, so please forgive this same old question... I need to execute a system call from within a PL/SQL block. Specifically, I am looking at starting out report request demons as part of a post star

RE: <> causing full table scan

bp, indexes are used when limiting conditions are equalities not inequalities (<>, !=, NOT IN) How about rewriting the query to replace the  <> by an outer join.   -Original Message-From: BigP [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 30, 2002 3:20 PMTo: Multiple recipients of

RE: Creating sequences on the DUAL table?

Mladen, Thanks for everyone's response on this. I think that this is just a misperception on the part of the developer. I took the phrase verbatim from his change request. I suspect that he has only ever used sequences in the SELECT from DUAL statement so he thinks that they are actual obj

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

Here we go again. So who's gonna be the first one with the abacus joke this time? --Walt (who makes Rachel look like a spring chicken) Weaver Bozeman, Montana -Original Message- Sent: Tuesday, July 30, 2002 1:20 PM To: Multiple recipients of list ORACLE-L Hex editor? geez you youngs

RE: Foxbase to Oracle - Thanks

Looks like most of the replies point to VFP. I will present this to my manager. Thanks to all who replied! Dennis Meng Database Administrator Focal Communications Corp.

RE: Creating sequences on the DUAL table?

I would think they probably saw something like select sequence_name.nextval from dual; Maybe they thought the sequence and dual were connected in some manner. -Original Message- Sent: Tuesday, July 30, 2002 2:15 PM To: Multiple recipients of list ORACLE-L Cherie, You don't create

RE: Creating sequences on the DUAL table?

Cherie, If you push F1 key from SqlPlus there will be a complete explanation called 'all about sequences and how to create them on dual table'. -Original Message- Sent: Tuesday, July 30, 2002 2:20 PM To: Multiple recipients of list ORACLE-L Dan, Haven't heard the why yet but I think it

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

Every single message I get on this post gets blocked:> Can't tell you but how I am wondering what is being said! -Original Message- Sent: Tuesday, July 30, 2002 3:07 PM To: Multiple recipients of list ORACLE-L The original message content contained a virus or was blocked due to blocki

RE: ODBC connection privs in Oracle

Title: RE: ODBC connection privs in Oracle Privileges would be that of the account specified in the ODBC connection setup, which are Oracle specific for the Oracle user.  What do you mean by "The privs do not appear to match Oracle-based security."? -Original Message- From: Boivin, P

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

coding? ha! I used to flip switches to load my programs directly into core memory! and then I had to read the results from the light console! up-hill both-ways in a snow-storm! -Original Message- Sent: Tuesday, July 30, 2002 3:20 PM To: Multiple recipients of list ORACLE-L Hex edit

RE: Creating sequences on the DUAL table?

Kevin, Thanks for the suggestion on select statements. I will pass them on. I think it's just a misunderstanding on his part as to where the sequences are actually created. Apparently he only uses them in a select from dual so he thinks they reside there. Cherie

dbsnmpj access violation

Title: dbsnmpj access violation Hi all, I've just finished installed 9.2 on W2K.  Whenever I submit a job through the OEM console the dbsnmpj.exe process gets an access violation and the job fails to run.  When I enable tracing on dbsnmpj, it works fine.  Disable tracing and it dies again.

<> causing full table scan

Hi list , In one of my queries if I use <> in where clause it is causing full table scan .  If i use "IN " (  ) it uses index . Actually if it is" <> " the it is doing hash join and if "IN" then nested loop . when i make opt_indx_cost_adj to 5 it starts using index again with <> condition .

RE: Ids and passwords for application users

Title: RE: Ids and passwords for application users Peter, not clear on if the database is going to be used by developers doing development work or will an application use it and you'll have up to 300 application users? If it's an application, how about making one account that owns all of t

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

Hex editor? geez you youngsters have it soft, in MY day we ran magnets over the disks to encode the "ones" and "zeros" :) --- [EMAIL PROTECTED] wrote: > No, I use a hex editor and directly write the bits to disk. > > Isn't that the way everyone here does it? > > Jared > > > > > > "Stra

RE: Creating sequences on the DUAL table?

Dan, Haven't heard the why yet but I think it may be just a poorly worded request. I suspect he wants the sequences created on another table and just wants to be able to select from dual. Maybe he never realized that the sequences were actually created on another table.Maybe he actually

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

No, I use a hex editor and directly write the bits to disk. Isn't that the way everyone here does it? Jared "Straub, Dan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/30/2002 10:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

RE: Creating sequences on the DUAL table?

What are "sequence on the table"? All I know about sequences is that they are entities for fas generation of unique numbers without encountering locks. They are standalone entries without much connection to any other object. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL P

Re: Creating sequences on the DUAL table?

Cherie, You don't create sequences on a table, they are objects in and of themselves. So you can create the sequences for the developers but I'm wondering where they got the notion that sequences were created on a table. And why they want to use DUAL. Rachel --- [EMAIL PROTECTED] wrote: >

RE: DBD::Oracle and JDBC Thin

Oh fdge. (Only I didn't say "fudge"). <10-watt bulb:on> After transcribing all my install problems here, I just realized that I'm supposed to be using DBD::JDBC instead of DBD::Oracle, aren't I? Hey, I was working on this at 1:00 AM this morning... Never mind... Thanks, Jared! :) Ric

RE: Creating sequences on the DUAL table?

Title: RE: Creating sequences on the DUAL table? Sequences are DB objects independent of any tables including dual (not possible to create a sequence "on" a table.  Sequences are sometimes used to populate the PK of a table, but the actual sequence and the table are not structurally related. 

RE: DB/APPlication?

Title: RE: DB/APPlication? Seema, That's part of the tnsnames.ora which the client needs to connect to the database. Check out the alert.log file and look for any trace files for the reason the DB crashed. -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: Creating sequences on the DUAL table?

Sounds like your developer hangs out with some of our developers! ;) I am sorry to say but, I guess the syntax "...from dual" could be confusing to the developer. Your understanding is just fine. Don't do anything with dual.. May be briefly explaining to the developer how sequence number w

Re: Slightly OT: Chart generation tool for db monitoring scripts

Think about how you will roll the trend data up over time. That is usually the real killer task. That is why you got people talking mrtg, because it is the poor man's solution to that problem. At least it is one wheel that has already been invented at the right price. The snapshots you are ma

RE: Creating sequences on the DUAL table?

Communication gap and ignorance. The developers proably want to create new sequences. And they are used to writing queries as "Select sequencename.nextval from dual;" So they call it sequences on the dual table.

RE: Creating sequences on the DUAL table?

Cherie, My first response is 'WHY?'. Do they mean that they want to create 2 new sequences and use the DUAL table to retrieve the values? It will cause performance problems and there are better solutions. I have some information on the performance implications of DUAL at http://www.optimal

RE: Creating sequences on the DUAL table?

Title: RE: Creating sequences on the DUAL table? answer below > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > I have a request from one of our developers to create two new > sequences on > the DUAL table. > > This seems like a bad idea to me.   I've n

RE: Space Contention and LOG_BUFFER size

I can't find it in the docs either. Info at ixora.com suggests setting LOG_BUFFER to a multiple of the log block size. http://www.ixora.com.au/tips/tuning/log_buffer_size.htm This next link explains what a log block size is: http://www.ixora.com.au/notes/log_block_size.htm Have fun! Ed -Or

RE: Creating sequences on the DUAL table?

H? Sequences are not created "on" the dual table. Sequences exist as independent entities. Ofttimes, sequence values are selected using the dual table (e.g., select seqname.nextval from dual) -- this is a coding choice. Performance of queries that select from the dual table are generall

RE: Foxbase to Oracle

Visual FoxPro has an upsize wizard that can go directly to Oracle. It would still be a lot cheaper to keep it in FoxPro over the cost of Oracle. -Original Message- Sent: Tuesday, July 30, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Dennis: Foxbase was originally called 10

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

Title: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA I'd like to add another free gui thats kind of neat, DataBee DBATool utility. You can find it at http://www.databee.com -Rich -Original Message- From: Bill Pass [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30,

RE: Foxbase to Oracle

Dennis, While I hate doing this on an Oracle list, you might want to consider SAP DB considering your limited budget and requirements. The general product details are here: http://www.sapdb.org/ and you can request a free CD here: http://www.sapdb.org/sap_db_cd.htm. Quite impressive and under-ra

Re: JBDC thin driver

Make sure that it is in your class path aswell.   Alex <[EMAIL PROTECTED]> wrote: just put the zip file on your pathOn Tue, 30 Jul 2002, Daniel Wisser wrote:> hi!>> anyone knows an answer to this:>> i want to user JDBC thin driver. i can install it from the> CD on windows using the manually config

RE: Install Oracle 8i on Windows XP?

> My assumption is that (everything else equal) *nix on a PC > server is a superior technology, more performant, more stable. > > Unfortunately one has to know a lot more low level tech stuff > to get into the *nix game than is the case with windows, and > therefore *nix on a PC will remain to

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

If anyone can... he might be able to. -Original Message- Sent: Tuesday, July 30, 2002 12:34 PM To: Multiple recipients of list ORACLE-L I fit that category as well. I talked to him last night he's gonna try :) --- [EMAIL PROTECTED] wrote: > > ...hardcore DBAs might never use GUI

Re: Space Contention and LOG_BUFFER size

More than the number of time you are waiting for 'redo log space requests' its more important to find out how long you are waiting for that. 27 times out of a million might not be a big deal for you to tune. having said that, here is a posting by Steve Adams on this topic "Q : Every day our pro

db comparison site

FYI, While looking for db comparisons I found a site that has a few: http://www.itsystems.lv/gints/compare_db.htm Note that it is located in Latvia. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivi

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

The functionality for Server Manager command-line was migrated in it's entirety into SQL*Plus (near as I can tell, including ORADEBUG), so Oracle eliminated svrmgrl not so much as a way of deprecating command-line utilities in general, but rather to consolidate redundant products... Except you

Creating sequences on the DUAL table?

I have a request from one of our developers to create two new sequences on the DUAL table. This seems like a bad idea to me. I've never had such a request in the past. I asked for clarification on why this is needed and I didn't get a lot of details yet. Is this something that is standard o

Re: How to use pipe-delimited SQL*Plus output with a long datatype

Thanks to those who recommended the relatively new set colsep command. It did work in this report. Thanks again, Cherie Machler Oracle DBA Gelco Information Network

Re: 11i installation ???

Leslie Lu wrote: > > Hi all, > > I purchased the Oracle 11i Release 5 (with 11.5.6 > family packs) CD pack for Windows from Oracle online > store. > > My first installed (Win2000) run out of space, and I > cleaned the folders manually. When I got more space > and installed again, I got: > >

  1   2   >