Any Oracle Tools Comparable with OEM having
Free Evaluation Copy or Freeware for Download ?
Any names , Links etc ?
Thanks
This is very easily explained once you consider that a "transaction" can
consist of many "statements" - some of which may not have been issued to
Oracle at this point in time. Oracle is obviously trying to be polite by
allowing already started transactions to complete.
Of course it would make co
I know it is not usual, but because ASCII version of the note looked very
ugly, I decided to attach HTML. You can start with stoning as soon as I
say "Jehova".
On 2003.07.31 17:44, [EMAIL PROTECTED] wrote:
What's elapsed_time in v$sqlarea? I believe this was introduced in Oracle
9i. What is the uni
V$SQL" Reference Note
* The information here contains the view description from the Oracle9i
documentation along with any additional Support / Historical Notes related to
this view.
* Earlier versions of Oracle may not include all columns. to see
Documentation references for this view
What's elapsed_time in v$sqlarea? I believe this was introduced in Oracle
9i. What is the unit for it? Strangely, the Oracle 9i "Server Reference"
manual seems to have missed this altogether.
I executed a query, the execution time of which was approximately 9
seconds. But when I look up v$sqlarea
If the union performed index lookups, but the table example performed a full table
scan it might. Of course with iterative index usage the point is deprecated. However
before they were introduced the first query would perform an FTS even if emp_type was
the primary key. Even with iterative i
I've used a UNION where I wanted MIN and MAX from an indexed column:
select max(dspnd_date), min(dspnd_date)
from dwcorp.t_claim partition (p_200206)
SELECT STATEMENT Hint=CHOOSE
SORT AGGREGATE
BITMAP CONVERSION TO ROWIDS
BITMAP INDEX FULL SCANX_CLAIM_N11
Note the bitmap index fu
I'm getting back to work on my union article, and I have yet
another union question. Are there ever cases where a UNION
might be used for performance reasons? For example, I could
write:
SELECT *
FROM emp
WHERE emp_type='HOURLY'
OR emp_type='CONTRACT';
or I could write:
SELECT *
FROM emp
WHER
Title: RE: Oracle to MSSQL conversion?
What SQL Server calls databases I think of them as schemas in Oracle.
Suhen
-Original Message-
From: Wolfe Stephen S GS-11 6 MDSS/SGSI
[mailto:[EMAIL PROTECTED]]
Sent: Friday, 1 August 2003 4:10 AM
To: Multiple recipients of list ORACLE-L
Su
Title: RE: Oracle to MSSQL conversion?
Wolfe
Knowing SQL Server and moving to Oracle is going to be tough.
The other way round is very simple though from Oracle to SQL Server.
Every database functions differently in many respects.
Best is not to compare the both and try and learn the conce
List,
Below is the description of a locking problem I ran into today. Any help
to figure out what was happening here would be appreciated. Maybe
I was overlooking something obvious, but I hope not. :)
An MS Word version is available at:
http://www.cybcon.com/~jkstill/CIM_enqueue_wait_2003_07
My brain is not working todayI cannot figure out how to allow one user
to look at the source code (i.e. trigger_body) for a trigger owned by
another user. The fact that there is an all_triggers view leads me to
believe that it must be possiblebut I can't figure out how to do it and
I have
What does the trace file says on the server ??? do you see a ora-7445
trace file?
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can h
Mike,
This means that the same query was executed at least twice with a slightly
different executing environment which caused the optimizer to choose a
different execution path. See ML Note 1013747.102.
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT dese
Another way to is to install the 'opatch' utility (needs Perl;) and use 'opatch
lsinventory'.
- Kirti
--- Pete Finnigan <[EMAIL PROTECTED]> wrote:
> Hi,
>
> have a look at $ORACLE_BASE/oraInventory/logs/installActions.log.
> hth
>
> kind regards
>
> Pete
> --
> Pete Finnigan
> email:[EMAI
All my e-mail was sys$hosed last night so could you please resend any and
all responses to this since last night.
Anybody run into a situation where you see optimizer_mode equal
multiple_children_present when the optimizer_mode is set to choose in the
init*.ora file ?
If so, did you follow up
Jack,
Sorry for being unclear: I meant how long would it take to actually
create 50k triggers in the database. It shouldn't take long to generate
the trigger code, but creating 50k triggers sounds kind of interesting.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/31/2003 10:59 AM
Scott,
Rap is a synonym for the contents of the septic tank.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 6:04 PM
To: Multiple recipients of list ORACLE-L
I thought "Bass" and "Rap" were synonym
Thank you very much for the detailed info!
Ron
-Original Message-
Sent: Thursday, July 31, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L
Provided we are talking cost based optimizer, then the order of the
predicates in the where clause does not matter - except under very rare
c
Correct.
As for your second question, I have no idea!
--- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote:
> : )
>
> So an MS SQL "server" = an Oracle "instance"
>
> An MS SQL "database" = (roughly speaking) an Oracle "schema".
>
> An MS SQL "file set" = (roughly speaking) an Oracle "tablespace
Provided we are talking cost based optimizer, then the order of the
predicates in the where clause does not matter - except under very rare
conditions to break a tie. Nor is the order of the predicates in the where
clause related to the order of the columns in the index. The only thing
that mat
I thought "Bass" and "Rap" were synonymous? Or am I out of touch with the
current music scene?
Scott Shafer
San Antonio, TX
210.581.6217
> -Original Message-
> From: Nick Wagner [SMTP:[EMAIL PROTECTED]
> Sent: Thursday, July 31, 2003 4:24 PM
> To: Multiple recipients of list ORACLE-L
look at
http://www.dba-village.com/dba/village/dvp_papers.PaperDetails?PprIdA=602
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 31, 2003 12:34 PM
> Hi All,
>
> I want to log the oracle error code and messages that will be g
Hi!
I haven't seen this issue before, but it seems like
a bug. Check for .trc files in your user_dump_dest.
The contents are probably quite cryptic, but you
can send it to Support through Metalink.
Tanel.
- Original Message -
From:
Ed Lewis
To: Multiple recipients of
Related question would be : If in a composite index of 6 fields if the second column is null then would it be able to use the index for the rest of the four columns. How would it handle that. Assumption : First column is not null which would make it choose the index.
IS it possible that somethi
oops looks like i missed "using package ..."
part in doc and shoot the question . Not this makes little sens
;)
sorry guys .
-ak
- Original Message -
From:
AK
To: [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 1:41
PM
Subject: global context
We used to have
What's elapsed_time in v$sqlarea? I believe this was introduced in Oracle
9i. What is the unit for it? Strangely, the Oracle 9i "Server Reference"
manual seems to have missed this altogether.
I executed a query, the execution time of which was approximately 9
seconds. But when I look up v$sqlarea,
Title: Message
Yes,
the first column on each table is the column referenced in the SQL. They
all have indexes on the first column.
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, July
31, 2003 3:59 PMTo: Multiple recipients of list
Hi!
Yep, I've seen it a lot during trainings, that students are trying to use
arrow characters in sqlplus on unix terminal.
And that leaves non-printable chars into sql command. Copy&paste clears them
out.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROT
We used to have roles enabled by application front
end . That was not secure . Then oracle provided passwords for role . We
embedded passwords into apps . They say its still not secure .
Now go for contexts and enable policies.
In oracle 9i you can have global context which can
be enabled b
AK
The only thing that comes to mind is maybe a non-printing character gets
in there and the process of cutting and pasting somehow cleans that
character out. My approach would be to put your SQL in a .SQL file and run
it as a script. See if it happens then. If it does, you can inspect the file
Thanks... I think... except I'm not sure how to calculate that?
Nick
-Original Message-
Sent: Thursday, July 31, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
Hi,
It is just combination of Base and Wrap. So your number will be
8589934593
KG
--- Nick Wagner <[EMAIL PROT
grant create any trigger to xyz ;
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 31, 2003 12:59 PM
> My brain is not working todayI cannot figure out how to allow one user
> to look at the source code (i.e. trigger
This is happening 3rd time with me so I have to
figure out what's wrong . When I issue the given sql first time i get
an error as shown . After that I copy and paste it again and it works second
time . Any clue what should be the reason ? btw, it happens with any sql ..not
just this one . I
I *really* hope this isnt one of those dumb question (due to the limited
responses)
Or maybe Ive stumped our contestents today
;->
Here is what I have based on Tanels suggestion
--C:\oracle\ora817R3\bin\svrmgrl.exe
command='@C:\oracle\admin\LOC\ADHOC\startstandby.
[startstandby.sql]
Sqlplus
> What would be the point of installing two SQL Server
> "servers" on the same box? Similar to setting up 2 or more
> instances on one host?
No point that I can think of, I just know it can be done.
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DS
Thanks. v/r means Very Respectfully
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
> -Original Message-
> From: Paul Baumgartel [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 31, 2003 1:14 PM
> To: Multiple recipients of list
Hi,
It is just combination of Base and Wrap. So your number will be
8589934593
KG
--- Nick Wagner <[EMAIL PROTECTED]> wrote:
> Internally, Oracle represents SCNs as a base and a wrap. The wrap is
> a 16-bit number and the base is a 32-bit number. A dump of a redo
> log file would display the S
Title: Message
do you have corresponding indexes on referenced columns on T1-5
tables ??
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
> All my e-mail was sys$hosed last night so could you please resend any and
> all responses to this since last night.
>
> Anybody run into a situation where you see optimizer_mode equal
> multiple_children_present when the optimizer_mode is set to choose in the
> init*.ora file ?
>
> If so,
Ron,
It has been my understanding that in order for the conpound index to
be used the query had to match the order the index was created. Multiple
indexes would not do a whole lot of good for you just make the optmizer
work harder to figure things out. It would add a confusion factor other
wise ho
A - For tables, you can turn on auditing. If you are on Oracle9i, there is a
monitoring feature for indexes you can turn on.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, July 31, 2003 12:49 PM
To: Multiple recipients of l
Title: Message
No
answer for that.
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, July
31, 2003 3:44 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: HELP! Index Debate!
How does one know that only one column is being used
Title: RE: HELP! Index Debate!
How does one know that only one column is being used in an index and others are being ignored ... ?? This is new to me.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views e
Please help resolve this dispute.
We have a query that runs over 5 hours. Sections of the query are
listed below.
The table QOH_DAY_FACT table had only on index and that was on the
TIME_ID column. I propose adding an index with PROD_ID, WHS_ID, LOT_ID,
WHS_LOC, TIME_ID and QUALITY_ID. My test
List:
I'm testing an upgrade of a database from 8.0.5 to
8.1.7.4 (Solaris 2.6).
I have 3 objects in the 8.0.5 database that are type#
10 in obj$. The objects do not show up at all in
dba_objects. The objects apparently came from someone
applying statspack to an 8.0.5 database.
8.0.5 doesn't c
If you look at the source of the ALL_TRIGGERS view (at least in 8i), you'll
see that the CREATE ANY TRIGGER priv is needed for a schema to see triggers
of another schema. Since this probably isn't what you want, you have some
options:
1) GRANT SELECT ON DBA_TRIGGERS TO your_schema;
2) Reverse
Mladen you're crackin me up, dude! That looks good except for the
reading part...
-Original Message-
Sent: Wednesday, July 30, 2003 12:19 PM
To: Multiple recipients of list ORACLE-L
No, that's the wrong way. The right way is to read first 3 pages, then
try it out, using your production d
: )
So an MS SQL "server" = an Oracle "instance"
An MS SQL "database" = (roughly speaking) an Oracle "schema".
An MS SQL "file set" = (roughly speaking) an Oracle "tablespace".
and data files are data files.
Is that correct?
What would be the point of installing two SQL Server "servers" on th
Jay
I hope my reply didn't sound harsh. You are right, it is always a good
idea to briefly describe what you've tried since that will allow everyone to
make better use of their time. I was just trying to point out one of the
great benefits I've derived from the experts on this list (and I don't
Ok It looks like the disconnect is for 9i
>From metalink
"
This recover command must be ended from a different session with
"recover managed standby database cancel". There is a timeout=n option
to the recovery command which will cause recovery to end if a new
archive log is not received in n minu
Title: RE: logging oracle error code and message into a table within procedu
sorry
should be ...
insert into error_log (error_ts, ora_user, error_text, call_stack) values (sysdate,
user, szerrors,szcalls);
Raj
--
Hi,
have a look at $ORACLE_BASE/oraInventory/logs/installActions.log.
hth
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
--
Pl
Title: RE: logging oracle error code and message into a table within procedu
create or replace log_errors (in_errors varchar2, in_calls varchar2)
is
szerrors varchar2(1000) := dbms_utility.format_error_stack;
szCalls varchar2(1000) := dbms_utility.format_call_stack;
pragma autonomous_transact
So ya wanna do a little omniback eh?
Omnidb -rpt -last gets you all yesterday's backup sessions.
What you will see here depends on how your shop decided to setup
backups. Filesystem is one way. Basically omniback backs you up mount
point by mount point. Host based is the other way. Backup t
Hi All,
I want to log the oracle error code and messages that will be generated
within a procedure/trigger
into a table.
I know i can write this in the exception block.Does anyone has any sample
code to help me out.
thanks
ravindra
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
Internally, Oracle represents SCNs as a base and a wrap. The wrap is a 16-bit number
and the base is a 32-bit number. A dump of a redo log file would display the SCN as
0x.. However, the SCN is represented as a number in a number of the
dynamic performance views (v$log.first_chang
Hi,
We have a query which
uses
a "union all". After upgrading
to
a patch release of Oracle this query
no longer works. We get the
following error :
ERROR at line 1:ORA-03113: end-of-file on
communication channel
ORA-24323: value not allowedError accessing package
DBMS_APPLICATION_INFOE
Without a platform, version or other info, it's hard to say. On an HP/UX
11.0 machine running Omniback II vA.04.10, at least, you can look thru "man
omniintro" to find the location of log files. However, those logs don't
generally contain what was backed up. That's stored in the Omniback
databas
Title: Message
I'd
vote for the middle option. Veritas AC for RAC is hideously complex and
there's about a million ways to be running on it even though the config is
fundamentally broken. It could also be the clustered file system, of
course, since cluster file systems are Hard Problems
One way that might work is to use the translate function. For Example:
SQL>r
1* select
translate('&numberstring',1||translate('&numberstring','0123456789','
'),'1') from dual
Enter value for numberstring: 89_.
Enter value for numberstring: 89_.
old 1: select
translate('&numberstring',1||trans
Does it make a deal?
SQL> select translate('#33',
'1234567890#,_', '1234567890') from
dual;
TR--33
-Original Message-From: Liu, Jack
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 2:10
PMTo: Multiple recipients of list ORACLE-LSubject:
Change nuber.+# to number
Except that:
1) five disks was not one of the possible answers, and
2) we don't know that the database is in archivelog mode.
For the 9i OCP examination the correct answer is answer number 4 (4 disks). I'm
willing to bet on it!
> -Original Message-
> From: Ron Yount [mailto:[EMAIL PROTECT
Title: Message
That
point was not disclosed. Personally, I vote for the
later.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Orr, Steve
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 11:59
AMTo: Multiple recipients of list ORACLE-LSub
An SQL Server instance IS the Server...
-Mensaje original-
De: Boivin, Patrice J [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 31 de julio de 2003 13:39
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Oracle to MSSQL conversion?
I haven't heard of an SQL Server instance before...
Hi,
Is there an easy way to find out if a table or an index is being used. I mean short of going thru all code or keeping looking at v$sqlarea. I mean even if code is covered there are always ad hoc SQL queries etc. Same for other objects like views etc. Is there a place where oracle stores obje
Jared,
Yeah, I'm sure our Developers complain to their boss "That dang DBA's
Jacking with my application again." ;-)
Actually, it would only take as long to generate the 50k triggers as it
would to loop through the list of tables in a PL/SQL procedure and
generate/execute the Dynamic SQL "Cr
Hi,I want to get rid or
those special char in a number string to a pure number, for an instance, from
89_. or 99,9 to 89 and 999.Which function should I use in SqlPlus?Thanks
a lot,
Jack
Change nuber.+# to
number
Yes, MSSQL is running as an instance and you can multiple instances on
the same server (that is W2K or 2003 server), each instance is SQL
server consuming it's predefined resources. Each instance of MSSQL can
be servicing different databases.
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manag
I think I understand what you have said, Oracle runs an instance per
database where MSSQL is one instance running multiple databases. Is
this right thinking?
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
> -Original Message-
> F
The same is not true when you take tablespace offline with normal option . I
just tested that if a transaction is pending then oracle waits before
marking tablespace rea only BUTTT if x-saction is pending and I issue
"offline normal" it succeds . Doesn't offline normal also checkpoints
datafile ?
I haven't heard of an SQL Server instance before... do you mean a SQL Server
server?
(this is getting a bit confusing)
Patrice.
-Original Message-
Sent: Thursday, July 31, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
> Maybe now is a good time for me to ask these question sinc
Had a couple of minutes so ...
The syntax you need is (cryptically enough) :
# Comment
Cheers,
Mike Hately
-Original Message-
Sent: 31 July 2003 16:50
To: Multiple recipients of list ORACLE-L
Jay - I don't think the exp and imp parameter files have provision for a
comment. But you coul
Is sar on AIX setuid? If so, that could be where the reluctance stems
from.
Thanks,
Matt
--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Hi!
I have used # for that.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 31, 2003 7:34 PM
> Hello:
>
> Does anyone know if you can create a comment in a import parameter file?
>
> If so could you provide a sample of t
Hi!
Try:
recover managed standby database disconnect;
This should spawn a separate process for recovering.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 31, 2003 5:54 PM
> All,
> I have a question of how to auto start
Dennis:
I have tested through most of the common formats already, that is why I
asked for help from the list.
Your advise about testing is noted, but in this case based on incorrect
assumptions.
I used most of the major comments in PL/SQL, Java, etc.
Though I missed trying the #, which per Barbara
Thanks John. I've used sudo, just not sure where sar is equivilent to 'full
root access'.
Henry
-Original Message-
Hallas, John, Tech Dev
Sent: Thursday, July 31, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L
Normally sudo is used to grant limited permissions.
The SA would all
An Oracle instance does not correlate to a SQL Server database.
An Oracle instance is a running Oracle server, i.e., a set of
background processes and a System Global Area in memory. It is what
permits applications to _access_ the database. The database is on
disk, the instance in memory.
An
> Maybe now is a good time for me to ask these question since it is
> related to this thread's subject, can you say that an Oracle
> instance is
> essentially the same as a MSSQL database? I ask this because a MSSQL
> server can support multiple databases which can be configured
> different
> ways
Thursday, July 31, 2003, 12:09:24 PM, you wrote:
BB> you're likely to say some VERY
BB> bad words that might get you escorted out of the
BB> building.
I thought those words were a necessary incantation, to make
our databases work. Else why would we say them so
often.
Best regards,
Jonathan Gen
An Oracle database with multiple applications using different schemas in
the same database would be close to the SQL Server model.
Ron Smith
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L
Being more of a SQL
Jay - I don't think the exp and imp parameter files have provision for a
comment. But you could try common comment formats and see if you find one
that works. The person who wrote the parser might have added that but it
didn't end up in the documentation. I notice testing is a habit of the more
exp
Normally sudo is used to grant limited permissions.
The SA would allow you to use sar and for you to access it you would type
sar
and be prompted for a password and you would enter the appropriate password.
John
-Original Message-
Sent: 31 July 2003 16:45
To: Multiple recipients of l
# your comment goes here
# another comment
# Bla bla
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hos
Beacuse of the outer join, the optimizer had to ignore the inlist predicate
and therefore the filter factor for the table became 1 (= all rows),
manifested in TB_SEL 1..
At 06:29 AM 7/31/2003 -0800, you wrote:
Thanks to Wolfgang for spotting the problem. It was not the inlist
iterator at al
Hello:
Does anyone know if you can create a comment in a import parameter file?
If so could you provide a sample of the syntax.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jay
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcit
Title: RE: rebuild index -initial extent - magic??!!
Rebuild will use the same initial extent as it was before but will change
the next extent size. Either drop and recreate index
or You can also think about using Locally managed Uniform
Extent size tablespace, that way you dont have to worr
While Metalink is up and working, it's sporatically
dropping out.
A word to the wise. If you're about to spend a chunk
of time updating a TAR, do it in a text editor, SAVE
it, copy it into your TAR, then update.
If you spend 30 minutes updating your TAR, push the
update button, and get an "a
What we found is that it doesn't matter which tablespace the session
causing the wait is accessing. As explained to me (by Dan Fink I
believe), Oracle doesn't KNOW if that transaction will involve the
tablespace you are trying to make read-only or if it will not. So
rather than take a chance, the a
Just got this email from my SysAdmin when I asked for access to sar. Anyone
know what he is talking about? We are on AIX 4 and 5.
"I cannot give you direct access to the sar command. Because of the
parameters
the command allows, it would be equivalent to giving full root access.
If you could giv
Title: Message
Thanks
for the " rumor gossip" Dick,
Is
this in reference to the Veritas clustered file systems technology? Or the
Veritas Cluster Manager product? Or a file systems manager
person?
Curiouser and curiouser...
-Original Message-From: Goulet, Dick
[mailto:
Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5).
At my installation I have 5 SQL-2000 database machines and recently
acquired three Oracle 9i machines.
The limit is essentially a function of your storage area and the amount
of real memory available to the processor or processo
Title: Message
I set
the value to 2147483648 and it still does the same thing.
Oracle
database is open but when trying to connect through sqlnet I get
ORA-27101.
I do
shutdown immediate and startup and the problem is gone for a
while.
I now
stopped the archiver again and see if tha
You might like to buy the ebook "SQL Server 2000 for Oracle DBA's"
by Chris Kempster: http://www.chriskempster.com/
I bought it, printed it and had it bound at Kinko's.
Appears to be a very good book, though I've only read parts of it.
Jared
On Thu, 2003-07-31 at 02:34, Denham Eva wrote:
> He
Rachel ,
Thanks for the Reply . On checking further I found that this session was
waiting on a lock from another session . But the table or object which was
locked by other session does not belong to this tablespace . Then why does
the read only operation waiting for the lock to release ?? Does it
Our Prod SAP system has 4 RAID1's dedicated to redo of 500m each
on an Clariion CX600 SAN.
Several groups with 2 members each. That's 600 gig
of physical disk dedicated to redo, and nothing else.
Jared
On Thu, 2003-07-31 at 04:59, Boivin, Patrice J wrote:
> We use a SAN.
>
> Where does that
You may find it easier to just run the "Oracle Home Selector"
that appears in the Startup->Programs->Oracle Installation Products
menu.
It has the benefit of also modifying the PATH variable.
Jared
On Thu, 2003-07-31 at 07:54, Charu Joshi wrote:
> RE: ORA-03115 (TOAD question!!)Hi,
>
> It work
Remember that initial_extent and next_extent in dba_indexes (and
dba_tables) records what you requested in your storage clause - NOT what
Oracle actually allocated. You need to look at dba_extents for tha.
At 02:34 AM 7/31/2003 -0800, you wrote:
If this is true:
The rebuild creates a new tempo
1 - 100 of 139 matches
Mail list logo