Title: SQL question : How to retrieve the File_name without Directorie Path ?
Hi Gurus!
a very simple problem for You :I just want to retrieve the .dbf name from file_name column in dba_data_files.
eg :'/oracle/d0/data/user.dbf' -- user.dbf
Maybe using translate function ?
Thank in advance !
Hi Philippe,
eat this:
select substr('/oracle/d0/data/user.dbf',instr('/oracle/d0/data/user.dbf','/',-1)+1)
from dual;
hth,
Guido
[EMAIL PROTECTED] 23.07.2003 09.59 Uhr
Hi Gurus!
a very simple problem for You :I just want to retrieve the .dbf name from
file_name column in dba_data_files.
Hi,
One thing that you will note about 9iAS is that it has a HUGE install
footprint when compared to Weblogic and JBoss. Weblogic and JBoss
are relatively simple to get going, ie. less configuration.
Cheers,
Craig.
At 07:54 PM 22/07/2003 -0800, Ryan wrote:
I havent dug into 9iAS yet, but I
want
Any Interest?
The DBMS_JOB package is supplied by Oracle to allow the running of
procedures at regular
intervals. Unfortunately the INTERVAL parameter is limited to 128
characters, which prevents
you from getting very complex (user defined functions [in the interval
parameter] do not
work well
I'll jump in here if I may.
There's another spotlight/DBXray type tool that we are starting to bring in
to the UK market place at the moment, that is being received *very* well.
The tool is called MGA Eagle Eye, which is developed over in Australia by
Mark Gurry's company (http://www.mga-it.com).
Hi,
We are investigating
possibilities for migration of an oracle 7.3.4 to oracle 9i. We want to
separate our
production DB from the app-logic such that we
can migrate from oracle 7.3.4 on hp-ux 10.20 to
oracle 9i
on hp-ux 11.
Problem is our development and test-environment because we
when configuring multiple buffer pools in oracle9i , how are lru_latches set.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
I'm not sure of the export compatibility, but you should know that 9i
clients won't talk to a 7.3.4 database, and 7.3.4 clients won't talk to a
9.2 database, which could be a problem. At least, they're not certified
to talk to each other, which isn't quite the same thing.
Cheers
Simon
eat this:
Is it chewable? -:)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Guido Konsolke
Sent: Wednesday, July 23, 2003 3:14 AM
To: Multiple recipients of list ORACLE-L
Hi Philippe,
eat this:
select
Hi,
when i try to start the oid server process, i get the following message in the oidctl.log
sgslunlListen: unable to bind endpoint (13)
Dispatcher controller: OiD LDAP server exiting..status:0
When i look with ps -ef | grep oid I see a defunct marked oid server process. So i
can´t connect to
Hi Igor,
yes, it is. But it would be better if we all
swallow the use of the builtin functions.
My weaknesses are with analytic functions.
I would give my colleague's right arm for
getting into them ;-))
Greetings,
Guido
[EMAIL PROTECTED] 23.07.2003 15.54 Uhr
eat this:
Is it chewable?
Jeroen
I haven't done this specific export/import. Hopefully someone who has
will respond. The usual prescription is to use the exp binary from the older
Oracle version to export the data. The layout of the data files changed
between Oracle 7 and Oracle 8, but did not change from 8 to 9, so
Not sure what exactly you are asking here but one way of sizing the multiple buffer
pools is to look at V$DB_CACHE_ADVICE view.
The following is from the 9i performance tuning manual
V$DB_CACHE_ADVICE can be used to size all pools configured on an instance. Make the
initial cache size
Title: RE: DBMS_JOB scheduling
Garry,
1. have you tried select to_char(sysdate,'D') from dual ??
This is really nice, but my only gripe with dbms-job is that is isn't reliable ... it wasn't in 9ir1 on aix and we didn't even look at it in 9ir2. in 9ir1 dbms_job used to _forget_ to run jobs
what functionality does 9iAS give you over just running apache?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 9:59 AM
Ryan
My impression is that 9iAS probably has the best database interface.
The
others look pretty
Phillipe,
Look at using INSTR and SUBSTR to calculate the position of the last / and
work from there.
Daniel
NGUYEN Philippe (Cetelem) wrote:
Hi Gurus!
a very simple problem for You :I just want to retrieve the .dbf name from file_name
column in dba_data_files.
eg
Title: Quick RMAN Verfication question
I believe you can setup an RMAN Recovery Catalog within a database on a UNIX platform, which will back up a DB on Win2k. But I've never set it up this way. So basically, my question is, Is anyone else doing this right now? how well does it work for you?
Title: RE: DBMS_JOB scheduling
Raj,
You must be speaking from UNIX
heights -J
Under Windows I find dbms_job much more
reliable than windows at scheduling.
Actually, never had problems with dbms_job
forgetting to run a job.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
Oracle9i 9.2.0.3.0, O7_DICTIONARY_ACCESSIBILITY is FALSE.
--- Jacques Kilchoer [EMAIL PROTECTED] wrote:
What database version? What is your setting for
O7_DICTIONARY_ACCESSIBILITY?
I tried the following in an 8.1.7 database with
O7_DICTIONARY_ACCESSIBILITY = FALSE
create user x identified
Hi all,
When you develop a software and you intend to sell it, are there any ways of saving
your database structure. Because obviously we don't give the fmb's, we only give the
executable. But to run the software we need to have the database and there are ways by
which the database structure
Gudmundur,
Where is this documented (so I can RTFM)?
The one piece of this I don't quite understand is that the timestamp is not
emitted twice in a row. If the long time is the triggering event, why do I see a gap
of 90 minutes (in another trace file)?
Daniel
Gudmundur Bjarni
That's it! Thanks...sometimes I forget that a trigger is a stored
object, too.
Regards,
--- Wolfgang Breitling [EMAIL PROTECTED] wrote:
The logon user needs to have granted alter session privileges
directly to
her, not just through a role.
=
Paul Baumgartel
Transcentive, Inc.
Title: RE: logon trigger to start tracing
Paul,
remember it is a trigger ... so it runs under executing user's privs ...
1. everyone needs a direct grant for execute on dbms_session
2. there needs to be a public synonym for dbms_session
3. yell Bingo!
Raj
1. have you tried select to_char(sysdate,'D') from dual ??
Yes, and it works fine on MY servers, but the docs say that the value
returned
depends on your NLS_TERRITORY setting. I am trying to get it to work for
everybody.
This is really nice, but my only gripe with dbms-job is that is isn't
I just started at my new DBA job, and I have been reviewing their database
installation procedure. I noticed that they create all their databases with a 4K
block size. This is for Oracle 9.2 on AIX 5.2. It has been my general understanding
that most sites these days use 8K db_block_size as a
Hi Listers,
I
am trying to configure a two-node Oracle9i RAC on Redhat Linux AS 2.1. I have 2 network cards in each
node. Oracle doc. says that one of
the network cards has to be on a public network and the other network card on a
private network each configured with static ips. Does
Title: RE: DBMS_JOB scheduling
Igor,
you are right ... as a unwritten policy we don't allow windows databases
... even for crash test dummies ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views
Dennis,
I've heard the not getting locked into one vendor idea before. It happens
to be the mantra from our current CIO. Problem is then that you have vendors pointing
fingers at the other guys when something goes wrong. Previous place I worked was ALL
DEC from the ground up.
List,
I need to trace for a specific Oracle error number, ORA-01722. Any
suggestions would be appreciated.
thanks,
David Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ehresmann, David
INET: [EMAIL PROTECTED]
Fat City Network Services--
I wouldnt be concerned with hiding the db structure, look at
peopleslop(aka peoplesoft), the structure is there for all to see but
how its implemented is all on program code, yes you can eventually
figure out how its all related(took me 6 months on one of the versions
but I figured out all of
Title: RE: DBMS_JOB scheduling
nope ... at-least not yet.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an
Ryan
I'm no Java expert and am willing to be corrected. My understanding
is that Apache is just a web page server. The better comparison is between
Tomcat and 9iAS. Since most web hits are for just static pages, you may even
chose to have Apache front-end your 9iAS. Over Tomcat, 9iAS is
Hi Chris,
Be default Oracle 9i create database with 4k block_size ,you can choose
differently types of block_size on tablespace level. You may like to look
into tablespace block_sizes. I have a 4 k block size in one of our
production database but it allows me to have different block size on
I have a task to pull v$session info from various databases and insert into
a history table.
I'd like to exclude those sessions that are connected to a database via a db
link.
Is there an easy way to identify such sessions?
Thanks.
Jeffery D
Building on Jacques' solution, here is one that aligns all the statements nice and
neat. Of course, it does not have the username/instance, so I don't know how
acceptable it is
select ' 1 '
as new_prompt
from dual
/
set sqlprompt new_sqlprompt
1 select 1,
2 2,
3 3,
4 4,
David,
This comes with the usual caveats (contact oracle support, don't do this
without testing, some fading may occur, objects in the rear view mirror are larger
than they appear)...
On error dumps are pretty straight forward. If you can reproduce the error in
a session, just
David,
You can try this, I think. -joan
alter session set events '1722 trace name systemstate level 10';
Ehresmann, David wrote:
List,
I need to trace for a specific Oracle error number, ORA-01722. Any
suggestions would be appreciated.
thanks,
David Ehresmann
--
Please see
Hi,
The Oracle http server (OHS) is a collection of
three distinct feature sets.
1 - Web Server based on the proven Apache
technology.It also provides support for WebDAV, with Oracle9iDB as a
backing store. The Proxy Plug-In component allows Oracle9iAS to be used with
other web servers
Now this one is difficult folks ..
what is average age of an experienced oracle dba
?
-ak
From past experiences, the only client I've seen using 9iAS is the one being
Oracle wall to wall (and Oracle was a partner in the business, a big
bio-tech startup).
All the other clients running on Oracle databases were using BEA Weblogic or
IBM Websphere.
Stephane Paquette
Administrateur de
Ok, use this I found on metalink:
event=1722 trace name errorstack level 3
what about the level 3? What are my options here?
thanks.
-Original Message-
Sent: Wednesday, July 23, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L
List,
I need to trace for a specific Oracle
Hi!
I would look at program column in v$session... it should show oracle or
something similar there if the connection is initiated by another Oracle
server.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 6:39 PM
I
Hussain,
As someone who has to support third party, purchased applications it is my
firm belief that you want to make this as transparent as possible. Why, because no
data system purchased today will operate in a vacuum. They have to be integrated into
the remainder of the
Syed
The statement I received from an Oracle instructor is that the ability to
handle blocks of a different size are in 9i for one purpose and one purpose
only -- so you can bring a transportable tablespace from another database.
Specifically, if you have databases with several block sizes you
Now
that's a LOADED question which I'm sure many a individual on this list will
resist answering.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 11:55
AMTo: Multiple recipients of list
insert into dba_tbl values('41'); --- thats mine
do this for all of the experienced dbas
select avg(age) from dba_tbl;
:)
joe
AK wrote:
Now this one is difficult folks ..
what is average age of an experienced oracle dba ?
-ak
--
Joseph S Testa
Chief Technology Officer
Data Management
Experience can be tricky, I know experienced DBA and developpers with a
lot of years of experience and they're still junior in my mind, they're almost
at the same level as when they started with Oracle.
On the
other hands,I know some people who have been DBA for 3 years and are very
very
--- Jamadagni, Rajendra [EMAIL PROTECTED] wrote:
Paul,
remember it is a trigger ... so it runs under executing user's privs
...
1. everyone needs a direct grant for execute on dbms_session
Been there.
2. there needs to be a public synonym for dbms_session
Done that.
3. yell Bingo!
where can i find a script to find segments which
can't extend due tolow of space in tablespace .
-ak
Hussain
I think Joe and Dick both make excellent points. The key to understanding
your product probably doesn't lie with your database structure. Most vendors
do this well enough just by having obscurely named tables and columns. Most
sites buy Oracle because they expect to use it on an
I'm
only thilteen.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 11:55
AMTo: Multiple recipients of list ORACLE-LSubject: dba
age
Now this one is difficult folks
simple answer:
old enough to know better
:)
--- Goulet, Dick [EMAIL PROTECTED] wrote:
Now that's a LOADED question which I'm sure many a individual on this
list will resist answering.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent:
what is average age of an experienced oracle dba
42?
Þessi póstur var sendur með vefpósti mi, http://www.mi.is
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gudmundur Josepsson
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
We all know that the universal answer that requires a number is ...42
I just had my 58th. Gray hair, kids, grand kids and 7 years from
retirement.
Ron
[EMAIL PROTECTED] 07/23/03 11:54AM
Now this one is difficult folks ..
what is average age of an experienced oracle dba ?
-ak
--
Please see
AK, this is a very old script.
set pagesize 999
spool extent.lst
ttitle 'Database Objects that will have Trouble Throwing Extents'
column owner format a10;
column segment_name format a22;
column segment_type format a10;
column tablespace_name format a14;
column next_extent format
10G
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas
You will recognize your own path when you
come upon it, because you will suddenly have all the energy and imagination you
will ever need.
~ Jerry Gillies ~
-Original Message-From: Goulet, Dick
...and young enough to go ahead and do it anyway! Woooh!
-Original Message-
Sent: Wednesday, July 23, 2003 9:30 AM
To: Multiple recipients of list ORACLE-L
simple answer:
old enough to know better
:)
--- Goulet, Dick [EMAIL PROTECTED] wrote:
Now that's a LOADED question which
I found no signs of
RMAN being used in
any way shape or
form...
I've been told they
are doing "hot" backups
using Veritas...
HOWEVER, the alert log shows
no signs what so
ever of "alter tablespace
xyz begin/end
backup"...
Can it do a good
backup backing up live
DB files and
leaving
I fully agree with Dennis. Even some applications like Oracle Finanacials
11i requires that min db_block size should be 8K. About 32K size, may be
some OS not support that size but 16K is much better for OLAP environment
and we have been using 8K for OLAT and 16K for OLAP/DSS.
Regards
Rafiq
AK - Don't fear, you may feel young now, but working as a DBA ages you
really fast. The other day the discussion drifted into chopping fingers for
making mistakes. Before safety couplings were adopted, the experience of
railroad brakemen was judged by the number of fingers missing. Maybe we
should
Michael
Don't discount the possibility that they are just using Veritas to back
up everything on the Oracle server. Not correct, but I've seen people that
know nothing about Oracle do that.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
Coming from the perspective of one who has needed to get to a DB structure
of a purchased app, you might have some luck using obfuscation. Ever try to
reverse engineer an 800-table schema with no RI? It can be done (we've done
it), but with the help of the app source.
One other 3rd-party app
For something a little different, play with the attached free.sql script.
-Original Message-
where can i find a script to find segments which can't extend due to low of
space in tablespace .
-ak
free.sql
Description: Binary data
I think that a typical DBA ages so fast that simple measuring
techniques are suspect
-rje
J insert into dba_tbl values('41'); --- thats mine
J do this for all of the experienced dbas
J select avg(age) from dba_tbl;
J :)
J joe
J AK wrote:
Now this one is difficult folks ..
what
chronologically i'm
50
mentally i'm
15
physically i'm
90
-Original
Message-From: AK [mailto:[EMAIL PROTECTED]Sent:
Wednesday, 23 July, 2003 10:55 To: Multiple recipients of list
ORACLE-LSubject: dba age
Now this one is difficult folks ..
what is average age of an
For an apricot, I am old. For a head of lettuce, even more
so.
But for a mountain I am not even
begun in years.
However, for a man I am just right.
Matt Adams - GE Appliances -
[EMAIL PROTECTED]It will make sense when you stop thinking
logically,and start thinking Oracle-ly - Jim
Hi
It isn't possible to hide the structure of the database successfully, as
your customers DBA will access the database and can query its structure
- tables, indexes, constraints etc from the dictionary and work out how
quite a lot of your tables interact. That said if you want to make it
you don't have backups. Oracle will only support recovery from hot
backups taken when the tablespaces are not flagged as in backup mode if
you do the backup via RMAN.
Technically, if you are very very lucky, the moon is in the seventh
house and Jupiter has aligned with Mars, you *MIGHT* be able
Tanel.
I am personally impressed with your pratical knowledge, based on your
responses to this list. Mostly DBA's particpating on this list is 35+ (may
in the range of 40-45). Only one DBA is 42 years old for the last 5 years.
Guess who Gogala Mladen(don't shoot me as I am your fan). That is
Can they point to backup sets from which you
can test recovery? As someone else mentioned,
that's the crucial issue.
There are a couple of possibilities:
Veritas can do volume mirroring, for example.
I haven't used this at the Veritas level but we
do something similar on our Hitachi SAN (to
42. And missing a few experience fingers...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
So, your answer is 51.667? Sounds about right.
-rje
P chronologically i'm 50
P mentally i'm 15
P physically i'm 90
P -Original Message-
P Sent: Wednesday, 23 July, 2003 10:55
P To: Multiple recipients of list ORACLE-L
P Now this one is difficult folks ..
P what is average age of
King Arthur: Old woman!
Dennis: Man.
KA: Sorry. Old man! Whose castle is that?
D: I'm 37!
KA: What?
D: I'm 37, I'm not old!
KA: Well, I can't just call you 'man'.
D: Well, you could say 'Dennis'.
KA: I didn't know you were called Dennis.
D: You never bothered to find out, did you?
At least I'm
DBAs are at an intersection, the place where all the data is stored!
Eveyrone wants the DBA to do something for them... and it's never fast
enough.
: )
Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City
Hi!
Thanks for the compliment :) But I'm still complete loser compared to some
other guys here, so there's much work to be done.
I think the 42 might very well come from the Hitchhikers Guide To Galaxy
book, if you know what I mean ;)
Tanel.
- Original Message -
To: Multiple recipients
Hi:
I need to convert RBS tablespace (used for rollback segments) from DMT to
LMT on a 24x7 production machine (Solaris 2.8, Oracle 8173). Here are the
steps I am thinking of taking:
1. create a new rbslmt tablespace
2. create new rollback segments (RBSlmt01, RBSlmt02, ... RBSlmt 06) in
rbslmt
Well I *AM* 37, and I don't feel old. I'm actually the youngest DBA in my
group, and it seems like I'm always the youngest wherever I go...
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 7/23/2003 12:14 PM
King Arthur: Old woman!
Dennis: Man.
KA: Sorry. Old
I'm
94
I
started working with Oracle back in the late thirties on the Rexall
"Wonder-Math" Mechanical Computing Device. Writing SQL with a machine not unlike
a player piano, we did, for hours on end, then we would feed the boxes of
program reels into the Wonder-Math and stand withoiler
exactly...
now, i have to say, there is the option to round up/down when necessary
depending on how many gray hairs are showing through the hair color
application and available room lighting...
-Original Message-
Sent: Wednesday, 23 July, 2003 12:15
To: Multiple recipients of list
I was afraid of that
--
Performing Remote Agent backup
Media Name: Media created 7/18/2003 08:00:06 PM
Backup of \\FAILSAFE\V$
Backup set #11 on storage media #1
Backup set description: DailyBackup
Backup Type: FULL - Back
Guang - Don't forget to update your init.ora!
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 23, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Hi:
I need to convert RBS tablespace (used for rollback segments)
Tanel,
Thanks. Frankly speaking I have no idea about 'Hitchhikers Guide To Galaxy
book' , however, 42 is a favorite/magic figure on this list.
I think, Jared, now may be getting frustrated with this OFF-topic
discussion so no further response from my side..
Sorry Jared.
Regards
Rafiq
They are using RAID5, not mirroring, and the database,
for all the bigger it is needs some SERIOUS tuning.
There are procs that are taking over 1 million disk
i/o's to post a move in inventory..
Again, NOTHING in the alert log, just runs and runs,
no alter tablespace, just redo log changes. And
Let's
see... I remember dirt.. I remember UFI.
I
remember version 4.1.0 that ran on DOS... PC, PC-XT..
Oracle since 1983...
Good
loaded question.
Maks.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent:
Wednesday, July 23,
Why are you converting an RBS tablespace?
If just an exercise, it's understandable.
If for a production database, just create a new tablespace, new rollback
segments, and then drop the old ones.
Jared
Guang Mei [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/23/2003 10:24 AM
Please
If there is no evidence in the alert log, and no backups/file
copies/incarnations are registered in rman, my bet is that the database isn't
backed up.-Original Message-From: DENNIS WILLIAMS
[mailto:[EMAIL PROTECTED]]Sent:
Wednesday, July 23, 2003 9:50 AMTo: Multiple recipients of
I claim 36, making me the youngest DBA here.
Of course, myself is the oldest DBA here at 36.
And I is the average of our ages.
Me, myself, and I work pretty well together, if you ignore all the arguments.
-Original Message-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]
Sent:
Yes, I can.
But I want to call this tablespace RBS because I use this name in all my
other dbs. Just try to be consistent with naming convension.
Guang
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 1:54 PM
To: Multiple recipients of list ORACLE-L
Why are you
I was born on 1/10/1961 in Zagreb, Croatia, which makes me 42 years
of age. My horoscope sign is Ursus (6'4, 260 lbs, used to do greko-roman
wrestling, I can still run 5 miles and lift myself on a chin-up bar). People
sometimes confuse my age with the answer to certain question from the Doglas
Do I need to? I thought after all the steps I still have the same rollback
segment names (RBS01-06). The only difference is they will be in LMT now.
Guang
-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, July 23, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
Guang - Don't
Does index rebuild generates new statistics as well
? How does that can hit performance intermediately if I want to rebuild few
indexes daily just to finish everything in 5 days .
-ak
Wow, I
remember UFI, iapgen and RPT/RPF, but I started in 1989. Do you remember
SQLPME?
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: Michael Kline
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 12:44
PMTo: Multiple
Title: RE: dba age
Dude, I am 37 and the OLDEST Oracle DBA here... only one DBA older in the company!
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you will suddenly have all the energy and
Guang
Yes, I noticed that after I posted my reply. Typically if this was a
production system I would tend to create new rollback segments, online the
new segments, offline the old segments, then change the init.ora. Sometime
later I would drop the old segments and tablespace, maybe after a
Robert,
Be proud. 37 and published. very good work.
Ron
[EMAIL PROTECTED] 07/23/03 01:34PM
Well I *AM* 37, and I don't feel old. I'm actually the youngest DBA in
my
group, and it seems like I'm always the youngest wherever I go...
Robert
-Original Message-
To: Multiple recipients
I see. Thanks.
Guang
-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, July 23, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Guang
Yes, I noticed that after I posted my reply. Typically if this was a
production system I would tend to create new rollback segments, online
Hi!
For index, yes, if you use: alter index
name rebuild compute statistics;
But don't rebuild your indexes daily, it's an
expensive operation... and you won't gain much from it anyway.
Tanel.
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
How will you make sure that there are no active segments in your current
rollback segments before you remove the datafiles with the OS? Even after
you take the rollback segments off-line, Oracle will continue to use them
as long as they have an active segment.
BTW --- One way to help to avoid
Same here, I'm 37 and the younguest one (also the one with the most hair !)
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original
I
remember UFI, RPT-RPF, Forms 2.0 (IAD-IAG-IAP), SQL-QMX (for what it last),ODL
(Oracle Data Loader), but I do not remember SQLPME . What was it
?
Stephane Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
www.standardlife.ca
Tel.
(514) 499-7999 7470
1 - 100 of 196 matches
Mail list logo