Title: RE: Database/system Crashing
Sorry
for getting back to you late on this. In our case, the server crashes each
time with CPU panic message
in
/var/adm/messages. We used adb to analyze the core dump and saw in each
instance of the crash, NFS
lead
to it. It was trying to free memory
Were you analyzing while rebuilding Indexes ?
If that is the case.. there are chances of possible corruption.
Try to give
select count(*) from table_name;
and
select * from table_name;
Hope this may provide you with some answer.
HTH
- Original Message -
To: "Multiple recipients of li
BTW rajesh, where can I find 'ORA_ENCRYPT_LOGIN variable and
DBLINK_ENCRYPT_LOGIN parameter (for retried attempts across database
link)' ? Pls respond ...
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, January 07, 2003 10:02 PM
>
Gee Dave, I know of a book that has scripts that
already do this. ;)
Here's an untested bit of code to demonstrate.
my $dbh;
eval {
local $SIG{ALRM} = sub {
die "connection timeout\n";
};
alarm 60;
$dbh = DBI->connect(
'dbi:Oracle:' . $db,
$user
Since 9iR2 is 9.2.0, I don't think that 9.0.3 will be Release 3.
Jared
On Monday 13 January 2003 18:23, Boivin, Patrice J wrote:
> Oracle started posting items with the 9.0.3. number, does this imply they
> plan to release a 9i Release 3?
>
> regards,
> Patrice Boivin
> Systems Analyst (Oracle C
doubtful, they've said that release 2 is the final release for 9i
--- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote:
> Oracle started posting items with the 9.0.3. number, does this imply
> they
> plan to release a 9i Release 3?
>
> regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified
Yes, well, I've heard that claim too.
It may actually work now, but a very capable DBA ( 2 actually )
spent quite a bit of time testing this with no good results.
And then there was the SQL BT glitch that left one of my former
coworkers without a certain TBS in the DW for 6 weeks.
Yes, 6 weeks.
Morgens is very correct in saying tha all sorts of measurements have their
place. Actually, the length-of-skirt measurement works very well for me.
Here is the algorithm:
Heat-by-day in inversely proportional to length of skirt which again is
inversely proportional to my desire to have lunch ou
Here is my suggestion:
1.
Use file= and filesize= option (8i Rel 2?) to create multiple disk files, copy them
to tape. Reload when importing.
2a.
Export should not be considered a database backup. (IMHO). In future releases,
full=y may not be available.
2b.
Depends. If export starts a
SQLBackTrack does not have 'block' recovery, something I think is in the latest RMAN
version (?).
I don't use either of these, but just remember a few things from demos, written
material.
- Kirti
-Original Message-
Sent: Monday, January 13, 2003 6:00 PM
To: Multiple recipients of list
Ethan,
Here is one my 'dist' scripts.
This sends files from HP Server to Sun Servers.
Check that last couple of lines.
HTH,
- Kirti
#
# File Name: dist_all_to_SUN.rdist
#
# This is the distfile for 'rdist' to distribut
I think SQLBackTrack can get the table data back from the backup file without the need
to create a partial database on another server and then export the table from it.
I remember seeing a demo where a dropped table was recovered by the BMC rep.
- Kirti
-Original Message-
Sent: Monda
Title: Internet file system
Oracle
started posting items with the 9.0.3. number, does this imply they plan to
release a 9i Release 3?
regards,
Patrice Boivin Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et
Exploit. des systèmes Technology
Services | S
Title: RE: RE : RMAN Repository
I do
have one scenario where you really have to use a recovery catalog... When
attempting to backup a VLDB that uses read only tablespaces and extremely
infrequent backups for most of the data (i.e. a large datawarehouse), a recovery
catalog is very important
Thank you all for your help.
I will have to review the metalink data as you suggested.
We have asked that they Bind their SQL Statement but where given no patch
date so it looks like we are out in the cold for awhile.
Once again thanks for all your help.
Jay
- Original Message -
To: "Mult
And/or get Bjorn Engsigs article (I think it's on MiracleAS.dk under
Technical Information - called cursor.pdf) about some interesting
results regarding cursor sharing.
Mogens
Cary Millsap wrote:
CURSOR_SHARING won't reduce the "parse count (total)" count; only
eliminating parse calls from you
I think Dick is on the right track...
If you have a list of accounts which require an update, load that list into
the database - if it isn't already in the database (please don't tell me
you are creating the script from within Oracle - please don't tell me
that). You could load this list either a
Time to check what? If it goes down it could be because your statement(s)
were optimized to use less resources (as documented so well). If it goes
up it could be because your statements became more or less efficient. And
you'd have to check if it was because of an index, a table, a sql statemen
Something here doesn't compute. If you tried to use time-based measurements
and didn't find out where the time went - well, bad for you. If you then
stumbled on something, say the database startup/database shutdown ratio (would
normally be fairly close to 1, but could vary) or the log file swit
Listers,
How can one use parallelism when fast refreshing a *single* table?
Pulling my hair out on this one. We want to use parallelism when replicating
updates/inserts from a single partitioned table between DB's -- partitioned
on both DB's. Both are 8.1.7.4 Solaris 8 64 bit. Using fast refresh
SQL BackTrack is a BMC product.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!
-Original Message-
Sent: Monday, January 13, 2003 4:35 PM
To:
Some of our data is stored in Oracle databases dedicated to Peoplesoft. We have other
databases which require a subset of this information. These other databases are not
all on the same machine. They are either directly tied to physics experiments or they
are subject to certification requirem
Yes, but I think less capable than RMAN.
Just do a google search for it. Owned by BMC I believe.
Jared
On Monday 13 January 2003 14:34, VIVEK_SHARMA wrote:
> Is SQL BackTrack a product like RMAN (from Oracle Corp. or 3rd party )?
>
>
> -Original Message-
> Sent: Tuesday, January 14, 20
RMAN Does everything that SQL Backtrack does, for free. :-)
In fact, last I heard, BMC was planning on altering SQL Backtrack so that it
is really nothing more than a nice fancy front end to RMAN. When I was
at CSX we moved away from SQL Backtrack to RMAN and never had any regrets.
The only issue
Hi Govind,
Just a thought: The value of _small_table_threshold - which is currently 2%
of the DB_BLOCK_BUFFERS. Any table undergoing FTS will be placed at the MRU
end rather than the LRU end and would thus live longer (and either cause
problems or alleviate it as the case may be!). Keep this in m
CURSOR_SHARING won't reduce the "parse count (total)" count; only
eliminating parse calls from your application can do that. Using
CURSOR_SHARING will reduce the "parse count (hard)" count (and maybe
some shared pool latch contention), but at the expense of more user-mode
CPU consumed during each p
And of course to calculate you'll need to know your block size and your
extent size.
-Original Message-
Sent: Saturday, January 11, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
UNIFORM SIZE clause of Tablespace, if it is LMT.
--- Igor Neyman <[EMAIL PROTECTED]> wrote:
> INITIA
Does anyone have some perl code that will return an error if it take longer
than a certain number of seconds to connect to or return the results from a
database? I'd like to have some of my queries connect to an alternate database
if there is a problem connecting or returning results within 10 seco
In fact, in 8.1.7.2, it can cause *incorrect* results in certain queries
without reporting an error! 8.1.7.4 is supposed to be a little more stable
(applying that minipack to production as this is typed), and 9iR2 is
reported to be even better.
For us, it was CS=F or die (dead server, die trying
Jay,
Take a look into using stored outlines. If the problem is with the vendor's
code not using bind variables, I don't know that this will help, but you may
find some instances where it might be useful.
I heard recently that a book should be written with just one chapter on bind
variables.C
1) Large Export Dumps , if Directly Exported to TAPE Devices , Can Import be safely
Done therefrom ?
FILE=
OR is it advisable to compress / Split the Export Dump Files onto Storage Box &
thereafter backup the Same onto Tape ?
2) With Oracle 8i & 9i
Does export backup fired at a certain Ti
The increase in performance of course comes from
sorting in memory and avoiding disk writes.
Try running this bit of SQL before and after your tests,
and record the numbers:
select
stat.sid,
name.name name,
stat.value
from v$sesstat stat, v$statname name, v$session sess
where
stat.si
I spoke with Matt and he is able to register / log in. As it usually
happens, he got it working right after he sent the email.
Take care,
-Ari Kaplan
-Original Message-
Andert
Sent: Monday, January 13, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L
I don't know if it's just you,
We're upgrading from Solaris 2.6 to Solaris 8 and 8.1.6 to 8.1.7 on one of
our boxes.
I want to know if it's possible to do the OS upgrade first and then the
database upgrade (e.g., I'd be running 8.1.6 on Solaris 8 for a day or so).
The Oracle certification matrix only says that 8.1.6 is desuppo
Curious, for which platform is 8.1.8 available? And *why*?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
> Sent: Mond
I *think* that RMAN does everything SQL Backtrack does.
Can't be positive, as I haven't used it for awhile.
RMAN seems to have everything I recall SQL BT having, and then some.
Jared
On Monday 13 January 2003 12:38, Tim Gorman wrote:
> Don't know really. Just thought that it should probably
rdist is a good way to keep files (sql, tools, tnsnames) synchronized
between servers, in my case I need to replicate
/db01/foo/* to /u01/foo/*
Going from /db01/foo to /db01/foo on a different server is easy but I can
not find any examples of going to another directory structure. The docs are
n
Is SQL BackTrack a product like RMAN (from Oracle Corp. or 3rd party )?
-Original Message-
Sent: Tuesday, January 14, 2003 2:09 AM
To: Multiple recipients of list ORACLE-L
Don't know really. Just thought that it should probably be included, then I
was hoping to find out... :-)
Title: RE: How to identify full table scans?
This
helps to identify the queries that could be tuned for LIO and/or PIO from a
SQL Tuning perspective. We can give this list to the development or
application teams so that they could independently work off this list
(hopefully!).
-Origi
Bill - Will you need to search for information that will be compressed? If
yes, then performance could be really, really bad.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 2:07 PM
To: Multiple recipients of list ORACLE-L
My colleagues call it CURSER_SHARING :)))
"Igor Neyman"
Hi Matt,
I registered last week without a problem, except they insisted on a credit
card number even tho I owed $0. Looking forward to seeing you again!
Ruth Gramolini
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 2:49 PM
We have not seen any performance gains after setting the sort_area_size in excess of
50Mb. We have set this as a
standard in our re-indexing scripts to set this to 50Mb maximum.
HTH.
-Original Message-
Sent: Monday, January 13, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L
Hi:
Mark,
About how many rows are we talking about? Just curious...
Log Miner might be a viable option. It comes with 8i but if the database in
question is v8.0.x then you can still read them from an 8i database. From
Log Miner you can extract the UNDO_SQL for the rows you want to delete.
If you
Don't know really. Just thought that it should probably be included, then I
was hoping to find out... :-)
- Original Message -
To: <[EMAIL PROTECTED]>; "Tim Gorman" <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 10:49 AM
> On Monday 13 January 2003 06:03, Tim Gorman wrote:
> > Anot
Yes, it is as of today...We are still having 7.3.4.5 for our Oracle
Financials 10.7 Application. This may be the last year for this version...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Mon, 13 Jan 2003 12:38:39 -0800
Tha
Jay - Here are the possibilities:
1. The vendor is stupid. Or doesn't understand Oracle.
2. The product was incorrectly installed. Some products are sophisticated
enough to have a configurable interface, which may be misconfigured or need
tuning over time.
3. You are missing a key piece o
I don't know if it's just you, but I'm ok. I just logged in and went to
the Live 2003 page without any problem.
Check with your network folks.
Stephen
>>> [EMAIL PROTECTED] 01/13/03 12:49PM >>>
Is anybody else having trouble with the www.ioug.org
web site. I can get to the home page, but ca
Success with using CURSOR_SHARING depends on your Oracle version.
In earlier versions it's buggy.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 3:00 PM
> Hello:
>
> I have a thi
David - No. This just ensures you don't use any "9i" only features.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 1:22 PM
To: Multiple recipients of list ORACLE-L
I was curious about this parameter
I have an appli
Thanks Rafiq. As I said, my 7.3.4 knowledge is too old by now (but man, was
that a great version).
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 1:22 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Here/ in this s
I wasn't. I actually am still trying to look at the varchar2. The downside
is the huge amount of data they want to keep in a compressed format hence
the RAW or BLOB format.
Regards,
Bill Burke
"The Kinder and Gentler DBA"
IOUG University Master Class Faculty 2001-2002
"iDBA Management, High Per
Hi:
Today I did some small testing on our db (Oracle 8173 on Solaris 2.8) to
test index rebuild (with nologging) performance vs sort_area_size. I used
"alter session set sort_area_size = " to set the sort_area_size value.
Nothing else was changed. The temp tablespace is 8G. There is no other
a
Hello:
I have a third party application which seems to have alot of unbound SQL
statements, several of which do not seem to be very effective queries.
Unfortunatelly the code is locked.
My Parse to execute ratio is around 72% and I was wondering if anyone has
any ideas on how I can decrease t
Title: ioug.org web site
Is anybody else having trouble with the www.ioug.org
web site. I can get to the home page, but cannot
log in, or register for IOUG-A Live.
Is it just me?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to ki
Daniel,
After some of the younger folks in the audience have had a say, Let's let
the "old fart" have one.
While on the one hand I can see what your DBA is croaking on, I can also see
where you are too. Your approach is easy to code, but can wreck hell on the
database especially if each
Dennis,
Here/ in this senario '
'ANALYZE INDEX VALIDATE STRUCTURE' will not help or reveal anything except
to anlyze table with cascade structure which will reveal any index
corruption relating to that table. There was a bug in 7.3.4.3 where index
rebuilding with parallel clause was resulting i
> Keith Moore wrote:
>
> Has anyone else seen this or can you explain it?
>
> I have 7 tablespaces in USER_TABLESPACES that don't exist in
> DBA_TABLESPACES. These have been dropped, but somehow did not
> disappear from USER_TABLESPACES. They have a status of INVALID.
>
> The database is version
I was curious about this parameter
I have an application that is certified on
8.1.7 only
Could I create a 9i database set compatible
to 8.1.7 and essentially call it an 8.1.7 database?
-Original Message-
From: Ehresmann, David
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January
Title: RE: How to identify full table scans?
Govind,
Just curious why you are attacking the full table scans. I implemented something like this in the past utilizing Steve Adams' script expensive_sql.sql. It was very telling and very very useful.
Lisa Koivu
Oracle Database Administrator
system is data
dictionary - the rest lmt's with uniform extents>>>
[EMAIL PROTECTED] 01/13/03 12:35PM >>>
Were you using any of the new tablespace
features or using dictionary managed tablespaces?
David Ehresmann
-Original Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: M
Has anyone else seen this or can you explain
it?
I have 7 tablespaces in USER_TABLESPACES that don't
exist in DBA_TABLESPACES. These have been dropped, but somehow did not disappear
from USER_TABLESPACES. They have a status of INVALID.
The database is version 8.0.5 (Yeah, I know, we'll
b
List,
We use the following script to identify recent full table scans or full index scans.
This result set will be used to identify the potential queries that could benefit by
creating any new indexes or modify the existing index structure as needed.
Our intention is to run this query against
We are running 9.2.0.1., do you think that
could be the reason. the .1=component specifiec Release
Number? Was your 9i 9.2.0.0.0?
David Ehresmann.
-Original Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 13,
2003 11:41 AMTo: Multiple recipients of
Were you using any of the new tablespace
features or using dictionary managed tablespaces?
David Ehresmann
-Original Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 13,
2003 11:41 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: compatible in 9i
Title: RE: compatible in 9iRel2
Curious minds want to know what bugs you are trying to fix ??
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't re
:)
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
- 2003 Hotsos Symposium, Feb 9-12 Dallas
-Original Message-
Still
Sent: Monday, January 13, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
Woah--free code! A thousand thanks--this looks really close to what I'd
like to do. If I can wrestle some extra privs on our test db I'll report
back as to whether I was able to get this going on 8.1.6.
Thanks also to Lisa & Thomas for responding.
Cheers,
-Roy
Roy Pardee
Programmer/Analyst
SW
Even with this little bit of information, it's obvious your DBA
is on the right track.
Any script that loops and executes 'hundred thousands of
sequential update statements' is total nonsense.
This will bring most any database to it's knees in a hurry.
Oh yes, I've had developers pull this one
Daniel,
Your gut reaction is right on-target. It is always a struggle to keep
certain folks from killing the entire village while trying to cure a single
case of the sniffles. What's worse is that such folks are usually quite
bright and talented. After, very few mediocre folks can either cure t
You need to create the database with compatible set
to 8.1.7.0. You can't create a database at one version
and then lower the compatible level without downgrading
or recreating.
Jared
On Monday 13 January 2003 09:16, Ehresmann, David wrote:
> I am trying to apply a "fix" for some developers he
So, if I coerce the developers into writing better code that
does less logical IO, and the BCHR goes down, I should
then investigate and fix the problem? ;)
Jared
On Monday 13 January 2003 08:09, Yechiel Adar wrote:
> Hello All
>
> I saw that piece of code a few times and still think that even
Have you used parallel clause while rebuilding? What version of 7.3.4 ?
Check alert_SID.log for any possible index corruption
If any , then you have to check for table and all indexes on that. Find
index/es with multiple keys , save their defination through export , drop
those indexes and cr
In a nutshell, it is better to put your code
in a stored procedure outside of the trigger.
Why? Modular code is easier to reuse. You can't
reuse code blocks that are in a trigger. There are
other reasons, but this is the biggy IMO.
As Ferenc recommended, get the Feurstein book.
Jared
On Su
On Monday 13 January 2003 06:03, Tim Gorman wrote:
> Another question: should SQL BackTrack be included for consideration?
What does SQL BackTrack to that RMAN doesn't do?
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat
Though I'm not sure, I *believe* that in 7.3 indexes must
be taken offline during a rebuild.
That being the case, your users queries would not have
executed properly. i.e. FTS would take place for queries
that normally used indexed access.
Jared
On Monday 13 January 2003 08:14, Conrad Meertin
Andrey,
Perhaps you could tell us what paper, and where to obtain it.
>From the context, it sounds like a reference to physical modifications
rather than DML.
Jared
On Monday 13 January 2003 07:54, Andrey Bronfin wrote:
> Dear gurus !
> A ( maybe ) stupid question : I always thought that bitma
I had a 9.2/solaris database that I could set compatible 8.1.7 on - but
since I have done the 9.2.0.2. upgrade I can't set compatible below 9 either -
never really needed it so I haven't bothered with metalink/tar.
>>> [EMAIL PROTECTED] 01/13/03 11:16AM >>>I
am trying to apply a "fix" for som
Hi,
following metalink documents may help you.
Note:65080.1 Using SQL To Delete Duplicate Rows In A Table
PR:1015631.6 HOW TO SELECT DUPLICATE ROWS WITHOUT USING ROWID
PR:1004425.6 HOW TO FIND OR DELETE DUPLICATE ROWS IN TABLE
Murat
The Pocket Reference has been helpful to many people. The book appears
to be at least a handy summary of some relevant aspects of Oracle's
documentation. However, various colleagues have convinced me that there
are many statements in the book that you can disprove using careful
tests.
Cary Mills
I too think the BCHR has its place, as a problem indicator. It can tell me
theres something wrong with my database. Say, I have this database
performing well, the users are happy, the BHR is mostly at 90%, and now it
suddenly shoots down to 70%, or it suddenly increases to 98. Somethings
amiss. It
Title: RE: dw tool question
This is something I am currently dealing with.
We have two products here: Business Objects and BRIO. It depends on what kind of end-user you expect to support. The main difference I see between these two is that Business Objects can easily hide the metadata de
"How can you tell that you need more space in the buffer pool?"
...You can notice when this is true by observing summarized extended SQL
trace (event 10046) data. If the LIO count for a session is small, but
the PIO count is large, then you have the problem.
So, sure... Checking a session's BCHR
Hi List
Is there a tool for removing duplicate entries from a table - except that
the key field is not the same. I ran some data imports more than once and
was hoping someone could point me in the direction of a way to undo my
mistake.
Any help will be most appreciated
Thanks
Mark Warner
__
Conrad - I haven't used 7.3.4 in quite some time, so my knowledge is a
little rusty. If you search METALINK, you will find quite a few issues with
this command on various Oracle versions. I believe that the basic principle
is the same - Oracle builds a new index in the background, syncs up any
tabl
I am trying to apply a "fix" for some developers here. They used this fix
in 8 and 8i by changing the compatible parameter and running their sql
script. I just want to be able to tell them that they need to fix their
application now that we are using 9iRel2. I tried this morning and got the
ORA-
David - Try COMPATIBLE=8.1.0
See the following link (you may have to patch it back together)
http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96530/migcompa.htm#1
009871
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 200
Title: RE: 8.1.6: possible to set role in db's logon trigger?
Roy,
this is in 9202 ... check the custom code for hash joins ... it has been working fine for us for > 2 months ...
CREATE OR REPLACE TRIGGER "SYSTEM".DBT_USERS_LOGON
AFTER LOGON ON DATABASE
--
DECLARE
CURSOR cur_sess IS
SELECT
>hi!
>
>a DBA inteds to speed up a script that is looping
>and
>sending hundred thousands of sequential update
>statements like:
>
>UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n;
>
>he suggests copying the table to a file, change it
>and then
>load it into the DB again. i am strongly convinced
>
Daniel - Can you explain the two alternatives in a little more detail,
especially the difference between the two. What types of systems are
involved (Unix, Windows)? Thanks.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 1
Well, I just tried it on 8.1.8, and here is what I receive:
SVRMGR> !cat inittest816.ora
control_files = ("/oracle8/oradata/test816/control01.ctl",
"/oracle8/oradata/te)
SVRMGR> startup
ORACLE instance started.
Total System Global Area142688680 bytes
Fixed Size
To solve your first problem, correctly identifying the current session from
v$session, in your login trigger include:
client_info_str := 'SOME_LITTERAL_' || LTRIM(dbms_random.value,'.');
DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info_str);
Then you can:
SELECT program, user
>We have a new datawarehouse project. I didn't involve in this project at
>beginning. Right now, I was assigned to the group for picking a front
>end reporting tool. So far I know the manager prefer brio, cognos and
>business intelligent product.
>
>Does anyone familiar with those tools? Can you gi
Title: RE: 8.1.6: possible to set role in db's logon trigger?
Hi Roy,
Note 122230.1 will answer your first question about session id's.
Lisa Koivu
Oracle Dogbone Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message---
hi!
a DBA inteds to speed up a script that is looping and
sending hundred thousands of sequential update statements like:
UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n;
he suggests copying the table to a file, change it and then
load it into the DB again. i am strongly convinced that this
is
Has anyone ever seen a similar message to the following showing up in the
alert log and creating dump/trace files:
Mon Jan 13 09:45:22 2003
found dead shared server 'S000', pid = (9, 13)
Mon Jan 13 10:13:46 2003
Errors in file /u01/app/oracle/admin/ndi/bdump/ndi_s000_3556.trc:
ORA-07445: exception
ALTER ...REBUILD..
Thanks
COnrad..
-Original Message-
WILLIAMS
Sent: Monday, January 13, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
Conrad - What command did you use to re-index? Drop index / create index?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
It seems like I remember misspelling 'control_file' once and discorvering
that even it has a default. Of course with Oracle, it could depend on the
version, O/S, patch level, phase of the moon, etc.
Keith
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Hello Anjo
I just had a tuning session with Dov Hit, from ACS in Israel.
He used some of the scripts that you showed him 2 years ago when you did
some work for Amdocs.
Anyway, after doing some search on the waits, he checked the BCHR and found
out that this database has only 40%. That led us on fu
Hello All
I saw that piece of code a few times and still think that even if you can
bump up the BCHR it has it's place. How can you tell that you need more
space in the buffer pool? Bad BCHR is an indication that you need to check
this. It is also an indication that you do a lot of FTS or missing
1 - 100 of 125 matches
Mail list logo