If not distinct there's about 9900 records, there are some physical rw'
going on
but I've bumped sort area up to 2M.
-Original Message-
Sent: Monday, April 29, 2002 5:38 PM
To: Multiple recipients of list ORACLE-L
John,
If you don't use the DISTINCT, how many records are
JP and list,
My mail server detected a virus in the original message and deleted
it.
JP is your response to a valid message that you read?
Ron
ROR mô¿ôm
[EMAIL PROTECTED] 04/30/02 08:43AM
Use non-Windoze workstation!
JP
On Tue 30. April 2002 13:33, you wrote:
HELP
-Original
Hello Peter
A good source if the calls themselves.
After each call analyze the root cause and start checking for it.
This way you will be able in a short time to eliminate a lot of problems.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Curiously, as an ASP we've been contracted by some organizations for
just that reason. Someone in upper management decides that their
ability to enhance shareholder value is hindered by their current
business rules. So they mandate using our application with little or
no customization, driving
The volume was offline. Once it was back online, Oracle resumed the
process of creating a tablespace.
Which brings up another question...why did Oracle wait on this condition
instead of terminating with an error? If afile-system directory/drive
cannot be found, the attempt to create a
You have a point Chris, but pl/sql is nowhere near as complex as an OO
language like java or C++, IMHO. I agree with Tom that pl/sql can be
learned fairly easily in comparison to the many other choices out there.
However, it takes a bit of database savvy to do it correctly. (Not much
tho)
I
Thanks to Dennis, I found that partitioning on a concatenated key solves my
dilema.
For those who are interested, here is my new partitioning clause:
PARTITION BY RANGE (invoice_state, update_date) (
PARTITION inv_active VALUES LESS THAN
('B', TO_DATE('01-jan-',
snif! Gee, thanks all! hok! snif OK, I'm better now... grin!
On the idea that Mogens started...
How about an ORACLE-L conference on a cruise ship? I had a beer or two with
Suzy on a cruise from Vancouver to Alaska on a woefully under-attended Geek
Cruise (www.geekcruises.com) last summer.
I had the pleasure of meeting some of the oracle-l list members during the
recent IOUG in San Diego.
I also brought my family with me to San Diego, to combine my business with
their pleasure. The IOUG (rightly perhaps) did not cater for any
family-related events (although the Big Bash may have
If a wait-event (i.e. FILE IDENTIFY) was posted,
then Oracle was undoubtedly making a system call such as "open()" or "fstat()"
or something. If those system calls "hang" when the device file exists but
the underlying device is offline, then there is nothing Oracle can do about
it...
It
Hi all:
There have been a few threads here dealing with
calculating percentages e.g:
Group Number Percent
1 10 10%
2 10 10%
4 70 70%
9 10 10%
I'm also sure I saw articles on how to create a report
like this via Oracle, but I couldn't find one when I
I wrote something more substantial up on
this a few months ago, but can't easily find it right now. So, I'll just
cut-and-paste a blurb I found:
"DIANA (Descriptive Intermediate Attributed Notation for Ada), is a
high-level tree-structured intermediate language that provides communication
ORACLE-L Digest -- Volume 2002, Number 120
--
From: Steven Lembark [EMAIL PROTECTED]
Date: Mon, 29 Apr 2002 09:30:40 -0500
Subject: RE: How Oracle screwed California
-- Boivin, Patrice J [EMAIL PROTECTED]
I don't know if Microsoft negotiates -- do they
I'd guess the optimizer is applying transitivity
to use your constant against all three tables
at the optimise stage, and something about the
specific value is fooling it.
What are the low_value and high_value
columns in user_tab_columns for the
three columns in the WHERE clause ?
Is EV000154
I have opened a TAR with Oracle and am waiting a resolution. In the meantime,
I am wondering if anybody else has any ideas while I wait.
Specifics:
IBM AIX 4.3
Rdms 8.1.7.3
Database ~75g
OLTP database with approximately 500 dedicated connections and 500 shared
connections with
Daniel,
It is not Oracle decision to wait. Basically the file identity means
that Oracle will open the file and read the first block to find the name
of the file and the size of the file. So two system calls are done. The
driver for the file that you will make the decision to return an error.
Hello List,
Maybe, some of you will not be agree with me, But, I think centralization will
occur.
Let's imagine that There is no banking system in the world and everyone keeps their
money at home. And, someone claims that there will be banks and people will give
money to banks. In this case, we
You can see process threads in NT Performance Monitor.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 8:28 AM
Do you know how to see the threads in NT?
Yechiel Adar
Mehish
-
Mark,
we have been using the Active tools for some time
and are kind of entrenched, particularly for
comparing, designing and auditing:
Active Compare
http://www.iraje.com/compare-diff.htm
Choices: TOAD, DBDiff, and Scripts?
Why do we use ActiveCompare?:
- we like the diff presentation as
TORA also runs under Windows...
I tried it, much preferred TOAD.
-Original Message-
From: Joe Testa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: good pl/sql coding/debugging tool?
give up windoze, go to
Sometimes they appear and disappear so quickly that tracking them is akin to
particle physics! According to the pundits, every new technology is the one
that is going to revolutionize the industry. ;-)
A few from Oracle - OPO (Oracle Power Objects), ODP (Oracle Developer
Programme), CDE, OPS
The database hangs, and no user is able to connect to the instance, except
locally through srvmgrl. Even within svrmgrl, we are unable to select
anything from the
database without the query hanging. However, we can abort the instance
(shutdown abort) and start it up again just fine. This
Hi friends,
Iam exporting some of tables, but keep getting error!! Could you help.. Mine
is AIX415 with oracle4.3, If I want import an individual table, what is
correct form of parameters?
exp user/passwd tables = \ ( table1, tab2, tab3,
If your database is in archivelog mode,is your archive_log_dest full? This
will stop the database dead until you remedy the situation.
Just my $0.02,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 3:21 PM
I have
An dangerous bug has been reported in Oracle lastest
database which is supposed to be 'Unbreakable'.
See
http://www.dbresources.com/modules.php?name=Newsfile=articlesid=94
for details.
Oracle9i Database Server could allow a remote attacker
with limited database privileges could create a SQL
any idea on the pricing for these tools? I dont see a price on any of these
sites.
Ray
Mark Leith [EMAIL PROTECTED]
Reply-To :
[EMAIL PROTECTED]
To : Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject :
RE: ERD generation tool
Date :
Tue, 30 Apr 2002 06:03:36 -0800
ERWin
consider using qslice, or an alternative?:
http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/qslice-o.asp
-
http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/pstat-o.asp
---
http://www.win2000mag.com/Articles/Index.cfm?ArticleID=3023
...
| Process
An dangerous bug has been reported in Oracle lastest
database which is supposed to be 'Unbreakable'.
See
http://www.dbresources.com/modules.php?name=Newsfile=articlesid=94
for details.
Oracle9i Database Server could allow a remote attacker
with limited database privileges could create a SQL
Hi,
Please take system states dumps every 5 seconds withing 20-30 seconds.
Let's read what's happening or not happening ?
Also,
You can upload your HANGANALYZE trace files to iOraHangAnalyzer.
It's free.
regards...
Tracy Rahmlow wrote:
I have opened a TAR with Oracle and am waiting a
resolution.
Well, it was the answer on Dave's email.
Every day I get about 3-4 emails from servers without antivirus and from
users without basic knowledge of don't click on all attachments in your
emails.
I removed all Microsoft OS from computers in our company 3 years ago.
So, I only laugh reading news
Cruise sounds like an idea, out of Miami :) 3 day cruise to bahamas is not too
expensive.
[EMAIL PROTECTED] 04/30/02 02:43PM
I had the pleasure of meeting some of the oracle-l list members during the
recent IOUG in San Diego.
I also brought my family with me to San Diego, to combine my
Tracy,
You can start by using the query below to determine what
the sessions are actually waiting on:
select
s.username username,
e.event event,
s.sid,
e.p1text,
e.p1,
e.p2text,
e.p2,
e.wait_time,
e.seconds_in_wait,
e.state
from v$session s, v$session_wait e
where
Hi all,
I sort of come from an old school where you should normalize data where you
can (typically 3rd or 2nd) so that you get the efficiency of normalization
but not the difficulty of data extraction. Additionally, I always thought
that putting RI on tables was fairly important (prevention of
I'm not working on AIX,
but I use syntax
exp user/passwd tables=(TABLE1,TABLE2) ... etc.
Why do you use \( and \) ?
JP
On Tue 30. April 2002 21:38, you wrote:
Hi friends,
Iam exporting some of tables, but keep getting error!! Could you help..
Mine is AIX415 with oracle4.3, If I want
Yes, you can import any table from that export if your export dmp have it.
you can use following syntax
imp userid=abc/abc file=/dev/tape tables=(a,b,z) buffer=4096 fromuser=
abc touser= xyz commit=y
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Tracy - Two ideas:
On Metalink, get note 61552.1 Diagnosing Database Hanging Issues
I would try to run STATSPACK (or utlbstat/utlestat) while the
database is hanging. You can also run STATSPACK on a schedule.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
ERWin is about $3,500 for a single user license.
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 2:38 PM
any idea on the pricing for these tools? I dont see a price on any of these
sites.
Ray
Mark Leith
Hello ALL,
I am having a problem in dropping an un-used Materialized view and getting
the following error when I am trying to drop
ORA-07445: exception encountered: core dump [kkzmtab()+76] [SIGSEGV]
[Address not mapped to object] [588] [] []
I have found in metalink that it was a bug in
Raghu - I notice that your command string extends over several lines.
Perhaps you should consider putting your export parameters into a parameter
file. I can send you an example if that would help.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday,
are you a roland?
ORACLE-L Digest -- Volume 2002, Number 120
--
From: Ravindra B [EMAIL PROTECTED]
Date: Mon, 29 Apr 2002 13:37:28 -0700
Subject:
This is a multi-part message in MIME format.
--=_NextPart_000_0067_01C1EF83.01703690
Content-Type:
Where are you planning to have it?
-Original Message-
Sent: Tuesday, April 30, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
Cruise sounds like an idea, out of Miami :) 3 day cruise to bahamas is not too
expensive.
[EMAIL PROTECTED] 04/30/02 02:43PM
I had the pleasure of
If nothing works and when u know the database has frozen u can run the
following command
to take dump of the database so that u can send it to oracle for analyzing
or u can analyze it too.
As jared says keep querying the session_Wait u will defnetly bound to catch
the guy who might be causing the
Hi Jason,
This was reported two weeks ago on this list by Jonathan Lewis.
A patch has already been released.
John
[EMAIL PROTECTED] wrote:
An dangerous bug has been reported in Oracle lastest
database which is supposed to be 'Unbreakable'.
See
Raghu
Still do you want to send your export dmp to tape or on disk.
Much better to study Oracle Utilities Manual for complete understanding.
For short type exp (or imp) help=y enter on unix prompt and you will find
all options available with your oracle release.
To export on tape (for 7.3.4)
Mark,
The other tool we use is the ActiveAuditor/Warehouse
solution as described below:
ActiveAuditor/ActiveDataWarehouse
http://www.iraje.com/accbig.htm
Choices: informatica? DB Triggers?
Why use it?
- records DATA changes, just by a few clicks.
- Lets say you have an OLTP app.
An associate is running a 8.1.5 db and he came to me with a horror
story. I don't have specific info on the event, but it makes me wonder
about the concept.
All users off the db, coming down for a cold backup. He said some
extent owned by sys in TEMP ts was not released and so the db would
Meghraj Thakkar - Quest Oracle 9i on Windows NT/2000
http://www.oracle.com/pls/oow/oow_user.show_public?p_event=6p_type=sessionp_id=11958
-
Whitepaper:
http://www.oracle.com/pls/oow/oow_user.download?p_event_id=6p_file=W11958.zip
(expands to 105.doc)
| Some parts of this paper have
Hi,
I am unable to query from the database when it hangs up. I am only able to
execute the shutdown abort command.
To:[EMAIL PROTECTED]
cc:Tracy Rahmlow@AMEX
Tracy,
You can start by using the query below to determine what
the sessions are actually waiting on:
select
Title: RE: Problem in Dropping a MV : ORA-07445: exception encountered: co
Try to drop the materialized view log first. Also are you dropping the materialized view as the object owner?
-Original Message-
From: Reddy, Madhusudana [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30,
Lisa,
Before you go about abandoning the entire phylosophy of database modeling,
let me say this:
This 2 table (actually 3 table), meta-modeling is not the wave of the
future. It could be the wave of the past. In fact, Oracle designer was
like this, with just 2 tables SDD_ELEMENTS and
Title: RE: Oracle wants your job
You are correct about one thing - some of us will not agree with you especially about centralized information and democracy.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From:
Hi All -
I am in the process of developing a PL/SQL procedure to monitor all
production databases and run into a road block:
The PL/SQL procedure is supposed to run my monitoring sql scripts and use
the UTL_SMTP package to send the output ( list of invalid objects, near
extent limits etc ) to the
Hi,
It has been confirmed that we are not running out of space due to the archiver.
To:Tracy Rahmlow@AMEX
cc:
My initial stab in the dark is that if this DB is in archive mode,
that the archiver process could be halting additional transactions
due to lack of space in the archive
Tracy what do the Sys Admin staff say. How long since the last reboot of the
server, has there been any kernel changes recently, any rogue processes?
I always try and think away from Oracle initially and get other people
involved as well.
It is easy to assume it is just an Oracle issue (which it
did you try: drop snapshot .?
Waleed
-Original Message-
Sent: Tuesday, April 30, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
Hello ALL,
I am having a problem in dropping an un-used Materialized view and getting
the following error when I am trying to drop
Hi listers,
Can someone tell me how import tables from SQLServer
to Oracle.
Thanks for your help,
Ben
__
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ:
Tracy,
How is the CPU and memory usage on the server when the database hangs? It's
likely that database might be experiencing severe latch contention,
preventing you from running any queries. To diagnose the problem, you should
look at the Oracle Wait events statistics periodically before
Lisa - not sure i follow the specific example, but i say RI is still a
wonderful feature of an RDBMS and should not be thrown out. Many package
apps have not implemented RI because they run on many RDBMS platforms, and
each handles RI differently. So put the RI in the app they say - right!
Not
Don't forget to turn #%^%#@#$% cookies on in your browser. The site won't
work without them and is too stupid to tell when they're off.
Where's the Cookie Monster when you need him?
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech
Lisa,
Care to reveal the consultant and the title of his/her book? There are many
prophets out there who claim to have the key to the future. In reality it is
their pipe dream that they are trying to pass off as gospel when in fact it is
bull dung. As for an application handling all data
Check to see if old dedicated processes are still hanging at the unix level.
I had those happened to me and we had to kill them manually. I mean old is
one day or few hours old.
What's the size of the memory? What's the size of SGA?
-Original Message-
Sent: Tuesday, April 30, 2002
Hello Folks,
I was teaching DBA stuff to a newbie, and I had him play with an Oracle
7.3.4 instance on an old HP box. I was teaching him about oradebug, ipcs
and how to associate shared memory segments with an Oracle Instance. After
some time, he came back and said there were 2 Oracle instances
Hi
This could happen if you have Oracle installed twice on the box.
The same SID could be started up from each of the binaries.
Ben
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L
Hello Folks,
I was teaching DBA
I had a similar problem on a Unix box where I had once had a 9i test
instance installed as well as an 8i instance. I was unable to install 8.1.7
for an upgrade while I had 9i installed.
The problem was in the oraInventory entries. No matter how many times I
uninstalled 9i it left a record that
Depending on the OS, one could maybe trace the call made by Oracle's OSD-layer
to the OS (I can't remember the name of the trace facility in Solaris, but
it's also sort of available now in AIX version 5 and there are similar freeware
things available for HP/UX and other OS'es).
Tim Gorman
Raj - I believe I've seen this sometime ago. It is like a set of processes
have no connection like normal. You'll probably have to kill those processes
manually before you restart the instance.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April
Hmmm... I would seriously consider it also. I like the idea of a halfway
deal - Iceland and/or Greenland, but I actually like colder climates (I
thought the San Diego weather for the IOUG-A conference was fine)!
If nothing else, perhaps a long ORACLE-L round table at the next IOUG-A Live
to
If this concept is so simple (simplistic?),
why does it take a whole book to elaborate on it?
Lisa R. Clary wrote:
[...snip...]
Recently, a consultant who has published a book about
SQL is now telling me that there is a better model--that of value pair
combinations (e.g. variable, value) to
I've seen this happen in the following circumstance:
Log in as oracle owner. svrmgrl - startup - exit.
Log out. The instance is running.
Now log in as another user who is a member of the dba
group. svrmgrl - startup - exit. Do a ps -ef.
You will see two instances running.
Been there.
Easiest and no-brain way is to use MS Export/import wizard in MS SQL
Enterprise Manager.
JP
On Tue 30. April 2002 23:16, you wrote:
Hi listers,
Can someone tell me how import tables from SQLServer
to Oracle.
Thanks for your help,
Ben
__
Too funny!
The first problem that comes to mind is duhvelopers:
There are a lot of developers that would simply be incapable
of dealing with Meta Data for every day queries. We tried to
use some very flexible meta data in a DW, and it turned out
to be too hard for the developers to grasp, many
hi gurus,
This is unix question but hope someone got the answer
I ran df -k yesterday on my oracle directories.
/oradata4 81%
/oradata3 77%
/oradata6 72%
( this not exact out put only inclueded mount on ,capacity)
I removed some files from /oradata4 and added some files to /oradata4
"truss" on Solaris and AIX, "tusc" on HP-UX, and
"strace" on Linux...
- Original Message -
From:
Mogens Nørgaard
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, April 30, 2002 4:10
PM
Subject: Re: FILE IDENTIFY wait
event
Depending on the OS, one
Yes I did.
I am getting end of comunication channel error and then ORA-07445 in
alert.log
Any Idea ???
--Madhu
-Original Message-
Sent: Tuesday, April 30, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L
encountered:
did you try: drop snapshot .?
Waleed
-Original
and, pricing for ActiveDesigner (2001 dec. prices)
Active D'lite approx: 995/- to the ActiveDesigner
enterprise approx: 6,995/- (there are some
intermediate points, dont have that info.)
Keith
Date: Tue, 30 Apr 2002 12:13:56 -0800
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Did you try: sync before df -k
Waleed
-Original Message-
Sent: Tuesday, April 30, 2002 6:50 PM
To: Multiple recipients of list ORACLE-L
hi gurus,
This is unix question but hope someone got the answer
I ran df -k yesterday on my oracle directories.
/oradata4 81%
/oradata3 77%
Basing it on my Solaris experience the \ is a control character so the
system will treat the ( and ) as part of the export command. But doesn't it
need to be immediate before the ( and )? I.e., \( instead of \ (?
What is the error you're getting?
-Original Message-
Sent: Tuesday,
If any of the files were being accessed when you removed them they won't
show up in an ls command but will still occupy space (and not actually be
deleted) until they are no longer being accessed.
For example, if you rm all your data files while the database is running the
space will not be
It is possible that some process was attached to those files and until
that process released those files it wouldn't release the space, Also Unix
will take its own time to actually clean up a delete. It will delete the
inode reference from the directory listing but can take some time to
Also Have a look around TechRepublic http://www.techrepublic.com. They
usually have articles about things like this and may even have some
templates that you can use as a guide to get started. There approach would
be very IT generalist
Cheers
--
Just run like this. It will ask for password. Assuming you are running it
manually.
Make sure you have ORACLE_SID set correctly.
exp user FULL=N tables = ( table1, tab2, tab3,
tab40,tab5,ttdsls051061,ttdsls051110,ttdsls051120,ttdsls051130,
Does Oracle 4.3 have export utility?
-Original Message-
Sent: Tuesday, April 30, 2002 3:39 PM
To: Multiple recipients of list ORACLE-L
Hi friends,
Iam exporting some of tables, but keep getting error!! Could you help.. Mine
is AIX415 with oracle4.3, If I want import an individual
ORACLE_HOME + ORACLE_SID together uniquely identify an instance.
Anjo.
Vergara, Michael (TEM) wrote:
I've seen this happen in the following circumstance:
Log in as oracle owner. svrmgrl - startup - exit.
Log out. The instance is running.
Now log in as another user who is a member of
Hit http://www.pugcentral.org/howto/truss.htm
for a complete description of truss and a listing of where you can obtain it
for several different OS brands.
Cary Millsap
Hotsos Enterprises, Ltd.
[EMAIL PROTECTED]
http://www.hotsos.com
-Original Message-
From: [EMAIL
Hi,
Sorry but this situation is specific to a particular application ... so
don't read past this line if you don't know what NNM (Network Node Manager)
is.
We're using NNM 6.2 with the default solid db for trend data, event data,
topology etc. They have now decided that it is about time we
Hi
I suggest you go to www.itrc.hp.com and study up there. Your sysadmin
will have a full login that you can use to access all of the secrets. The
openview manager probably has one linked to the openview license.
I think only the management station will have a the oracle database. It is
Hi,
I have checked on ITRC. There are some things, but they don't really explain
much.
I thought as much that we couldn't have different Oracle instances on each
collector.
Have you done this before?? Did it go alright?
Regs
suji
-Original Message-
Sent: Wednesday, 1 May 2002 3:38
What's with the Service_name? vs. SID?
On Tuesday 30 April 2002 18:03, you wrote:
ORACLE_HOME + ORACLE_SID together uniquely identify an instance.
Anjo.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
INET: [EMAIL PROTECTED]
Fat City Network Services--
101 - 188 of 188 matches
Mail list logo