Stephen,
What about this,
SQL Create sequence a;
SQL Create table xxx(numtest number, testvalue varchar2(100));
SQL declare
x number:=0;
begin
select a.nextval into x from dual;
Insert into xxx values(x, 'TEST');
end;
Rgrd,
Sony
sorry for not being 'directly relevant'
But I was just wondering why
you were upgrading from 7.3.4 to 8.0.6
(and then having to upgrade to 9.2)
when Oracle has provided for an upgrade path
from 7.3.4 to 9.2
Can you please let me know your reason
for upgrading to 8.0.6
Thanks
Cyril
On
SORRY - this was the wrong list. the other pertinent list is one about controlling
machines via a DDL protocol and a demon called the alike.
kr mr
[EMAIL PROTECTED] 01/22/03 16:49 PM
hi
what's your exact question?
you mean autocommit like in database applications?
what tool are you using to
Hi all
One of the developers came to me. They are using a Genesys call logging
system.
It has apparently stored a date time in a number field as the number of
seconds since 1970 1 Jan 0:00
They need to know exactly what time this is.
I can not off hand remember that oracle got a conversion
Hi all
One of the developers came to me. They are using a
Genesys call logging
system.
It has apparently stored a date time in a number
field as the number of
seconds since 1970 1 Jan 0:00
They need to know exactly what time this is.
I can not off hand remember that oracle got a
conversion
SELECT to_date('01-01-1970','DD-MM-') + no_of_seconds / (24*60*60) from
dual;
Regards
Naveen
-Original Message-
Sent: Thursday, January 23, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L
Hi all
One of the developers came to me. They are using a Genesys call logging
system.
remember this functionality of committing before a DDL statement has
been around from the beginning. Autonomous transactions have not. It
may simply be a case of Oracle not getting around to adding that change
to the kernel code.
Or, as Kirti quoted from Tom Kyte, that might just be the way they
Hi,
I need to use the DBMS_PROFILER package for PL/SQL
in between the procedures. I used the corresponding script located
in
Oracle_home\rdbms\admin\PROFLOAD.sql .
I ran this script, it ran without any problems.
But I am still unable to invoke the DBMS_PROFILER package,
The error is
Identifier
Hi
Has anyone had issues with TOra and Outlook not playing together nicely? It
seems that since I installed it, I have been getting blank emails and email
attachments have no name (or extension).
Thanks
Mark
__
The information contained in this
Very good point. I know where I work, HR classifies DBA as an analyst for pay
reasons. The Senior DBA position, is more of a management-type role. More money,
more management responsibilities but less actual DBA work.
-D-
--
Dwayne Cox
Oracle Database Administrator
Info Tech, Inc.
5700 SW
MetaLink article #144804.1 describes the process of migration from Oracle7
to Oracle9i...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 1:13 AM
sorry for not being 'directly relevant'
But I was just wondering why
I have the Oracle Performance Tuning 101 book and I have been reading the Performance
Tuning Guide on OTN, however, I found its explanation of when to use messages and how
to write queries extremely terse. Are there any websites or books which focus strictly
on query tuning that provide more in
Hi Rachel,
Good point about the autonomous transactions. If I remember correctly that
was new
in 8i.
My general theory on WHY questions is "That's the way they coded it!". They
probably could have coded it differently, but they didn't. The important
thing is that
it is well documented how
-The Senior DBA position, is more of a management-type role.
More Damagement!!
Dave
-Original Message-
Sent: Thursday, January 23, 2003 7:14 AM
To: Multiple recipients of list ORACLE-L
Very good point. I know where I work, HR classifies DBA as an analyst for pay
reasons. The Senior
Run GRANT EXECUTE ON SYS.DBMS_PROFILER TO you first; it appears that
your permissions were granted through a role...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 4:59 AM
Hi,
I need to use the DBMS_PROFILER package
Go have a beer, relax and re-read it. Get him Kirti!!
;o)
Dave
-Original Message-
Sent: Thursday, January 23, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L
I have the Oracle Performance Tuning 101 book and I have been reading the Performance
Tuning Guide on OTN, however, I
Title: RE: RE: Upgrade from 7.3.4 to 8.0.6
A valid question. With a pseudo-valid answer, which is: Because there is no 8i for hp-ux 10.20. We have been asking for upgrades and all for the last 4+ years and the management answer is do nothing until SAP is completed. SAP was started in 1996 and
Sorry, no, I can't find it.
Maybe someone else knows?
Jared
On Wednesday 22 January 2003 21:03, Justin Cave wrote:
At 12:07 PM 1/22/2003, [EMAIL PROTECTED] wrote:
It recently came to my attention that the DBA's where I work have
adopted a
convention where the global_name of a
Satya,
pls grant the privileges from sys to the user running the DBMS_PROFILER package
Venkat
--
On Thu, 23 Jan 2003 03:59:00
Satya V Prakash wrote:
Hi,
I need to use the DBMS_PROFILER package for PL/SQL
in between the procedures. I used the corresponding script located
in
Hi,
Please ask the DBA to check whether the self checking by dbms_profiler
was completed.
The package upon completion should give SYS.DBMS_PROFILER
successfully loaded.
Also please grant execute privilege on DBMS_PROFILER to the user .
Pradeep
Senior isn't an absolute term. A senior DBA in a small development house
could be the guy who knows how to add a tablespace. A senior DBA in a large
company may have to combine a good level of technical ability with a good
deal of management and business skills.
The term also seems to be used to
Steven,
m.b. this is dumb question, but did you check, that there is no function
called nextval inside user-written package called a, which hides actual
retrieval of sequence next value?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list
I would also verify that Oracle Trace is turned off and that within
$ORACLE_HOME/otrace/admin there are no files.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
Our DBA group has recently been getting numerous requests for
new databases (training, inventory, customer contacts, etc..)
from different departments within the company. Our normal
procedure is to create a new instance for the database,
create the schema, users, etc..., set up backups and
Hi List !
Can we disable and enable trigger from Inside a same trigger.
I am updating records of a table from statement level trigger on same table
. Iit causes recursion so, want to avoid it.
regards ..
Shishir Kumar Mishra
Agni Software (P) Ltd.
www.agnisoft.com
--
Please see the official
R - When this came up on this list recently, the consensus seemed to be that
Guy Harrison's Oracle SQL High-Performance Tuning is best.
http://www.amazon.com/exec/obidos/tg/detail/-/0130123811/qid=1043332563/sr=8
-1/ref=sr_8_1/103-9193296-9002269?v=glances=booksn=507846
Dennis Williams
DBA,
Yes. I agree that works. The problem is that there are over 2000 lines of
code similar to the one I identified. I'm not interested in recommending
changing all of it unless it's a conversion issue.
Thanks for the help.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
List,
I am looking for a recommendation on a book or web site covering
statspack and it's use. A moderate level usage rather than an expert
level literature is desired.
Any recommendations please.
Thanks,
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron
encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
It could also have something to do with the status changes
of objects that may be affected by the DDL, though I am
speculating here.
Jared
On Thursday 23 January 2003 02:58, you wrote:
remember this functionality of committing before a DDL statement has
been around from the beginning.
Title: RE: trigger problem in Oracle 8i
Change the logic ... it will be easier and the right way to handle this.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and
Hi Tim, and Steve,
Thanks for the comments. I did check whether tracing was enabled, and it
wasn't..
Thanks for the thought though.
Cheers
Mark
-Original Message-
Stephen
Sent: 23 January 2003 13:49
To: Multiple recipients of list ORACLE-L
I would also verify that Oracle Trace is
Hi,
Can anyone point me to any web sites that have information on the following
two issues
1. Running oracle forms on the oracle server
Our customer wants to take away our access to the client machines and they
were wondering about running the actual forms on the server. (We are a bit
worried
Arup,
I see your point and agree that the DDL should be an autonomous tx.
Perhaps an enhancement request is in order? Since Oracle has the autonomous
tx code, integrating into the kernel should be considered...perhaps for
Oracle 38i?
In the absence of that change, I must disagree
Stephen,
Wild-hair idea...could you create a function with the name nextval
and use it to populate from the sequence?
Dan Fink
-Original Message-
Sent: Thursday, January 23, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L
Yes. I agree that works. The problem is that
-- Hi all,
All users on the server can see the password when they issue a ps
-ef|grep rman comman after the RMAN job runs, such as rman target
[name]/[password] Is there any way to prevent the password being
seen on screen?
TIA
Robin
--
Please see the official ORACLE-L FAQ:
sed will fix that in a big hurry. PERL?! We don't need no stinkin' perl!
-Original Message-
The problem is that there are over
2000 lines of
code similar to the one I identified.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET:
Well, then even Tom's vague on this one.
DDL locks are automatically placed against objects during a DDL operation
to protect them from changes by other sessions.
Well, then even an insert statement makes changes to DD objects. Ain't
locks taken then?
DDL Starts by commiting.
Why not declare a
Don Burleson has a book called Oracle9i High-Performance Tuning with STATSPACK.
Check out the link below.
http://www.dba-oracle.com/books.htm
Dave
-Original Message-
Sent: Thursday, January 23, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L
List,
I am looking for a
Title: RE: Replication question
We don't update data on slaves, we update data from master then slave pull data from the master every 5 minutes.
David
-Original Message-
From: BigP [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 7:59 PM
To: Multiple recipients of
Ron - There are a series of articles available on-line.
http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html
Don Burleson has some articles on-line
http://www.dba-oracle.com/articles.htm
And Don has an entire book titled: Oracle High-Performance Tuning with
STATSPACK.
Let us
Nope. Tora works perfectly well with the Evolution.
They cause no problems to each other.
-Original Message-
From: Mark Warner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
Subject: TOra
Hi
Has anyone had issues
Here it is in Unix...
$ORACLE_HOME/bin/rman EOF_script
connect catalog ${CATALOG_OWNER}/${PASS_VALUE1}@${REPOSITORY_DB}
connect target ${TARGET_RMAN_USER}/${PASS_VALUE1}@${ORACLE_SID}
@${rman_script_path}
EOF_script
RMAN_RETURN_CODE=$?
Brian Spears
Sr. Oracle Database Administrator
Limited
We can't use global names here either, same reason.
it is set to false, one of the first things we do when we create a new
instance.
Pat.
-Original Message-
Sent: Thursday, January 23, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L
Sorry, no, I can't find it.
Maybe someone
Nuala - It would be really helpful if you could mention what type of servers
these are. For example, we have had Alpha (Dec a.k.a. Compaq a.k.a. HP)
servers up for over a year without a problem. Also the Oracle version might
make a difference. This is Oracle 8.1.6.
Dennis Williams
DBA, 40%OCP
Oracle9i High-Performance Tuning with STATSPACK
Donald K. Burleson, Oracle Press
http://www.amazon.com/exec/obidos/ASIN/0072190582/qid=996445780/sr=1-4/ref=s
c_b_4/102-7596303-7878550
URL will be wrapped..
Also on Don's site:
http://www.dba-oracle.com/art_statspack.htm
HTH
Mark
I second that motion. Also, to get you started quickly, there is
a whole load of white papers on Metalink and OTN.
-Original Message-
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject:
Interesting question. Why should it be mandatory to have distinct global
names ?
For convenience, manageability etc, yes. But mandatory for operations ?
AFAIK, the only place where GLOBAL_NAMES is enforced is in Replication.
I've inherited a site where the DBA created a database image and
Thanks to all who replied.
I will look for the book at the local book store this weekend.
Ron
[EMAIL PROTECTED] 01/23/03 10:44AM
Don Burleson has a book called Oracle9i High-Performance Tuning with
STATSPACK. Check out the link below.
http://www.dba-oracle.com/books.htm
Dave
Is there such thing as an over-normalized database design?
What defines over-normalization? And what are its consequences? (Other
than the obvious degraded database performance and lots of tuning)
I hear rumblings that our ERP system is over-normalized.
Just curious,
Thanks!
Saira Somani
IT
I tend to agree with the argument that's the way they wrote it.
If I remember correctly, DDL always commits the current transaction
in the session, even back in Oracle5 [and earlier ?] days. Most likely
they couldn't write autonomous transactions then.
That autonomous transactions have been
Daniel:
You are a sick person. Not going to change the code that much. I need to
evaluate the pain for the development team.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:
I had a similar problem once that was solved by editing my SQLNET.ORA
file. I set:
SQLNET.AUTHENTICATION_SERVICES= (None)
...instead of:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
I'm not sure what functionality this change eliminated, but my
connection times are sure a lot faster
Title: RE: simple question on DDL
From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 8:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: simple question on DDL
Actually, DB2 (pardon my French) doesn't issue a commit
after a DDL. I'm not
Hi,
After your words, I did a single thread of index creation and i was so surprised to
find that the time spent on index creation is less:
SQL CREATE INDEX IDX_PRO ON PRODUCTS(SELLER_ID) NOLOGGING ;
Index created.
Elapsed: 00:01:12.65
God!
But I still think there is something we can
Get Don Burleson's book - I think it's called Oracle 9i
High Performance Tuning with STATSPACK.
-Original Message-
Sent: Thursday, January 23, 2003 6:44 AM
To: Multiple recipients of list ORACLE-L
List,
I am looking for a recommendation on a book or web site covering
statspack and
How many join table operations do you perform, in most of the queries? As
more tables are added to the join, you take a performance hit? Plus, all
the space for the indexes on the additional tables? An update could end up
having to write to multiple tables. So, I guess, you have to walk the tight
i'm trying to configure a new system (aix 4.3.3 or any other unix or even
any linux) to work as a development server with 9i r2 and 9ias r2.
One of the things i allready know is that i have to create a aix user to be
owner of each one of those tools (i've been working with the previous
versions
It just occurred to me that maybe senior DBAs should get discount cards for
shopping, etc.
: )
Pat.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
Hi,
I'm going to be implementing RMAN sometime soon and am putting together the
RMAN catalog server spec. Have had a look around for formulae to size the
RMAN catalog tablespace(s) but have had no luck.
Best information I can find is to size the catalog tablespace(s) at between
10 MB to 20 MB
Actually, DB2 (pardon my French) doesn't issue a commit
after a DDL. I'm not aware of any standards specifying
the presence or absence of a commit after a DDL. I know
that, for instance, EXPLAIN PLAN can be rolled back.
-Original Message-
From: Fink, Dan [mailto:[EMAIL PROTECTED]]
Title: RE: simple question on DDL
Set autotrace on ... and then do explain plan for
You'll see.
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't
Does anyone know why sometimes a program name appears in the v$ views for
user sessions, and sometimes nothing?
I noticed that sqlplus appears as sqlplus.exe, and other problems as their
executable file name, but for TOAD nothing appears.
Is there a way to force Oracle to collect this
Title: RE: Program name in v$ views
TOAD sets the module name as T.O.A.D
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.
QOTD:
Thanks a lot.
Spears, Brian wrote:
Here it is in Unix...
$ORACLE_HOME/bin/rman EOF_script
connect catalog ${CATALOG_OWNER}/${PASS_VALUE1}@${REPOSITORY_DB}
connect target ${TARGET_RMAN_USER}/${PASS_VALUE1}@${ORACLE_SID}
@${rman_script_path}
EOF_script
RMAN_RETURN_CODE=$?
Brian Spears
Title: RE: senior oracle dba
would you like reserved parking with that??
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.
QOTD:
One question to ask is whether whether all DDL
use the same strategy. Similarly, if you have
multiple code paths for do a ddl call how much
more risk of error do you introduce to the kernel.
Finally how do you get a consistent error response
to the end user if the error condition of apparently
Title: RE: over-normalized?
From: Saira Somani [mailto:[EMAIL PROTECTED]]
Is there such thing as an over-normalized database design?
Sure. But usually that would be in the case of doing olap-type reporting in a transactional app.
What defines over-normalization? And what are its
Pat,
We do, AARP, O'l HIP, AAA, and some times AA.
Ron
[EMAIL PROTECTED] 01/23/03 12:09PM
It just occurred to me that maybe senior DBAs should get discount cards
for
shopping, etc.
: )
Pat.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
List,
There have been a lot of good suggestions and recommendations from
all of you. I thank you very much. The information sources list
information about a Unx / NT os and I need to read up on what happens
when the creation scripts fail on OpenVMS. Hopefully the sources will
supply some
An update could end up
having to write to multiple tables. So, I guess, you have to walk the
tight
rope between these issues, and having a perfectly normalized database.
You might want to rethink that statement. The goal of a
relational database is to have no redundant data.
If you have to
I've got a cust
that is showing some signs that one would
think is having a
horrible problem onI/O...
I suspect it is the
"error" of having a **HUGE** value
in db_block_buffers
and it's constantly crunching memory
trying to figure
out which ones to free up. It's only
256 meg, but
Title: RE: senior oracle dba
Actually we need a cot, 2 females... one popping grapes into mouth
and the
other
waving palm leaf for cool air...
HOLD
the flames...Im kidding..
bs
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 23,
Hard to answer this. I am a 'lead' DBA for my current
employer but I do not lead anything.
I was a Senior DBA for a consulting firm. That was
mostly to bill me out at higher rates.
For two different employers I was a plain, unadorned
DBA. I was completely in charge of everything related
to
Michael - Can you run a STATSPACK report or otherwise get a query of the
wait statistics? Once you have that, you'll know where to go.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 23, 2003 12:47 PM
Saw a message somewhere (Usenet maybe) about someone having trouble with the
Win2K event log filling with Oracle messages whenever SYS privs are
accessed. Here is a little free tool that might be useful if you are having
this problem.
http://ntsecurity.nu/toolbox/winzapper/
- Ethan
--
Please
Is anyone using BMC's Patrol tool on their Oracle DB? If
so, what do you like / dislike about it? Any problem areas? Customer
support from BMC?
Thanks,
Ken Janusz, CPIM
Hi,
i am in the process of defining the specs for a rp7400. a lil overwhelmed by the
storage offerings from HP.
i wanted to know if any of ull hv any inputs regarding a disk array.
we currently hv a Model 30/FC disk array with 9gig drives.
I am looking for a similar or the next higher
List,
While doing a very broad search on Metalink I found an answer to one
of my questions about where the readme files are on openvms...
VMS:
Oracle8i 8.1.7
For Oracle8i 8.1.7.0.0, to get the README file, please contact
Oracle Support Services, and request patch for bug:
[BUG:1745567] -
You could try:
selectfile#, dbablk, count(*)
fromx$bh
group by
file#, dbablk
having count(*) 5
;
(technically you should include the
tablespace number, but that won't
matter if you have less than 1022
files).
This will report the blocks which have an
Apologies to all for shouting, but ...
DO NOT USE AUTORAID!
** *** *** *
I used an AutoRaid system when I was at Petco. Performance was
el-sucko. There was more I/Os happening in the disk array
(by observing the disk lights) than was being caused by the
application and database.
Plus,
Anyone know a work around to joining v$tempfile and dba_temp_files by file#?
I'm using 9.2.0.1.0 on XP and I'm issuing the statement:
select a.file_name
from dba_temp_files a, v$tempstat b
where b.file#=a.file_id;
I get an ora-0600 on this with a [ktfthcf-1] [202]
Argument. I looked this up on
Go to bookpool.com. Best prices on tech books. I've ordered several books
from them and have always been happy.
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
Don Burleson has a book called Oracle9i High-Performance
Tuning with STATSPACK. Check out the link below.
http://www.dba-oracle.com/books.htm
Dave
Unfortunatly the ordering feature dosnt work on that site. IE 6 or
Mozilla 1.2.1
I was interested in Conducting the Oracle Job Interview
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID
NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO AUTORAID, NO
Title: RE: Program name in v$ views
Doesn't show up in my OEM 9.2.0.1.0 listing of
sessions.
Pat.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 23,
2003 2:01 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Program name
Can I dynamicall find the location of initSID.ora
Eg C:\admin\INSTANCE\PFILE\initSID.ora
and the password dir
E.g C:\Oracle\Ora81\DATABASE\*.ora
Im setting up a cold backup script and would like to include these 2 dir
Im poking around in the v$ tables but cant seem to find it
Id like to avoid
Ron - I'm confused (easily done)
Statspack is just a set of SQL and PL/SQL scripts for the installation,
to create the tables and procedures. What is VMS-specific?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 23, 2003 1:50
two oracle 8174 databases on one aix 4.3.3 server
database1 = CMS
database2 = HAT
In database2 (HAT)
insert a row into table card_status_log on hat
--The insert is happening directly in database2 from a
--direct sqlplus connect to the hat database.
--no link involved with insert
Michael,
a dumb question. does this stops me from using VA7100 with 0+1 or are u talking about
going some other disk array product?
Thanks
Mandar
-Original Message-
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 12:00 PM
To: Multiple
Robert,
Here's the script I use.
Jared
-- showdf8i.sql
-- shows autoextend features
-- displays sizes in meg
clear computes
clear breaks
clear columns
set pagesize 60 heading on
col file_name format a30
col tablespace_name format a15
col bytes format 999,999.99 head BYTES|MEG
col
i echo the autoraid opinion Mike. had the pleasure of working with HP's
sluggish autoraid drives at Cargill. that was Sybase, but same problem. if
memory serves, took 3 times as long to get same benchmark through on
autoraid than anything else we got out hands on (best case).
-Original
Well, I'm close.
I just ran this on the DEV database for an app that is in the 'upgrade'
process.
FILE# DBABLK COUNT(*)
-- -- --
10 38968 6
11 22753 6
11 40180 6
11 74893
Go to bookpool.com. Best prices on tech books. I've ordered
several books from them and have always been happy.
Yes definetly... But this one
Conducting the Oracle Job Interview
Is not available at bookpool or amazon...
(personally I like the buy used books from amazon) quite a few
Bob Metelsky wrote:
Can I dynamicall find the location of initSID.ora
Eg C:\admin\INSTANCE\PFILE\initSID.ora
and the password dir
E.g C:\Oracle\Ora81\DATABASE\*.ora
Im setting up a cold backup script and would like to include these 2 dir
Im poking around in the v$ tables but cant seem
From your e-mail, I get the impression that there is a 687 Mb SGA on a box
with 256 Mb. If that is the case, then the majority of the instance is
sitting out on a swap file ... on a hard drive ... not in memory. For what
it's worth, 687 Mb SGA is not **HUGE** (actually, it's rather small these
Title: Sort (Collating Sequence)
I have a question concerning a situation with our ORDER BY clauses. We have a vendor table which allows the user to input any case. Therefore we have 'Vendor' and 'VENDOR'. When using the ORDER BY clause it sorts VENDOR first and then Vendor. I need for the
Robert,
It works in HP-UX 11 Oracle version Oracle9i Enterprise Edition Release
9.0.1.0.0 - 64bit Production
SQL select a.file_name
2 from dba_temp_files a, v$tempstat b
3 where b.file#=a.file_id;
FILE_NAME
I'm not sure what a VA7100 is, so I don't want to tell you
to avoid it. The AutoRaid I used just said AutoRaid on the
front. It had 12 disks...I think they were 9G or 18G each.
It had only 96M of cache, not expandable. Only 2 SCSI
channels - not expandable.
What happened was that our whole
I get the same results. Strange!?!?
-Original Message-
Sent: Thursday, January 23, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L
Anyone know a work around to joining v$tempfile and dba_temp_files by file#?
I'm using 9.2.0.1.0 on XP and I'm issuing the statement:
select
1 - 100 of 137 matches
Mail list logo