Re: Windows vs. UNIX

Hi Roy, Hete it is:- hope it helps. rgds, raja -- On Mon, 30 Apr 2001 11:30:40 Raghu Kota wrote: Hi Roy There was whitepater on this, I forgot exact name, May be other members have it!! The paper name looks like ux-vs-nt!! I read once!! From: Roy Ferguson [EMAIL PROTECTED] Reply-To:

RE: ORA - 1008 error when trying to insert data into a table

Don't know about the Java code... ora- 1008 is normally encountered because of undefined global variable or missing grants on the concerned table.. Please check from your end... Thanks, Amar Kumar Padhi. -Original Message- Sent: Monday, April 30, 2001 2:41 PM To: Multiple recipients of

Oracle What savepoints are active for a given session?

HI PLEASE SEND ME ANSWER Question Title: Oracle What savepoints are active for a given session? Detailed Question: Does anybody know IF and HOW can I get a list of active savepoints for the current session? I need a native way, not solutions based on additional application-level housekeeping.

RE: ORA-07445

We had (and still have) a similar problem - ORA7445's ORA00600's. Do you have any invalid objects (pl/sql procedures/functions/packages or possibly views)? If so, recompile them. After a lot of head-scratching by us and OWS we tied it down to a problem with 'on-the-fly' recompilation of

Rollbacks

report.txt :- What Does the NEGATIVE ( -1 ) Value for field XACTS (below) mean ? SVRMGR Rem Waits_for_trans_tbl high implies you should add rollback segments. SVRMGR select * from stats$roll; UNDO_SEGMENTTRANS_TBL_GETS TRANS_TBL_WAITS UNDO_BYTES_WRITTEN SEGMENT_SIZE_BYTES XACTS

RE: Windows vs. UNIX

If you are taking social psychology as well, maybe you can write a paper to explain why marketing tactics actually work, I never understood that one. Why is using imagery and imparting moods more effective at selling than facts and a track record? Once you have finished that paper, please send

RE: Re[2]: RESOURCE role

Probably because too many people use them. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region,

RE: OFA and SAN - Why not group all db files on its own mount poi

Title: RE: OFA and SAN - Why not group all db files on its own mount point? Hi Mike, If you are running EMC hardware, there are several utilities you can use to determine if EMC's cache is performing up to par. There are also utilities to alleviate any i/o contention that may appear if the

RE: OFA and SAN - Why not group all db files on its own mount poi

Hi Lisa, Thanks for the response. The SAN is very new here. Our first test server is supposed to be hooked up to it this week. After that we start to play. I will look into the tuning software for EMC, however from the meetings I've been to, it looks like we'll (the DBA group) have little say

Advice on database development life cycle practices

Hello all, Again turning to the wisdom of the list. I'm looking for information on database developments and application development practices. You know the DBA vrs developer thing this list loves so much. Any good resources you know about that I can look into? Any good methodologies you

test

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

Re:Oracle client for the desktop/Win 2000. Need help with wh

Charles, 8.0.5 will work on Win2K, I've got it still installed and have no problems. BUT, if your DB is 8.1.x then you're loosing some features by not upgrading the client. As a for instance, the 8.0.5 SQL*Plus client will not support the execute immediate statememnt in PL/SQL. The 8.1.6

RE: Windows vs. UNIX

For all those in the UK - I am sat here wondering what in the world the IBM ads could do in the way of plugging the hole? For US/International: we have had a spate of IBM ads lately on British TV where it shows a board meeting of some sort where they are having a crisis (who's in charge of web

Re:RE: OFA and SAN - Why not group all db files on its own m

Mike, SAN or no SAN, IO can become a problem. We use the EMC solution as well and I can tell you that having too few channels into the storage array is worse than didicated disk systems. How does this affect your layout, depends on what you have for load balancing software on the server.

Re: NOLOGGING creates txns in redo/archive logs

This is normal. When a transaction is set to nologging, minimal redo is written because of Data Dictionary changes that are occurring. James --- [EMAIL PROTECTED] wrote: I have been testing logminer and noticed that when I alter a table to NOLOGGING, txns are still recorded in the

RE: Windows vs. UNIX

Presumably, its the 'nobody ever got sacked for buying IBM' line. Now IBM et al aren't going to spend huge amounts on these ads if they didn't think it was worthwhile. So, what gets me is the implication that company directors will buy IBM, not because they have hard evidence that they are

RE: not able to dump buffers

Thanks Steve, It was dumb of me not to see that. Thanks very much From: Steve Adams Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Subject: RE: not able to dump buffers Date: Sat, 28 Apr 2001 21:55:30 -0800 Hi Arun, You have requested a BUFFER dump, rather than a

OT -- marketing (was Windows vs. UNIX)

Another example, to illustrate. Those of you who have kids may identify with this one. Twenty or thirty years ago you could have asked a 5 year old to play the word-association game too: McDonald's - Ronald McDonald, Hamburgler, whatever. Now it's more likely to be: McDonald's - toy They

RE: Help - temp tablespace growing constantly

You probably already checked this, but if you have PCTINCREASE set to something other than 0 on the tablespace this might be contributing to the problem. What are the INITIAL, NEXT and PCTINCREASE settings? -Original Message- Sent: Monday, April 30, 2001 5:01 PM To: Multiple recipients

RE: Windows vs. UNIX

IBM is marketing themselves as a services company now. They are trying to change the way you perceive them, if you want you can play the word association game: sky - blue. cat - claws. dog - fur. HP - laserjet printers. bank - no money left. car - gas prices. oracle - databases. grocery

Somewhat OT: Blobs and Ordimage types

Title: Somewhat OT: Blobs and Ordimage types Hi - We have an application group that is interested in storing documents in the database. Some of these documents are word docs or excel spreadsheets, while others are actual image files. We have looked into the interMedia ordimage type, which

RE: Windows vs. UNIX

Title: RE: Windows vs. UNIX Well, here in the states, IBM stands for Ibuprofen, Beer and Margaritas. Marianne -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 7:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Windows vs.

RE: Windows vs. UNIX

At 03:55 AM 5/1/01 -0800, you wrote: If you are taking social psychology as well, maybe you can write a paper to explain why marketing tactics actually work, I never understood that one. You are making the mistake of assuming that we are primarily thinking beings. In fact, our intelligence is

Re: Could not Connect to 8.1.6

What is the error that you are getting ? Do you get a core dump? Are you using connect string to connect ? I have seen situations when connecting from 8.0.5 home doing a core dump(on HP-UX) when connecting to 8.1.5 which was a bug. JyotiGet Your Private, Free E-mail from MSN Hotmail at

RE: OT -- marketing (was Windows vs. UNIX)

Could you enlighten us over here in the UK as to what other non-beef burgers they have introduced (apart from the McRib which has been around intermittently for years now) since the , and I quote beef crises in the UK? Regards Lee -Original Message- Sent: 01 May 2001 15:51

Re: OT -- marketing (was Windows vs. UNIX)

IBM - HAL [EMAIL PROTECTED] 05/01/01 10:50AM Another example, to illustrate. Those of you who have kids may identify with this one. Twenty or thirty years ago you could have asked a 5 year old to play the word-association game too: McDonald's - Ronald McDonald, Hamburgler, whatever. Now

No listner and tns packet error

Hi I am facing one funny oracle failure. If i try to connect the client machine to linux oracle8i server I receive the error no listner. However when I see at linux server the listner is altready running.Again after sometime when I try to connect to oracle server I get same error for some time

Actual size of database

Hi All, Oracle 8.0.5 NT 4 Does anyone have a script they would share that can calculate the ACTUAL size of a database(space_used) not what has been allocated? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED]

Re: Actual size of database

set echo off set pagesize 60 @my_tabs spool sp_used rem Calculate Percent of Space Used in Each Table Space rem column tablespace_name format a20 column tablespace heading TSPACE_NAME column megs_alloc format 999,999.99 column megs_free format 999,999.99 column pct_used format 999.99 column

RE: OT -- marketing (was Windows vs. UNIX)

Actually, Lee, you should enlighten us. The last time I was in the U.K. for any length of time (1998) the McD's there had far more non-beef and even vegetarian options, which are only now catching on here. So what can we expect in the next few years from the enlightened McD's of Europe? Diana

Re: Actual size of database

Here is one that I use. I do not count the TEMP tablespace and the RBS tablespace because these vary in size. SELECT sum(bytes) DB_SIZE from dba_segments where tablespace_name not in ('RBS','TMP') You can do more math if you do not want the answer in bytes. Regards, Ruth - Original

OS bloack size and ORACLE BLOCK SIZE

Hi Everyone i'm trying to determine what my os block size is My DB's have an 8k block size and i thought for best performance my os block size should be the same. So i run the command df -g 8192 file system block size1024 fragment size is the result and i run the command

RE: Actual size of database

Below is the most complete tablespace script I have found. I think you will like it. set pagesize 80 linesize 100 feedback off column tablespace_name heading Tablespace format a19 column object_count heading 'Objects|(#)' format 90 column mb heading Mb format 9990 column sum(frags) heading

RE: OT -- marketing (was Windows vs. UNIX)

Does that apply to Oracle's complex, frequently nearly inpenetrable ever changing jargon related to product line/descriptions and marketing/pricing information, or just the technology? :) As far as the general topic of marketing effectiveness and/or failure, there used to be some sort of

RE: Windows vs. UNIX (you are so ready for B*LLSH*T marketing, *!NOT!*)

Well, if I remember details correctly, the subtext of one of the ads is actually quite revealing. A young CEO/CIO announces, at a company party on the deck of a large luxury yacht, that the company is doing well, actually made a profit (what a concept!), and had attracted $20 million in

Re: No listner and tns packet error

Did you include this database in your listener.ora file? Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 12:30 PM Hi I am facing one funny oracle failure. If i try to connect the client machine to linux

RE: OT -- marketing (was Windows vs. UNIX)

Eric, Judging from their recent press releases, I'd say it does NOT apply to their marketing information. Check for yourself, trying running some of their finest marketing prose through the Jargonator at http://www.jargonfreeweb.com. I just tried the press release titled Mykrolis Takes Oracle

RE: No listner and tns packet error

Title: RE: No listner and tns packet error If ping is Ok and listener is running, try using IP address in your tnsnames.ora instead of machine name. Rivaldi -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 3:10 PM To: Multiple

Uniquely Weird - duplicate rows

Hello all, 8.1.6.2 on HP/UX 11.0 Has anyone seen something like this before? I can't rebuild the primary key - the error is duplicate rows found. So I check the data (first listing) and see duplicate rows via fts. When I give it a hint to use the primary key it shows nothing. When I

SQL question

How would you take the same string /dir1/dir2/test/file.out, and return file.out. Assume you do not know where the last '/' is or how many there are. What I need is a reverse instr function. Find the last occurrance of '/', not the first. Can it be done in sqlplus??? -- Please see the

Re: OS bloack size and ORACLE BLOCK SIZE

The default block size is 8K with a fragment size of 1K i.e. files with size below 8K are allocated using 1K blocks increments and files larger than 8K are done in 8K increments except for the last block which may be a fragment. [EMAIL PROTECTED] 05/01/01 02:50PM Hi Everyone i'm trying to

RE: SQL question

Doh! Forgot about the extra parameters to instr (like the negative value for where to start searching!). Thanks anyway and sorry about the wasted bandwith. For those interested, here's the answer; select '/dir1/dir2/test/file.out' filenm, substr('/dir1/dir2/test/file.out',

Re: SQL question

my_string := substr(in_string,instr(in_string,'/',-1)+1); [EMAIL PROTECTED] 05/01/01 04:36PM How would you take the same string /dir1/dir2/test/file.out, and return file.out. Assume you do not know where the last '/' is or how many there are. What I need is a reverse instr function. Find

Re: OCP Discount code

It should be 'S36' . To verify visit htt://education.oracle.com Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 27 Apr 2001 09:36:20 -0800 Hi, Please let me know the OTN discount code used for taking OCP. Thanks Prakash --

RE: SQL question

SELECT SUBSTR( '/dir1/dir2/test/file.out' ,INSTR('/dir1/dir2/test/file.out','/', -1)+1) FROM dual HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is

differences between physical datafile and v$datafile

Dear Guru: When I query the physical file size oracle:ls -l users01.dbf -rw-r- 1 oracle dba 104865792 Apr 10 13:56 users01.dbf compare with the size I get from the v$datafile SQL select name, sum(bytes) from v$datafile where name like '%users%' group by name; NAME

RE: Actual size of database

Just to see dbsize in short Use this set pagesize 0 linesize 255 heading off feedback off SELECT 'The database size is '|| ( (df.sum + rd.sum) / ( 1024 * 1024) ) || 'Mbg excluding INI, password and control files' FROM (SELECT SUM(bytes) sum FROM sys.dba_data_files) df, (SELECT SUM(bytes *

RE: OT -- marketing (was Windows vs. UNIX)

Title: RE: OT -- marketing (was Windows vs. UNIX) Cute website, but sadly, it deemed my submission (below) to be level 1 - the best possible prose. Uh huh. Cross-optimized dung filters harmonize online interactions requiring deep instinct-based CRM, BPE, SOL, and DOA products with a

Re: SQL question

But of course -- just use a negative one as the position to the instr function. From the SQL manual: INSTR searches string for substring. position is an integer indicating the character of string where Oracle begins the search. If position is negative, Oracle counts and searches

RE: OT -- marketing (was Windows vs. UNIX)

I know, I was just being droll/sarcastic. Corporate-speak at Oracle is alive and well. I could tell you about some bizarre fellini-esque and karka-esque conversations I've had with Oracle account reps. You will be assimilated, resistance is futile (the Borg). In political/social theory

Re: NOLOGGING creates txns in redo/archive logs

Only nologging supported operations will not result in logging eg create index, direct load insert and other such operations... hth connor --- [EMAIL PROTECTED] wrote: I have been testing logminer and noticed that when I alter a table to NOLOGGING, txns are still recorded in the

Migration question

Does anyone out there know what the best method would be to migrate from Oracle 8.1.6 Enterprise Edition to Oracle 8.1.6 Standard Edition? It appears from the docs that the only way to migrate from Enterprise to Standard is to do an entire rebuild of the database. (Export, de-install,

Re: Help - temp tablespace growing constantly

You can claim back without rebouncing database by putting it offline and online at off-peak time... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 01 May 2001 06:36:05 -0800 If all of these segments are temporary then you can

Constraint dependencies

Title: Constraint dependencies Hi - When dropping and/or re-applying constraints for an entire schema, is there a dictionary table that can be queried (or some other way) to determine constraint dependencies - or do you just keep running the script until you do not get those errors? I would

RE: differences between physical datafile and v$datafile

Every Oracle tablespace uses one Oracle block of overhead for tablespace/datafile administrative information. -Original Message- Sent: Tuesday, May 01, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Dear Guru: When I query the physical file size oracle:ls -l users01.dbf

unix command question

what is the ls command to view only a list of directories? ls -la lists both files and directories...I want to view only a list of directories... environment is sun sparc solaris 2.6 thanks in advance roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy

Re: unix command question

what I would like to see is all directories...not files starting with a particular letter but all directories... ls -d - doesn't work ls -ld p* - doesn't work either Roy, You could do say ls -ld p* to list the directories starting with p. Rgds, raja -- On Tue, 01 May 2001 13:35:46

RE: unix command question

Title: RE: unix command question ls -l | grep ^d Rivaldi -Original Message- From: Roy Ferguson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Subject: unix command question what is the ls command to view only a list of

Re: RESOURCE role

On Monday 30 April 2001 20:55, Jacques Kilchoer wrote: Does anyone know how UNLIMITED TABLESPACE gets granted to the user along with the role RESOURCE ? I've made a half-hearted search for it in the past. I'm inclined to think that it's hardwired into the kernel, though I have no proof for