Hi
I did not learn for it , was working with ORACLE for two years, failing the
Oracle self tests, but PASSED the Brainbench test while having spend just
half hour for all Questions during lunch hour.
Draw your own conclusions
Jack
Hi
I hope it doesn't matter. We have been using dynamically created "create
controlfile" for years now to copy production DB to test/developnment.
I believe the files are alfabetical in our case.
jack
Could you give me more information on this. I do not have the Oracle 7.3 doc's
Check
Oracle 7.3 documentation
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Friday, April 12, 2002 1:58
AMTo: Multiple recipients of list ORACLE-LSubject: Rule
based engineDoes anybody
know what algorithms a rule based engine
uses.?
To me, Brainbench certifications are practice tests, which are cheaper than
OCP tests. They definetely increases the knowledge on the subjects or alteast
gives you area of study where you feel you are weak. I found many of them and
that's how I developed myself in this area. I don't think, Brai
Does anybody know what algorithms a rule based engine uses.?
Jonathan,
I can't offer a solution but did come up with a simple example showing this behaviour
for those (like me) who hadn't needed to investigate this before but were surprised by
it.
(done under 81714 on NT4)
SQL> create table str_test ( a integer , str varchar ( 20) );
Table created.
SQL
Well!
What's the criteria for a degree being of some value? I think at least these
3
1- How many people know about that degree
2- How hard the issuing authority works to maintain its standards for
passing score, exam questions, etc.?
3- How has one obtained it,
The sites like cramsession, braind
no such animal svrmgrl does NOT exist (or or thatmatter connect internal
either) on 9i.
joe
Reddy, Madhusudana wrote:
>try this :
>svrmgrl > connect internal;
>
>svrmgrl > startup;
>
>Then you should be able to see the error message and post that message here
>
>--Madhu
>
>-Original Messa
On Thu, 11 Apr 2002 17:33:18 -0800, you wrote:
>I feel I had the same dream. Anyway this from Oracle 9i doc:
>Nulls
snip
>(Oracle currently treats a character value with a length of zero
>as null. However, this
>may not continue to be true in future releases, and Oracle recommends that
>you do no
No. And I have them.
-Original Message-
Sent: Thursday, April 11, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L
Dear gurus !
May i ask for your opinions regarding the value of the Brainbench Oracle 8i
Administration certifications.
I understand that it can not be compared t o
No enough inserts to bog down the CPUs?
--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> Thanks, Mohammed and Anjo, for your replies.
>
> Now my question is this: given that the table structures (freelists,
> etc.) are identical on the two machines, the init.ora parameters are
> identical for th
I feel I had the same dream. Anyway this from Oracle 9i
doc:Nulls"If a column in a row has no value, then the column is said
to be null, or to contain a null. Nulls can appear in columns of any datatype
that are not restricted by NOTNULL or PRIMARY KEY integrity constraints. Use
a null when
try to start it manually and see what happens. Might give you clue of
what is wrong.
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> Well, for one thing, you should edit /etc/oratab. That might help.
>
> > -Original Message-
> > From: Zsolt Csillag [mailto:[EMAIL PROTECTED]]
> > Sent:
Oracle has always treated empty strings (e.g.: '') as nulls.
As I sit here and think about this, I can convince myself
that I read somewhere that Oracle9i provided an option to
treat empty strings not as nulls, but truly as empty
strings. Is this the case, or is my mind manufacturing
memories?
J
I recently started getting these high numbers in my statspack
statistics. We have Oracle 8.1.6.0.0 on Solaris 2.6 platform.
Shakir
--- "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]>
wrote:
> Glenn,
> Without commenting on the value of the hit ratio, I can comment on
> the suggestion that the bug
Paul,
The number of freelists should be a prime number that is equal or just
less than the number of concurrent processes inserting.
Anjo.
Paul Baumgartel wrote:
> Hi, all. Now that I know that I must increase freelists for my tables
> with heavy insert activity, does anyone have a method f
Glenn,
Without commenting on the value of the hit ratio, I can comment on the suggestion that
the bug affects all platforms.
I am running 8.1.7.1.4 on NT4 and your query gives the following:
SQL> col name for a20
SQL> col value for 999,999,999,999,999,999,999
SQL> select name,value from v$sysstat
I wouldn't rely on a list generated from doing an ls on a directory because
there may very well be files in that directory that are not part of the
database (like files that used to be part of the db but not any more).
I have a Perl script that queries dba_data_files on both source and target
db'
Hi, all. Now that I know that I must increase freelists for my tables
with heavy insert activity, does anyone have a method for determining
just how many freelists the tables should have? So far, I haven't
found anything in either TFM or the Net other than "increase the number
of freelists".
Th
Going to show my age here ...
Actually IMAGE is a network database and not a hierarchical one. It is
patterned
after a database called TOTAL that back in the days preceding Oracle,
Sybase,etc.
was installed almost everywhere. While you didnt need a DBA it was good to
have
people that were knowled
No I was trying to start the OEM console , which requires OMS, but I do not
have it on HP Unix server.
So I have installed OEM on Windows and now able to work with console from my
m/c.
Thanks for suggestions , but not much help
Thanks
Madhu
-Original Message-
Sent: Thursday, April 11, 20
$OH/database is the place where ORACLE will look for the parameter file and
here you can (also) have a soft link created to the Actual location of the
parameter file i.e. . PFILE directory(ORA_HOME/admin/SID/pfile) .
And for the control file location see the init.ora file ( parameter
control_file
SUCCESS !! And Congrats
-Original Message-
Sent: Thursday, April 11, 2002 6:19 PM
To: Multiple recipients of list ORACLE-L
test
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ivan Llamoca
INET: [EMAIL PROTECTED]
Fat City Network Services-- (
Well, at least according to Mr. Crawford...
--- "Jesse, Rich" <[EMAIL PROTECTED]> wrote:
> The 1904 World's Fair is where "coming down the Pike" originated.
> But the
> reference wasn't to a turnpike or to the family of North American
> fishies...
>
> http://www.crawforddirect.com/1904wf.html
test
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ivan Llamoca
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
Andrey - Value is in the eye of the hiring manager. OCP can be most useful
for consultants because you are frequently sending your credentials around.
If the hiring manager has never heard of OCP, it doesn't have much value. If
the guy he just fired had an OCP, he may not regard it with much value
Another piece of paper!
-Original Message-
Sent: Thursday, April 11, 2002 5:39 PM
To: Multiple recipients of list ORACLE-L
> Dear gurus !
> May i ask for your opinions regarding the value of the Brainbench Oracle
> 8i Administration certifications.
> I understand that it can not be comp
All
I have some more information on this. I turned on event 10046 on this. From
this I was able to note the following...
1. I start the sql script and spool the results
2. It waits for less than a second on "process startup" and "PX Deq: Join
ACK". I think these are waits for starting up the pa
Rich - I frequently clone our production database to test. Since the
location of the files is different, I usually end up editing the CREATE
CONTROLFILE in a major way, resorting the contents sometimes to the name of
the datafile and sometimes sorted to the location. We have about 200
datafiles.
All,
Charlie Mengler kindly forwarded a link that may help us first-timers to San
Diego. Please browse at
http://www.gothere.com/sandiego/gaslamp.htm
Maybe we can decide a location for Dinner ahead of time!
John
-Original Message-
Sent: Thursday, April 11, 2002 1:59 PM
To: Multiple r
One certain company (to remain nameless) is asking employees to obtain
at least 4 Brainbench Certifications this year. And that company also
uses Brainbench assessment tests for pre-employment screening. So there
are certain employers taking advantage of Brainbench. But otherwise, I
haven't fo
Rich,
Interesting one, but the order of files in the CCF really does NOT matter.
As far as I could observe, Oracle is able to determine the file number from
the datafile header and arrange itself. I regularly clone a 125Gb/205 file
(and growing) Apps Database from one server to another and wildly
I beg to differ. I am not so sure whether what you are
suggesting is even feasible on most VLDB environments
today. Imagine if you have to implement at 2TB hybrid
database with 500 datafiles on a RAID 1, you will have
to individually maintain a large number of
"independent RAID 1 logical volumes".
Wouldn't it be: oemapp dbastudio &
"Reddy, Madhusudana" wrote:
>
> $ /usr/local/bin/sudo find / -name *oem* -print
> /usr/local/oracle8i/disk1/stage/Components/oracle.sysman.emcommon/2.2.0.0.0/
> 1/DataFiles/Expanded/Scripts/oemapp
> /db01/app/oracle/product/8.1.7/bin/oemapp
> $
>
> The above
Hi,
I'm using 9.0.1 on win2000. When a database is
created using configuration assistant, two init files
are created: one in ORA_HOME/database, and the other
in ORA_HOME/admin/SID/pfile. Here are my questions:
1. what's the difference between these two, why
created two copies.
2. the one in O
No, the order does not matter. We create control files frequently when we
clone from production to test and development. We use this piece of code to
generate the listing in Korn Shell:
ls /*/oradata/SID/*.dbf | while read FN; do echo "'"$FN"',"; done
Of course you will have to replace the fin
Title: RE: Brainbench Oracle certifications
About the only value for it is a non-IT recruiter to see if you at least know how to spell Oracle.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 6:09 PM
To: Multiple recipients of lis
OCP has $125 more value than Brainbench.
-Original Message-
Sent: Thursday, April 11, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L
Dear gurus !
May i ask for your opinions regarding the value of the Brainbench Oracle 8i
Administration certifications.
I understand that it can n
Ugly way:
1- Select the list of valid views.
2- Rename the table.
3- Create new table with the same name but missing the column (empty table).
4- Compile all views.
5- Invalid views are using this column.
Regards,
Waleed
-Original Message-
Sent: Thursday, April 11, 2002 5:19 PM
To: M
This won't work if I alias the column name in the view definition, would it?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc
Andrey,
The Brainbench exams are good for self-testing your knowledge of the
product and exposure to nuances you may not have previously considered or
come into contact with. In this regard, it's really much like the OCP,
without the "official" stamp of approval. I take their exams for a varie
Title: RE: No DBAs needed on AS400
I believe that there are ODBC and JDBC drives for
OS/400...
- Original Message -
From:
Godlewski, Melissa
To: Multiple recipients of list ORACLE-L
Sent: Thursday, April 11, 2002 1:28
PM
Subject: RE: No DBAs needed on
AS400
> Dear gurus !
> May i ask for your opinions regarding the value of the Brainbench Oracle
> 8i Administration certifications.
> I understand that it can not be compared t othe OCP, but is there any
> value at all for it ?
> Thanks a lot in advance.
> Andrey.
>
>
--
Please see the official ORACL
$ /usr/local/bin/sudo find / -name *oem* -print
/usr/local/oracle8i/disk1/stage/Components/oracle.sysman.emcommon/2.2.0.0.0/
1/DataFiles/Expanded/Scripts/oemapp
/db01/app/oracle/product/8.1.7/bin/oemapp
$
The above will confirm that , I do not have oemctrl on my Oracle Client on
HP Unix machine.
Rick,
I believe the order of the datafiles in the BACKUP CONTROLFILE TO
TRACE comes from the file# in V$DBFILE. If you select from v$dbfile
there is no guarantee the list will be in order of the file# and the
file# is not the order in which the datafiles were created.
Ron
ROR mª¿ªm
>>> [EMAIL P
Darn E-mail package. Every once in a while I get a message as I'm deleting one
or more I don't want & one I do want goes as well. Well, I guess that's
IBM/Lotus for you.
Anyway, someone asked how to find all the views that include a specific column.
Try the following:
select view_name
Nope.
Reply Separator
Author: Andrey Bronfin <[EMAIL PROTECTED]>
Date: 4/11/2002 1:23 PM
Dear gurus !
May i ask for your opinions regarding the value of the Brainbench Oracle 8i
Administration certifications.
I understand that it can not be compared
is there any value to OCP?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 3:23 PM
> Dear gurus !
> May i ask for your opinions regarding the value of the Brainbench Oracle
8i
> Administration certifications.
> I underst
Well, for one thing, you should edit /etc/oratab. That might help.
> -Original Message-
> From: Zsolt Csillag [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 11, 2002 4:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ORACLE 9i doesn't start on Linux
>
>
>
> Hi,
>
>
> I
This provides you with the "view" columns, not the columns from the tables,
which the view is based on.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 5:23 PM
> Darn E-mail packa
OH, OLD problem. Take a look in /etc/oratab . The file is formatted as
::
Where the Y/N means do I or don't I start the database. It defaults to N.
Change it to Y and dbstart will start your database.
Dick Goulet
Reply Separator
Author: Zsolt Csillag
Hi all,
Here's hoping this is in time for y'all who are visiting/presenting at IOUG.
I believe most of you will be getting in either late Saturday or early
Sunday. After completion of registration, etc., I guess we should be free on
Sunday evening for a quick introduction so we know some names an
Sinardy Xing wrote:
>
> Hi all,
>
> I try to change the error message to French,
Don't do that. French-speakers have to translate back to English to
understand what they mean.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Aut
Ian,
AFAIK, there is no direct way, as the view text is stored in dba_views and
column list can be seen in ALL|DBA_tab_columns. Looks like you'll have to do
some parsing ... but on the brighter side, you can restrict your look up to
only those views that appeared in the dependency list of the tab
Dear gurus !
May i ask for your opinions regarding the value of the Brainbench Oracle 8i
Administration certifications.
I understand that it can not be compared t othe OCP, but is there any value
at all for it ?
Thanks a lot in advance.
Andrey.
--
Please see the official ORACLE-L FAQ: http://ww
Disk layout and disk speed itself matters. While testing one same batch job
with similar data on prod and test machine, test machine was performing same
job in half of the time(2 hours) than prod(4 hours) and difference was fast
fiber optical drives on test box even with slower processor but as
This is interesting, even though it is 2 years old:
http://www-1.ibm.com/servers/eserver/iseries/db2/todba.htm
It seems to be saying (if I may summarize): "As we catch up to the features and
functionality of Oracle, you will need a DBA."
Jay
-Original Message-
Sent: Thursday, April 1
Hey, just wait around till the Oracle support bill shows up. No, better yet,
leave before then. If he/she is making decisions based strickly on expense you
might as well be one of the early rats, namely leave the ship before it sinks!
Dick Goulet
Reply Separator
Rich,
I believe the datafile order in a CREATE CONTROLFILE statement is critical,
from lowest FILE# to highest. I'd be reluctant to prove myself wrong by
testing our database copy process (I used sed to map the datafiles.), but we
are moving 500-600Gb databases around and rerunning it would requ
I'll add mine:
We had a developer on a Sun box who somehow managed to set all
of his source files to be executable. On that particular version of
Solaris, when you went into filemgr and double click on an executable
file, filemgr executed it as a shell script. As it happened, the standard
heade
"MacGregor, Ian A." wrote:
>
> The dependencies tables do not go down to the column level. If I want to know all
>views that access the sal column of scott.emp how do I do this. I can find out the
>name of the views which access the table via "dependencies", get the view text and
>parse it
Hi,
I've installed Oracle 9i on Suse Linux 7.1.
The lsnrctl starts nicely, however when I type "dbstart" then
it does absolutelly nothing.
No error message, but the database won't start.
Any ideas?
Thank you in advance
Zsolt Csillag,
Hungary
--
Please see the official ORACLE-L FAQ: http:/
Rich,
Thanks for the update on the "Coming down the Pike" and no I wasn't at
the fair then I feel as if I was at times.
The pipe in reference to the "coming down the pipe" could be a
plumbing joke too. Maybe I should have referenced a crystal ball by I'm
not psychic, psycho maybe but not psych
Ethan,
Do you have any
recommendations for a place near the Convention Center/Downtown?
Thanks,
- Kirti
-Original Message-From: Stephen Andert
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 11,
2002 1:34 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: IOUG
But you assume too much. We have three copies of our production system to
three different test/dev/playground databases. First, is our nightly hot
backup that gets started up as a new instance (on the prod server) for our
users as a playground after the datafiles are put to tape. Second is our
See the book - chapter 12, page 250.
It's normal behaviour. There is one bizarre
SQL run if you do the exchange
"without validation" and another (usually cheaper)
if you do it "with validation".
This relates to checking primary and unique
keys, rather than the partitioning constraint.
The solu
users and what they are doing ?
select v2.sid, v2.username, v2.machine, v2.program, v1.sql_text
from V$sql v1, V$session v2
where (v1.address = v2.sql_address or
v1.address = v2.prev_sql_addr)
and v2.username is not null
ORDER BY 1
---Madhu
-Original Message-
Sent:
BUG.
Fixed in 9i.
-Original Message-
Sent: Thursday, April 11, 2002 12:51 PM
To: Multiple recipients of list ORACLE-L
Hi everybody,
Oracle 8.1.7.2, Solaris.
What is your opinion on this? Seems, Metalink doesn't have any :(
SQL> create table test_pk(
2 id nvarchar2(20) primary k
I don't think this should be a problem but just asking.
This is all on NT/W2K
On server A, I have a database running 8.1.7.1.5
On server B, I have other databases running 8.1.7.3.2.
To consolidate servers I plan to:1. Take a hot backup (since it
is production) of the database on Server
try this :
svrmgrl > connect internal;
svrmgrl > startup;
Then you should be able to see the error message and post that message here
--Madhu
-Original Message-
Sent: Thursday, April 11, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
Hi,
I've installed Oracle 9i on Suse Lin
Paul - My point is that I have seen performance decrease when too many
processes are used. For example, with imports, a multi-cpu system may import
faster with two import jobs running. But at some point it seems that Oracle
and/or the operating system is just trying to switch between each process
Rich - Thanks for this cultural education.
-Original Message-
Sent: Thursday, April 11, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
The 1904 World's Fair is where "coming down the Pike" originated. But the
reference wasn't to a turnpike or to the family of North American fish
Hi Zsolt ,
check /etc/oratab, you may need to replace N by Y
hth
Vadim
-Original Message-
Sent: Thursday, April 11, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
Hi,
I've installed Oracle 9i on Suse Linux 7.1.
The lsnrctl starts nicely, however when I type "dbstart" then
it
Hello,
Pipeline is for sales and gas, almost the same thing. "It's coming down the
(turn)pike" is the way to describe something that is anticipated soon.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Try to do
$which oemctrl
or
$find / -name *oem* -print
Someone on the distro might add in comments
David
-Original Message-
Sent: Thursday, April 11, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L
I could not see this on HP-UNIX client ( $OH/bin ) where I have inst
If there is an entry in V$SESSION, does it imply that user has
a current session within the instance?
If not, how do I determine which users have logged out of the DB?
Under what conditions would I not be able to obtain any SQL from
V$SQLAREA for any given SID?
1 select username, osuser, sq
It's certainly possible for Oracle to be pushed
into very heavy CPU usage, particularly for
PX slaves, but even in serial queries.
Two common 'causes' are queries with
correlated sub-queries against small tables;
and queries which have been over-indexed
and hinted to avoid table-scans.
Bottom
Jesse - No, order isn't important. This is a relational database after all -
right?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, April 11, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
I'm writing a Perl script to automate the procedu
The dependencies tables do not go down to the column level. If I want to know all
views that access the sal column of scott.emp how do I do this. I can find out the
name of the views which access the table via "dependencies", get the view text and
parse it by eye. But I don't want to do th
Order of files in alter system backup... does not matter. Wow using Perl
to do this when then procedure is documented a 1000 times over. I am sure
you have some very good reason. Automating something that I would think is
not very frequent may be overkill. Oh well enjoy.
Rick
Title: RE: No DBAs needed on AS400
Comments were made that DB2 and AS400s are not "open". Does this mean that you couldn't write a client/server program to access data on DB2 (say using C++ from Windows 2000)?
RUMBA/400 formerly pc support connects to the AS400 from a windows pc. Last I kne
Dennis--
The faster machine had 10 database connections, the slower, 50. Not
all were used in either case. But my comparison is for inserts done by
a single session, i.e., it's not the aggregate insert rate, but a
direct comparison of the same insert statement in a single session on
each server.
If your company is using Rman right now, please send me a private
email and let me know. I'd like to know your company name and number
of databases that you backup with Rman.
I would be most thankful as I will be using this information to
demonstrate the viability of an Rman book to Oracle Pres
I'm sure that everyone is sending you their version of this:
ttitle off
set pages 40 lines 132
column value heading ''
column sessions_current format 999,999,999 heading '# Currently Logged On'
column sessions_highwater format 999,999,999 heading 'Most # Logged On'
column pusername format a8 head
DataTrieve!! That useful pile of *&^%!! I have not heard of that tool in the
last 10 years, boy are you ever tweaking the memory! It was one tool that I
hated to love. Yes you did have to do some configuration before it would work,
but once it was working could you ever parse a file. Slice &
I would ask myself the question, "Do I want to be working for someone this
technically clueless?" I foresee a long education process via-a-vis this
guy (I'm assuming that it's a guy) or a never-ending struggle just to get
the basic tools that you need to do your job.
The 1904 World's Fair is where "coming down the Pike" originated. But the
reference wasn't to a turnpike or to the family of North American fishies...
http://www.crawforddirect.com/1904wf.html
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad
I'm writing a Perl script to automate the procedure to create a copy of an
8.1.7 production DB to a development server. Both production and dev are
HP/UX 11.0.
In doing this, I've created a file that cross-references where the
production datafiles are and where they are to be placed in dev. Thi
I alway thought it was pipeline.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
-Original Message-
Sent: Thursday, April 11, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L
Wasn't that expression originally "coming down the pike", as in
turnpike? :-)
_
Thank you for all the replies that I have received.
It sounds like a version of DB2 comes along with the OS, or a full fledged version of
DB2 can be installed. From what I have heard about their AS400 system, they can
access their files directly - without going through a database. This remi
Hi List,
I have 4 instance(for 4 databases) running on sun solaris oracle 8.1.6, if i
want to add one of these instance as secondary instance to one of my
database is it possible or not? if YES how?
Appreciate
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
===
Count me in. When/Where? Any San Diego
local(s) on the list?
Stephen Andert>>> [EMAIL PROTECTED] 04/09/02
07:43AM >>>Do we have a location, date, time???--- Joe
Testa <[EMAIL PROTECTED]> wrote:> So for those of us going to the
IOUG Conf, do we> want to plan a get > together?> >
Throwing
I could not see this on HP-UNIX client ( $OH/bin ) where I have installed
all the Oracle Client ( Administration ),
Would you let me know the location , where I can find this on UNIX
--Madhu
-Original Message-
Sent: Thursday, April 11, 2002 12:29 PM
To: Multiple recipients of list ORACLE
Thanks for the script. It is useful for me.
David
-Original Message-
Sent: Thursday, April 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Try either of 1 script and make changes according to your requirement:
1)
col LOGIN_TIME format a12
COL OSUSER FORMAT A7
COL ORACLE_US
Yep,
Using CPU or being re-scheduled by the OS.
Anjo.
"Adams, Matthew (GEA, 088130)" wrote:
Would it seem likely for Oracle to be
doing ANYTHING for a full 30 seconds
without hitting another wait?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Reason is 6/7ths of treason. - The Xtals
-
Oops...
Sorry, should be:
'TRUNC(LAST_DAY(SYSDATE))'
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 1:03 PM
> Your job interval should be:
>
> 'TRUNC(LAST_DAY(SYSDATE) +
You must be thinking of something else, I just got thru doing a 9i import of
an 8i dmp file.
-Original Message-
Sent: Thursday, April 11, 2002 12:03 PM
To: Multiple recipients of list ORACLE-L
I think you have to use only the 8i version on EXP and
IMP in this case, as 9i EXP cannot conn
If that new box is a sand box, I would just play to see if exp of 8i can be
imported in 9i.
-Original Message-
Sent: Thursday, April 11, 2002 10:03 AM
To: Multiple recipients of list ORACLE-L
I think you have to use only the 8i version on EXP and
IMP in this case, as 9i EXP cannot con
In the late 80's and early 90's I worked on an AS/400. We also had NO DBA,
and the box looked and ran like we had NO DBA. Back then IBM pushed
AS/400's as a "put it in and forget it/don't worry about it" box. And as a
result our "database" looked and ran like a POS. I remember submitting
jobs
1 - 100 of 182 matches
Mail list logo