They most definitely non indexed will have influence on the CBO - there is
the ANALYZE FOR ALL COLUMNS option anyhow, that is there for that reason. I
think also likely used in conjunction with histograms on fields - DSS / Data
Warehouse :
Regards
Sam
-Original Message-
Sent: Saturday,
Dear All,
I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?
TIA
Nosie
--
Please see
Dear All,
Question is: Oracle will startup automatically when the NT server will
reboot.
Currently I maually write the strtup command when the server will reboot
But in control panel my service "oracle startup SVKH" is automatic.
Where SVKH is Instance name.
Please tell me where you can d
Initialization parameter: open_cursors
(select * from v$parameter where name='open_cursors')
The number of cursors currently open:
select a.sid, b.name, a.value from v$sesstat a, v$statname b
where
a.statistic#=b.statistic#
and b.name in ('opened cursors current', 'opened cursors cumulative')
Is this a good time to ask for a book recommendation? ;-)
Can anyone recommend a good source for and idiots' guide to Oracle Standby
Database? I'm working in 8.0, upgrading soon to 8.1, on NT. I'm
experienced with Oracle and basic DBA but not high powered and no experience
of Standby Database.
Hi all,
I am using Designer and while trying to generate a module I am receiving the
following error:
CDI-21600: A running Generator or Utility has failed. It is possible that
the internal cache is now in an inconsistent state. You are therefore
recommended to close and restart the applicatio
If you are talking about the Universal (Java) Installer, then yes I believe
the installation screen is just the same, there are a few different (read
EXTRA) things you have to with UNIX, but they are all mapped out in the
relevant installation guides.
Regards
-Original Message-
Sent: Mon
Thanks Yong,
Exactly what I was looking for! I'll let you and the list know what it's
like when I'm done..
-Original Message-
Sent: Monday, February 05, 2001 05:15
To: Multiple recipients of list ORACLE-L
Hi, Mark,
David Solomon has written a new book "Inside Microsoft Windows 2000"
(
Yes, this is java based OUI (Oracle Universal Installer).
This is same for all platforms NT, UNIX and even VMS.
Cheers,
Rajesh
-Original Message-
Sent: Monday, February 05, 2001 12:00 PM
To: Multiple recipients of list ORACLE-L
Dear All,
I've been working with Oracle on NT for years, n
Hi Saroj,
Just create following registry entry in
HKEY_LOCAL_MACHINE->SOFTEARE->ORACLE
ORA_ORCL_AUTOSTART value TRUE (ORCL is SID name)
If you have multiple Oracle Homes then this entry
should be present in respective Oracle Home only.
You might would have to add another r
how can be output of unix man pages converted to text fomat
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arslan Bahar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet ac
is there anybody who used successfully gcc and proc 8.1.5 together
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arslan Bahar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public I
Hi lists,
I have a very strange situation here.
In db A, I have table T1.
In db B, I have table T2.
I'm trying to create table T3 (CTAS) on db B based on join query between
T1 & T2. We tuned the query to use remote view (because T1 is a very huge
table, while T2 is small table), so we create vie
man SUBJECT > your_file.txt
this will turn the man page output into a file you can ftp to wherever you
want to keep it
Suzanne Davies
Technical Support Officer
London Borough of Barking and Dagenham
020 8227 2737
[EMAIL PROTECTED]
man ls | col -b > ls.man
> -Original Message-
> From: Arslan Bahar [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 2:57 PM
> To: Multiple recipients of list ORACLE-L
> Subject: how can be output of unix man pages converted to text fomat
> )
>
>
> how can be output of
Bull's eye .
Will Check out the Steve Adams' Book & revert
Thanks
> -Original Message-
> From: yong huang [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 10:30 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Waits on latch free for shared_pool & li
select empid, empname, dept
from employees
where rownum = 3546;
When you are looking for scott..
That is pretty unreliable, and I think that is what Bunyamin(?) was getting
at..
Regards
Mark
-Original Message-
Sent: Sunday, February 04, 2001 02:40
To: Multiple recipients of list
Yes , Jusy As you say,Mark ..
Thanks.
Using = seems unreliable to use.
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 1:41 PM
select empid, empname, dept
from employees
where rownum = 3546;
When you are looking f
Has anybody have a automatic startup script for oracle on Solaris? I.e.,
when the box is bounced, the database & listeners can start up automatically
Kind Regards
Johan Locke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johan Locke@i-Commerce Services
INET: [EMAIL
Look in $ORACLE_HOME/bin. dbstart and dbshut will get you there.
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: [EMAIL PROTECTED]
>
-Original Message-
Sent: 05 February 2001 11:20
To: Multiple recipients of list ORACLE-L
Has anybody have a automatic sta
Thank you!
Kind Regards
Johan
-Original Message-
Sent: Monday, February 05, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L
Look in $ORACLE_HOME/bin. dbstart and dbshut will get you there.
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: [EMAIL PROTE
Hi all,
We've developing using Oracle8i and Designer2000 tools.
We've got one major scheme and need a methodology for updating the installed
version with scripts.
For example -
I have my product version 1.0 installed and I want to upgrade it to version
2.0.
I have scripts created by the desi
Title: OT:Thunderstone.com: Texis
Good morning all -
Anyone using this product? If so please email me directly.
(Yes, I am still employed and $50 poorer. It's only money...)
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale,
I have a public database link defined with userid-1.
Userid-1 has update permissions on table-a in database-b.
Userid-2 has no permissions on table-a in database-b.
Userid-2, in database-a, calls a package that contains the database link and
tries to update table-a in database-b.
The result is an
Title: OT:Thunderstone.com: Texis
Yes I
have somewhat, context searches are fast.
You
need to keep three copies of the data and indexes (things get corrupted
easily). If you do alot of updates, you will have the rebuild the
tables and/or redo the indexes all of the time.
But it
is
You should set up synonyms which define the tables@public_dblink in database
b. Put these synonyms in database a. Then anyone can use the linked tables
from the package in database a.
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monda
Surjit,
I think your "hardcore Tera Data" fans are also bigots. I've a friend at
Fidelity Investments where they swear by SUN & Oracle. The last time I talked
to him their datawarehouse was fast approaching 2PB without any problems. They
use all of 8i's datawarehousing stuff like partition
We aren't doing any db work on the Linux platform YET, but we do run one of
our mission critical apps on Red Hat. We have an app that dials every
hotel that we are installed in every night to bring back our
movie/game/service buys and the navigation summary stats from them. This
process was run
On Mon, 5 Feb 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon:
->There are two basic problems with data warehouses that I've seen & it should
->be noted that I'm in the middle of specing a re-wtite of ours. 1) people create
->then in a normalized manner, not in the idea of a s
I posted a question to the list last week regarding this error and didn't
get any responses. I'm trying again. We're on Oracle 8.0.5.2.1, and
Solaris 6.
A few days ago we started receiving ora-07445 errors in the alert log.
This happened when had to reboot the server. If we shutdown/restart th
I owe, I owe
so off to work I go.
Dick Goulet
Reply Separator
Author: "Koivu; Lisa" <[EMAIL PROTECTED]>
Date: 2/5/2001 5:35 AM
Good morning all -
Anyone using this product? If so please email me directly.
(Yes, I am still employed and $50 poor
A little more detail:
I'm setting up a new application database for a customer who has hired a full-time dba. This system is on a Sun 4500 cluster with 2 D1000 disk arrays. This database will be no bigger than 50 gig with no more than 50 concurrent users. The full-time DBA inisists on 1 3gig dataf
Steve,
Thank you so much for taking time to reply. I did run couple of times the
enque_lock script as you suggested. CF waiting is really minimum. I noticed
the maximum enqueue comes from MR which is Media Recovery in share lock.
Should I need to concern this or this is just a very normal symptom
Yeah, but look at the cost of living. Salary
does tend to be reflective how much it costs
to live in that city.
-Original Message-
Sent: Sunday, February 04, 2001 9:36 PM
To: Multiple recipients of list ORACLE-L
Rachel,
$150/hour is an average? Dang, I need to get out of
Kansas City an
I just got a solicitation for this book:
Oracle SQL: The Essential Reference
Reviews anyone?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Glenn Travis
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Califor
Title: RE: ora-07445
you show a file from your udump.
what is in your bdump? including your alert log.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L
Subject: ora-07445
I
I'm sorry. The error is not that the user cannot use the database link.
The error is that Oracle does not want the user to update table-a in
database-b even though the user has update permissions.
Ron
-Original Message-
Sent: Monday, February 05, 2001 8:30 AM
To: Multiple recipients of
Hi,
Why not to use otrace? Of cource, you may need some space to save
trace results, but you'll definitely get complete statistics.
Vadim Gorbounov
Oracle DBA
-Original Message-
Sent: Tuesday, January 30, 2001 3:57 PM
To: Multiple recipients of list ORACL
Hi,
I have a situation where in all the user related
objects (tables) have been created in System tablespace.
I believe there is no convention followed while
creating these tables.
Now, how do I separate these user related objects
and put them in Users tablespace?
Vinay
Hi all,
I have been trying to find some reference on pinning tables in the SGA. I
haven't found anything, all that I am finding is table caching and the keep
buffer pool. Is this all that there is, can I "pin" a table in the memory?
Thanks in advance.
Sincerely,
Kevin Kostyszyn
DBA
Dulc
Title: RE: Async I/O on Windows
It may well be as you said, because Oracle Corporation thinks grouping all
Oracle "processes" into one OS process makes it run faster on NT. But I'd like
to see some kind of official answer from Oracle.
|| I do not have the ability or inclination to make thi
Did you try re-running catalog and catproc and then recompiling invalid
objects? We were getting ora-7445 errors on one of our databases last week,
and this fixed it.
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: o
So, there I am, with an HP/UX server hosting 3 production Oracle DBs. The
node is also running Oracle Intelligent Agent, and I have OEM events to
e-mail/page me if there's problems with productions DBs and servers.
Anyone else running something similar? How do you shutdown a single
production D
Title: RE: Async I/O on Windows
WHOOO a SQLServer vs. Oracle debate
again!!
Come
on guys in the field, lets hear you comments from all those using both in the
field. I personally have been trained in administration on both, and - like you
Ross - have to agree that Oracle is my pers
Title: RE: Async I/O on Windows
"NT
still pants"...LOL!!!
It must be panting alot, It has BLOWN THE DOORS
OFF of "Oracle on Unix" in running
SQLServer on NT, as has DB2.
The
general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org.
Check
out the Top Ten TPC
Here is what I get in the alert log:
Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_15115.trc:
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
Mon Feb 5 12:55:20 2001
Errors in file /oracle02/app/oracle/admi
Larry,
You might want to give this a try using PL/SQL and bind variables.
I don't know if this has changed in 8i, but in 8.x, queries using
bind variables could not make use of histograms ( column statistics )
Jared
On Sat, 3 Feb 2001, larry elkins wrote:
> Sam,
>
> You had the right topic.
Yeah, but Rachel, think of the FAME! Didn't I hear you were
opening for Billy Joel and Elton John in LA on Feb 6?
:-)
Yosi
> -Original Message-
> From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, February 04, 2001 1:00 PM
> To: Multiple recipients of list ORACLE-L
> Su
I run about 20+ databases from one OEM session, albeit on NT, and I never
shutdown the agent when I shutdown a database. You must have OEM sending
email for all events. Just use email for selected events that you want to
know about.
OEM won't freak if you don't shutdown the repository database.
> My problem is that the timestamp, which is just that--no date, is only on
the
> first record of each sample rather than every record and I don't want the
blank
> lines in between the samples. Perhaps this is a simple awk routine but
> I don't know awk well enough to do this.
awk '{ if (N
>>>If I kill IA, OEM freaks, and sends e-mail and pages about all the DBs
and
node being unavailable. If I SHUTDOWN NORMAL the production DB, like a good
DBA, I need to manually kill the DBSNMP processes that are still connected.
If I SHUTDOWN IMMEDIATE, then STARTUP RESTRICT (in order to SHUTDOW
Doesn't your second example say that ' Userid-2 has no permissions on
table-a in database-b'?
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 10:30 AM
> I'm sorry. The error is not that the user cannot use the da
Hi
I am wondering about some results I am getting back when I am querying based
on date fields. I have a large table partitioned on source year. When I run
the following query the results are not correct results, it seems to be
grouping the year incorrectly.
select to_char(landed_dt,''), coun
Title: RE: Async I/O on Windows
LOL!!! Amen!
-Original Message-From: Mark Leith
[mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 12:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
OT RE: Async I/O on Windows
WHOOO a SQLServer vs. Oracle debate
Title: RE: Oracle Vs Tera Data
Surjit,
In my experience, Sun storage ( the A5000 stuff, etc. )
does not do the best possible job.
But, then again, you may be on Fujitsu, EMC, or some
other good storage vendor.
(Dick, liked your comments about normalization and adjustment
expectations
I have taken the stance with one junior that he now
has to prove me wrong in anything I tell him. Loser buys
the beer. He owes me quite a bit right now:-)
-Original Message-
Sent: Friday, February 02, 2001 9:16 AM
To: Multiple recipients of list ORACLE-L
Kimberly,
I could say the sam
Title: RE: Async I/O on Windows
Just
because Oracle hasn't done a benchmark doesn't mean Oracle can't out perform
SQL-Server or DB2. Benchmark is very expensive to do, Oracle doesn't need
to prove to the world every year that it is the best. Oracle has the
reputation that MS and IBM don't
By chance, does
anyone have a script that will reparse a collection of sar statistics, that came
from "sar -d", into a file that can be used by SQL*Loader?My problem is
that the timestamp, which is just that--no date, is only on the first record of
each sample rather than every record and I d
Hi Dick,
A couple of campanies I consult for are using
Linux and Oracle (8.0.5, 8.1.6) as production
databases. Neither is really high transaction volume
but one is holding about 1.5 GB of data.
One install occured because Oracle on NT was choking
No, pinning is for the code: sql, procedures/functions/packages and
sequences. Take a look of the package dbms_shared_pool.
Regards.
> -Mensaje original-
> De: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
> Enviado el: lunes 5 de febrero de 2001 16:36
> Para: Multiple recipients of list
Ross & Mark,
There are no major performance concerns here (and we get
Oracle "free" {system wide educational site license} -
unlike MS/SQL), so what I want to know is: does Oracle8
generally work well on Windows 2000 server (compared to
running it on NT4)? We will be running on this hardware:
Sounds like you more like the backup DBA then just a developer.
Congrs, I believe you wear two hats. Now go ask for a raise.
-Original Message-
Sent: Friday, February 02, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L
You are exactly correct. I as a developer am usually the fi
I recompiled invalid objects, but I haven't run catalog and catproc. I'll
try it and see what happens. Thanks for your help
Ana Choto.
"Mike
Title: RE: Pinning Tables
you pin the table as a namespace entity in the rowcache ( i think ) any
time you use it...it can be flushed, though. None of this is under your
control.
you pin the table as a datasource through bufferpool and CACHE settings.
hth
Ross
-Original Message---
#!/usr/local/bin/perl
# file - sar-d.pl
$sar_out = "/tmp/sar.out";
$sar_dat = ">/tmp/sar.dat";
# a file suitable for SQLLDR is created as /tmp/sar.dat
system("sar -d > $sar_out");
open(INP,$sar_out);
open(OUT,$sar_dat);
$line_cnt = 1;
while () {
if ( ($line_cnt > 4) && (length($_) > 1) )
{
Title: RE: Async I/O on Windows
Well, Oracle does
have all three of the top spots in TPC-C for Non-clustered results...I wonder
how a performance/square foot rating would turn
out...hmmm...
:)
Jeffery StevensonChief Databeast TamerMedical Present
Value, Inc.Austin, TX
-Original Me
Try this:
"It sure would be a shame if all that work you did today were to somehow disappear. It would certainly be nice if somebody brought me a ."
This works pretty well.
-Rocky
Rachel Carmichael <[EMAIL PROTECTED]> wrote:
hm, I like that. I've been working on training people here on the prop
Thanks. I have been saying this for years, but just not limited to Oracle
systems. Nice to have someone agree with you after years of saying pretty
much the same thing.
Daniel Curry
Tsola, Inc.
[EMAIL PROTECTED]
650.486.2624
-Original Message-
Sent: Monday, February 05, 2001 9:02 AM
Hi Joan,
You don't have a problem unless there is a session WANTING a lock on the
resource. By "something interesting", I meant a session waiting for a lock on
either the CF or ST enqueues. Then you run it repeatedly to see how long the
problem persists. Because you are going to run it repeatedly
Ana,
I am trying to remember about this problem 2 years back with 7.3.4 and if I
am not wrong it was application related problem which was fixed by our
developers at that time. It was my previous assignment so I cannot provide
any further details. ORA-7445 is also like ORA-600 for catch all
sit
Moving to TeraData was what caused me to leave my previous position.
The idea that Oracle can't handle Terabytes of data is ludicrous.
Pricing? Plan to spend 5x as much on a Teradata solution.
Star schemas? Take a look at how Teradata does joins on a Star
schema. It's ridiculous. 7-11 has
hm, I like that. I've been working on training people here on the proper
bribes for the DBA, but they are SLOWWW learners.
>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Pondering Quest
What you have found is correct. You "pin" a package or stored procedure and you
"cache" a table.
HTH,
John Carlson
>>> [EMAIL PROTECTED] 02/05/01 07:36AM >>>
Hi all,
I have been trying to find some reference on pinning tables in the SGA. I
haven't found anything, all that I am findi
Actually, not that it matters from what I can tell, but Oracle is tops if
you consider clustered vs. non-clustered. It seems that Oracle doesn't even
have tests for clustered systems. I wonder what happened to the VLDB tests
in the huge DEC/Compaq Alpha cluster?
As far as SQL (pronounced: "SQu
Title: RE: Async I/O on Windows
Well,
that was certainly a interestingly-reasoned response. I
haven't
seen
logic applied like that since...sincesincewell, I have
never
seen
such a display of logic.
Just
to recap, your arguments are:
1)
"Just because they didn't do a benchmar
You can use export/import to move non-sys owned tables to a proper tablespaces.
Eveleen
Please respond to [EMAIL PROTECTED]
"Sanjay Kumar" <[EMAIL PROTECTED]> on 02/05/2001 11:50:52 AM
Message - From: "San
Roerg
the tables, and specify the user tablespace..
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Sanjay KumarSent:
Monday, February 05, 2001 05:51To: Multiple recipients of list
ORACLE-LSubject: User objects in System
tablespace
Hi,
alter table cache;
-Original Message-
Sent: 05 February 2001 15:36
To: Multiple recipients of list ORACLE-L
Hi all,
I have been trying to find some reference on pinning tables in the
SGA. I
haven't found anything, all that I am finding is table caching and the keep
buffer pool
I am running ORacle8i on Windows2000 and for what I use
it for I see no difference from NT.
-Original Message-
Sent: Monday, February 05, 2001 11:06 AM
To: Multiple recipients of list ORACLE-L
Ross & Mark,
There are no major performance concerns here (and we get
Oracle "free" {system w
I believe chr(9).
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
> -Original Message-
> From: Viktor [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 11:57 AM
> To: Multiple recipients of list ORA
You might want to check those results again. Oracle has the top three in the TP-C,
nonclustered results. With the clustered results Oracle has the highest for 1
CPU/client. Everything above them has 2 CPU/client. The configuration is important. MS
SQL Server's configuration for
their highest ra
Only method (which I am aware of ) to pin objects in SGA is DBMS_SHARED_POOL
package. However, this package does not support pinning tables and views.
I am curious if there is a way to pin a table/view.
Eveleen
Please respond to [EMAIL PROTECTED]
"Kevin Kostyszyn" <[EMAIL PROTECTED]>
Title: RE: Async I/O on Windows
Does
anyone know what this error means? What caused this
error?
TIA
SVRMGR> alter database
open;
alter database open
*
ORA-01187: cannot read from file 1 because it
failed verification tests
ORA-01110: data file 1: '/opt/oracle/oradata /system01.dbf'
Let me rephrase it. The user defined in the database link has insert
permissions on table-a. The user calling the database link does not have
any permissions on any table in database-b.
Ron
-Original Message-
Sent: Monday, February 05, 2001 10:11 AM
To: Multiple recipients of list ORAC
Title: RE: ora-07445
nothing before or after?
no checkpointing? no archiving? whats was going
on from, say, 12 noon or so?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
Subjec
Hi DBAs,
Oracle 8.1.6 on Sun; DW environment:
Have a table that gets populated by SQL*Loader and thereafter lots of
queries go against this table using different combinations of 4 columns
(date, varchar2(6), varchar2(5), char(1)). Once a row is processed, the
char(1) column gets updated from nul
What is ascii code of TAB?
Thanks
__
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viktor
INET: [EMAIL PROTECTED]
It is CHR(9):
SELECT column_1||chr(9)||column_2 FROM table_name;
Best regards,
-Ari Kaplan
Independent Oracle DBA Consultant
Founder/CEO, PocketDBA Systems -- Wireless Database Management Now
www.pocketdba.com
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 400+ Oracle tips, vis
> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 9:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: OT RE: Async I/O on Windows
>
>
> Wanna drag?
>
> (heh heh heh)
>
> Well, I'd have to shave my legs, but
I do know there is a way to tell which indexes are accessed most recently by
query x$bh view. Is this what you want or something different? Sorry I forgot
the initial posting of this issue.
Eveleen
Please respond to [EMAIL PROTECTED]
Vadim Gorbounov <[EMAIL PROTECTED]> on 02/05/2001 09:3
^I Dec - 9 Oct - 011 Hex - 09
David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, February 05, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
What is ascii code of TAB?
Thanks
__
Rachel:
I miss a couple of my old jobs where I has other roles (developer/dba and network &
admin/helpdesk/etc) where I got quite a few people trained real well :) I could count
on a snack from several people a week. Although I guess that could be seen from their
side as "We sure got this guy
Title: RE: OT RE: Async I/O on Windows
LOL!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT RE: Async I/O on Windows
> -Original Message-
> From: Mohan, R
Title: RE: Async I/O on Windows
You
may want to run dbverify on this and see if the datafile is corrupted.
-Original Message-From: Tony Guo
[mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 3:12
PMTo: Multiple recipients of list ORACLE-LSubject:
ORA-01187: cannot r
Title: RE: OT RE: Async I/O on Windows
"TPC doesn't really matter"
- You are correct: no single metric covers it all.
But, Oracle is sure all over the ad pages when
it FINALLY manages to get one near the top. Which
isn't often. And right now, hands do
Rocky,
I'm not sure whether this is bribery so much as it is extortion.
Sort of DBAFather-ish ; )
I use the more suble "You owe me a xyx" when the
grateful user/developer is expressing their gratitude
for saving their hiney.
Cherie Machler
Gelco Information Network
Try this:
"It sure woul
Title: RE: Async I/O on Windows
H
- did you mount the database first?
David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED]
-Original Message-From: Tony Guo
[mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 2:12
PMTo: Multiple recipients of li
Thanks! I'm going to check this out.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 9:31 AM
> #!/usr/local/bin/perl
> # file - sar-d.pl
> $sar_out = "/tmp/sar.out";
> $sar_dat = ">/tmp/sar.dat";
> # a file suitable for
see man ascii
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
Hello list,
Is there a possibility to know a specific session's NLS parameters querying
from another session ?
Regards, Radu Caulea
Senior Oracle Consultant
www.caulea.fr.st
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Radu Caulea
INET: [EMAIL PROTECTED]
Fat
1 - 100 of 156 matches
Mail list logo
