I dont want to sound rude here, and my comments are NOT directed at you personally.
What is the standard of these OCP's, when a person who has not worked with oracle, can
pass them, for the sake of discussion it does not matter which tests they were? It
seems doing an OCP is a complete waste
Hello every one,
Hey you know what after a long battle, finally installed SCO 7.1.0 and on top of that
Oracle 8. Thanks to a lot of people, but Kirti Deshpande ( I think ) stands out, you
helped me with some good things.
Actually the whole problem was with the swap, it was too small, so be
On Jun 19, 2001 at 12:17:32PM, Seema Singh wrote:
Hi
If i have one file a.txt and I want to put that content in where clause of
sql statement then how can I do it.
Example :
a.txt content
98989
67676
898989
Select x,y,z from abc
where x in (98989,67676,898989)
/
create file named
From subject line, I thought it's some ad from yahoo.com ;-))
Any-way... Happy SCO+Oracle Learning
Cheers,
Rajesh
-Original Message-
Luthra
Sent: Wednesday, June 20, 2001 11:10 AM
To: Multiple recipients of list ORACLE-L
Hello every one,
Hey you know what after a long battle,
Direct I/O is enabled simply be specifying in the
mount options in /etc/vfstab (on Solaris). You can do
it even with standard ufs volumes. As long as you
have vxfs then you can also have vxfs with direct IO
Quick I/O is the separately licensed bit I think - it
should also outperform Direct
Options
1) external account, sqlplus /
2) delay connection sqlplus /nolog with connect
... in the script
3) print password | sqlplus system
hth
connor
--- Kris Austin [EMAIL PROTECTED] wrote:
hi,
do you know how to hide oracle passwords from ps
-ef? we pass in our pw in
cron,
If you are going to that level for performance
reasons, I would seriously consider using raw
partitions to avoid the issue.
hth
connor
--- KC [EMAIL PROTECTED] wrote: Kevin,
Thanks for your input. I was trying to put certain
datafiles on contiguous disk space, tell me if I am
wrong, I try
On Jun 19, 2001 at 11:15:46PM, Vladimir Begun wrote:
On Jun 19, 2001 at 12:17:32PM, Seema Singh wrote:
Hi
If i have one file a.txt and I want to put that content in where clause of
sql statement then how can I do it.
Example :
a.txt content
98989
67676
898989
Select x,y,z from
I've seen very successful systems on Solaris, HP, AIX
and Sequent. I've seen disasters on Solaris, HP, AIX
and Sequent. I honestly don't think that the vendor
is (too much of) an issue (presuming you go with one
of the major ones)
That said, as the Oracle consultants always tell us,
there is
I need some suggesations regarding RMAN. I want to spread the backup in two drives.
one drive has 27GB free space and other has 9 GB free space. How do I divide thru
channel ? I want maximum will go to 27gb and minimum will be in 9 gb . I have used
channel limit facility but it is not solving
Hi
Keren,
I was
same with you, I started from 0% knowledge in computing, I stated as an office
boy cleaning computer showroom Eveready, and then I started leaning how to
install PC 8088 (long long time ago), monochrome monitor and then PC 80286 then
PC 80386 then PC 80486 then Pentium
Hello everybody,
One of my developers is having the following requirement.
* He has PL/SQL stored proc say proc_1 in Oracle database.
* Now within this proc_1 he runs a loop and gets some values in say
variables v1, v2 and v3
* From the loop itself he needs to pass these
Hello , currently I have install TOAD, when I click the sqlnet-help , it
highlight the error l:\oracle\dev16\ is not in system path ? But it did
work ok .I manage to connect to my db server , but why this error come up
???
Actually I 'm network connect with my oracle server locate in other
Hello everybody,
Sorry for the previous post. I think I need to RTFM. It can be done through
Oracle Open Gateway.
I haven't tried it till now. If there are any suggestions then it would be
appreciated.
Regards
Ravindra Channe
Nirmal,
I've not done a tablespace PITR via RMAN, so I can't
help you there. I've done it manually many times and
find the following doc has described the steps needed
very well:
Note: 96197.1 Recovering a Dropped Table from a Full
Database Backup
Essentially a tablespace PITR is accomplished
Hi All,
Basic question:
Just tried to find the restrictions on Oracle passwords in the online
documentation and had no luck
Does anybody know what the restrictions are for the passwords (allowed
characters etc...)
TIA
Jack
Viraj, hahahahah, it couldnt have been said any better :), i've been
thinking that way for years as well as a few others on the list :)
joe
Viraj Luthra wrote:
I dont want to sound rude here, and my comments are NOT directed at you personally.
What is the standard of these OCP's, when a
Dear Viraj,
I can totally understand how you feel.
But I hope you can appreciate that it takes a lot of courage and
perseverance for a person who doesn't know Oracle to take any of the OCP
papers. Many of us have to do a lot of additional studies on top of the
Oracle training material
Ok most of last night putting it on laptop, be prepared for what seems
like eternal swapping if you dont have the RAM, toshiba satellite
2545xcdt laptop, amd k6, 333Mhz, 192M of ram. It finally installed.
Now to hack genclntsh, relink the binaries and build a database. :)
joe
--
Joe Testa
Jack,
This info is in the SQL Reference manual under the
Create User command:
Passwords must follow the rules described in the
section Schema Object Naming Rules, unless you are
using Oracle's password complexity verification
routine. That routine requires a more complex
combination of
I prefer to use externally identified userids. Most of the dba scripts run as / (i.e.
unix user oracle, oracle user ops$oracle). You can also wrap the sql in a ksh script
where password is not known from ps -ef. If I do this, I have 1 common script w/
username/password, 1 place to change,
My first question is what is your field of study in school? Is it computer related?
Have you graduated, many employers want to see you graduate before they will hire you.
Have you asked any of your larger companies about any IS extern programs that they
might have. If you have graduated, have
Thanks.
I'll also try it with 816 and see if it works fine there.
Kumanan
-Original Message-
From: Solomon, Saul M. [SMTP:[EMAIL PROTECTED]]
Sent: 19 June 2001 21:41
To: Multiple recipients of list ORACLE-L
Subject: RE: Transportable tablespace problem in 817
This is a
Vendor=dec (well compaq)
Cost=moderate
Reliable=sometimes, if openvms
Support=good
Positives=cluster sw
Negatives=pc company, not sure of future for vms or digital unix
Vendor=hp
Cost=moderate/high
Reliable=yes
Support=good
Positives=ha mc service guard
Negatives=you are on your own
Vendor=ibm
Connor,
You have confirmed what I believed to be true, you don't need the Veritas
database edition for direct I/O. Just need to convince our SysAdmin now.
KC
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wednesday, June 20, 2001 5:44 PM
Direct
$ echo system/manager |sqlplus @myscript
Alternatively, schedule your jobs with DBMS_BATCH.
Cheers,
g
-Original Message-
Sent: Tuesday, June 19, 2001 7:38 PM
To: Multiple recipients of list ORACLE-L
hi,
do you know how to hide oracle passwords from ps -ef? we pass in our pw
I have often wondered about the pronunciation of the word Yahoo . Is the a long or
short??
Yahoo stands for You Always Have Other Options
Congrats on the successful install.
ROR mª¿ªm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL
Connor,
It would be easy if I am the SysAdmin, our Mr. Unix here doesn't like raw
just because he can't see the files in the file system. I am just exploring
different ways to stripe the disk, I noticed that we made one subdisk for
each disk and stripe the volume on them. This is quite different
Karen,
Does your college or university have a formal internship program?
If they do, a short-term internship might be the way to go. That would
be some experience under your belt. Once you got into a company,
you'd make good contacts there to try to extend your employment
once the formal
Compaq's Alpha and Tru64 platform has been turning in some impressive
Oracle benchmarks, they're definitely worth a look.
g.
-Original Message-
Sent: Tuesday, June 19, 2001 7:38 PM
To: Multiple recipients of list ORACLE-L
All,
For a position that would (possibly) like me to set up
This is what I do
nohup sqlplus /nolog @script script.log 21
The script1 look like the following:
start local_var -- This has the user_name and password defined in it
connect username/password
...
local_var.sql
define user_name=app_owner
define password =pass123
Hope it helps.
Cheers
How do you specify direct I/O option in /etc/vfstab?
Alex Hillman
-Original Message-
Sent: Wednesday, June 20, 2001 4:25 AM
To: Multiple recipients of list ORACLE-L
VxFS
Direct I/O is enabled simply be specifying in the
mount options in /etc/vfstab (on Solaris). You can do
it even
When Creating a Table with a Certain Value of freelists in Oracle 7.3.4
, Error ORA-1590
Occuring
$ oerr ora 1590
01590, 0, number of segment free list (%s) exceeds maximum of %s
// *Cause: storage parameter FREELIST GROUPS is too large.
// *Action: Reduce storage parameters FREELIST
I don't doubt that there are openings available in the Govt sector. The pay scale for
Govt workers is notoriously lower that the open market. I had a job offer to work for
the Dept of Natural Resources in GA but I could not handle the $20K pay cut.
ROR mª¿ªm
--
Please see the official
I agree, if you have no experience and take the exams it will give you some
level of knowledge about oracle. I have started taking these exams and
recognize one issue with getting certified. It's great and all, but it's
like any other test. You can study your arse off and pass with flying
Hey !
I have just replied in the other list. Incase if you
don't get here again..
Looks like you are using 2K block size and trying to
bump the freelists to abnormal limits and getting this
error.
Coming to your question, the structure of freelist
descriptor approximately takes 20 bytes in the
Hi everybody,
I have problems starting a listener on creatded in the net8assistant on Sun
Solaris. When I try to start the listener with the command start in the
LSNRCTL I get the following error message:
TNS-01201: Listener cannot find executable
/opt/oracle/product/8.0.6/bin/mtipdb for SID
FWIW.. There is a discussion topic on http://www.lazyDBA.com on the subject
of OCP (for quite sometime now). There are quite a few interesting comments
from both sides. I have not read them all, but enough. By the sheer volume
of those, I believe it has become a 'touchy' subject for many.
Direct I/O is part of the Database Edition.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, June 19, 2001 8:15 PM
To: Multiple recipients of list ORACLE-L
VxFS
To calculate the storage needed for a table (assuming that all rows will contain all
of the data) use the following formula.
TO DETERMINE THE SIZE OF A TABLE STORAGE
step 1. NUMBER OF ROWS IN TABLE. ---
step 2. NUMBER OF ROWS IN BLOCK.
NUMBER
Am I correct that in 7.3.4 it was not possible to do direct export for
tables with LONG datatypes and there is no such restriction in 8i? I tried
8i and it worked. I checked the docs for 7.3.4 and it does not tell that you
cannot export LONGs with direct option, but I remember 2 years ago I
I think what he wants to do is find out how big a row could possibly be,
for example
CREATE TABLE mytable (
column1 VARCHAR2(40),
column2 VARCHAR2(30),
column3 VARCHAR2 (20));
select table_name, sum(data_length) from user_tab_columns group by
table_name;
TABLE_NAME
Title: RE: Need help getting started
Karen, for what it's worth:
What did you study in college? Studying CSCI in college is absolutely not a prereq for getting into technology but it at least demonstrates that you can think that way. I did study CSCI and I think half of it was a waste of
At 11:15 PM 6/19/01 -0800, you wrote:
What is the standard of these OCP's, when a person who has not worked with
oracle, can pass them, for the sake of discussion it does not matter which
tests they were? It seems doing an OCP is a complete waste of time!
Uh, couldn't the same comment then be
that I know of, the a is pronounced ah (as when the doctor tells you to
open wide and say h)
From: Ron Rogers [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Yahoo!
Date: Wed, 20 Jun 2001 05:11:28 -0800
I have often
Joe, I don't think we've enough information to state that she doesn't
have Oracle running on her Linux machine at home, and hasn't diligently
practiced and studied. I learnt Java in a similar way before getting my
first Java developer job back in '96. I would expect people on this
list to be a
yeah - i went from a .com to govt, 17k pay cut. but heck, i work 4 10 hr days. money
isnt everything :)
[EMAIL PROTECTED] 06/20/01 08:42AM
I don't doubt that there are openings available in the Govt sector. The pay scale for
Govt workers is notoriously lower that the open market. I had a
Position: Oracle DBA
Location: Nashville, Tennessee
Description:
This position is with a highly respected client that needs an Oracle DBA
to provide database support.
Oracle is running on an IBM RS/6000 (AIX).
Looking for someone who can optimize system, knowledgeable about replication,
Here is a quick blurb from Metalink's page on product availability for R11i
Applications. It maybe of some help.
Oracle Platform Roadmap
Oracle's customers deploy data servers, development tools, applications, and
application servers on a short list of
systems. This system consolidation
On Tuesday 19 June 2001 14:45, Deshpande, Kirti wrote:
FWIW .. truss will be available with AIX 5L (this fall, I was
told).
It's about time!
What's up with them anyway?
All the cool utilities that you take for granted on Solaris
and Linux simply do not exist on AIX.
Jared
--
Please see the
How about this simple script:
# Script to check processing
the_pids=`cat a.txt | awk '{printf(%s,,$1)}' | sed 's/,$//'`
sqlplus / EoI
select x,y,z
from abc
where x in ($the_pids)
/
exit
EoI
Short and sweet and simple.
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
i used sql.bsq and it worked
shirish
-Original Message-
Sent: Wednesday, June 20, 2001 6:47 PM
To: LazyDBA.com Discussion
Can you enlighten us with the resolution ?
-Original Message-
Sent: 20 June 2001 14:18
To: LazyDBA.com Discussion
thanks all,,my probs with dual is
thanks all,,my probs with dual is is solved now
Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They only function when they are open
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shirish
Any other UK based listers going to the joint-hosted Compaq/Oracle launch of
Oracle 9i in Reading on the 12 July. Sounds like a good day out. Launch and
demos etc. until 17:30 then entertainment (BBQ and drinks and hot air
balloon rides and stuff).
Cheers
Lee
-Original Message-
Sent:
All the cool utilities that you take for granted on Solaris
and Linux simply do not exist on AIX.
I think that may change, in it's own way... Here is what IBM is saying about
Linux AIX 5L Ver 5.1
(we just have to wait and see ;) More stuff at
Thanks in advance for help, been lurking for a couple of weeks.
I am using sqlldr73.exe to load a text file into an oracle 7.3.2.1.1 table. Field
datatype is number(14,0). What is the correct statement in the tablename.clr file
that will correctly load the data.
The clr file info latest
On Wednesday 20 June 2001 05:56, Christopher Spence wrote:
I like Sun actually, but I think AiX is the best choice money wise.
Comparable computing power on RS6000 is about half
the cost of Sun.
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
Quick I/O is part of the database edition. Direct I/O is a generic mount
option for vxfs artition (standard part of vxfs). Mounting something
convosyn=direct avoids s buffer cache for everything, whereas quick i/o
actually provides an interface for accessing the file as a raw character
device.
Timed statistics has very little performance impact - most of the work is
already done internally anyway. It is very useful - for tkprof, wait
statistics, and a few other things. I always set it and have for years -
even on exceptionally hot OLTP systems. A guy I know from the Oracle Center
of
All,
I just tested changing my password and looking
in the v$sql... views to find my new pw.
As I figured, the statement stops at ident. How
does this work? Does Oracle automatically not
keep parsed pw-changing SQL in memory, giving
up parse time for security? Obviously, you'd
never rerun that
There's a posting from New York City for an Oracle DBA, but
it would involve a minimum 25k pay cut. I have friends who
work for the city and like it, but I just can't see taking
out the 25k.
Money isn't everything, but I've got a bunch of mouths to
feed. I'm not complaining - I thank God every
Try:
SICK_ACCRUAL POSITION(569:583) integer external(14),
VAC_ACCRUAL POSITION(585:599) integer external(14)
Helen
"Johnston, Steve" [EMAIL PROTECTED] wrote:
Thanks in advance for help, been lurking for a couple of weeks.I am using sqlldr73.exe to load a text file into an oracle 7.3.2.1.1
Hi
Has anyone experienced any problems after setting timed_statistics to true
on a prod database (at system level) ?
Can anyone give me a guess as to the performance hit of doing this ?
Running Oracle 8.1.6, there are fairly predictable periods of high, medium,
and low load so I can avoid
--- Hillman, Alex [EMAIL PROTECTED]
wrote:
How do you specify direct I/O option in /etc/vfstab?
Use the forcedirectio mount option in the vfstab.
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
I'll try to implement on 817 some other time after applying the patch that
Saul suggested.
It worked with 816. See below.
Kumanan
Transportable tabblepsces.
Ensure following UNIX environment variables are set for this to work:
NLS_LANG=; ORACLE_SID= ; ORACLE_HOME=
Check dependencies are not
and the UK. I have pretty much upped my salary by about 225% since I left.
One of Her Majestys Disloyal servants :-)
-Original Message-
Sent: 20 June 2001 16:36
To: Multiple recipients of list ORACLE-L
Ron Rogers schrieb:
I don't doubt that there are openings available in the Govt
I was told to Design us a system to use . it was fun.What was
decided on was :
1. AIX on an S70a (biggest at the time)
2. 32 - 2 GB SSA Drives
3. 32 - 4 GB SSA Drives
4. 32 - 9 GB SSA Drives
5. 4 GB Memory
6. 4 Processors
7. 2 5GB Scsi Drives for the System
What this gave us was
1. We
WOW! Adam Eve were DBAs?
Back from hols guys - and now have some 1400 emails to get through so
thought I'd start with the largest thread of the lot - as they are usually
the more FUN! :) Still in holiday mode..
I have to agree with somebody at the start of the thread - it has to be
McCallun!!
Greg,
No, though in early versions of Oracle 8 there are bugs that can trip you up.
At 8.1.6 timed_statistics is stable and low-cost in my experience. I've tried to
measure the performance hit but I've never noticed any difference at all.
I personally wouldn't run without it.
Regards,
Mike
Greg,
In general, the benefits of having timed_statistics set on far outweigh any
(usually negligible) performance hits.
Rachel
From: Greg Solomon [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: timed statistics
Date: Wed, 20
re: Your sig line on parachutes.
Yes, but to be considered properly prepared for use, they must be closed.
-Original Message-
Sent: Wednesday, June 20, 2001 10:06 AM
To: Multiple recipients of list ORACLE-L
thanks all,,my probs with dual is is solved now
Shirish Khapre, SE Rolta
I believe the consensus is there is no substantial impact for running timed
stats and the benefits far outweigh any small performance impact. - E
-Original Message-
Sent: Wednesday, June 20, 2001 8:16 AM
To: Multiple recipients of list ORACLE-L
Hi
Has anyone experienced any problems
Right...so we can cross compile
Linux==AIX under AIX 5.0L?
has anyone out there tried to
compile a Linux binary set
into AIX to run it yet?
-Original Message-
Sent: Wednesday, June 20, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L
All the cool utilities that you take
Hi:
I have been noticing that some of our large tables have been badly
fragmented - running into hundreds of extents. Also a few of them have
chained row counts of over 200 thousand. This is a vendor supplied
application and the tables were not sized correctly to begin with. My task
at hand is
Stephane,
This was very interesting...I am still
perking on this...i have looked at
the dbmsldap package, and admit to some
ignoranceit seems that this PL/SQL
package is good for making calls to
OID (Oracle's LDAP) but I do not
see how these package calls could be
used to access the
All,
Anyone know how to
get a list of tablenames and the count of rows in them
TABLE_NAME COUNT
=== ==
LEE
10
LEE1
25
LEE2
17etc etc
I know it can be
done if the tables are analyzed and from user_tables but was wanting to know how
to do it from sqlplus.
hardly makes a difference anymore, i think it used to be an
issue in early 7 days but no anymore, i dont think you'll even
notice.
joe
[EMAIL PROTECTED] 06/20/01 11:16AM
HiHas anyone experienced any problems after setting
timed_statistics to trueon a prod database (at system level) ?Can
ufs: forcedirectio
vxfs: convosync=direct,mincache=direct
hth
connor
--- Hillman, Alex [EMAIL PROTECTED]
wrote: How do you specify direct I/O option in
/etc/vfstab?
Alex Hillman
-Original Message-
Sent: Wednesday, June 20, 2001 4:25 AM
To: Multiple recipients of list ORACLE-L
or even DBMS_JOB
--- Guy Hammond [EMAIL PROTECTED] wrote:
$ echo system/manager |sqlplus @myscript
Alternatively, schedule your jobs with DBMS_BATCH.
Cheers,
g
-Original Message-
Sent: Tuesday, June 19, 2001 7:38 PM
To: Multiple recipients of list ORACLE-L
Although it would be difficult to prove, you could
always (once the volumes and file systems are created)
try creating your high usage stuff first (redos etc
etc) and hopefully it will land where you want it to
go.
You could then try the reverse (add the high use stuff
last) and see which is
Alex,
You are always right, in a very special way ;-)
But I do export a table using direct=y. The table has a LONG RAW column (not
a LONG, though).
It is in a 7.3.4.3 database on AIX. It works.
See:
Connected to: Oracle7 Server Release 7.3.4.3.0 - Production
With the distributed and
Oracle Data Administrator
Years Exp 3 - 7
Location: Milwaukee, WI
Salary $45000 - $68000 + full benefits+ bonus
Prod Offered: Manufacturer
Milwaukee based, global manufacturer. Large IT dept. that promotes
from within. Multi-platform, good technology: Oracle, Java Script, VB, C++,
Java,
Plus the cost of living is higher in Europe, I think.
Is this correct?
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
I received an e-mail from a recruiter in Belfast, they need a DBA...
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de
Lee,
try this script - it should do what you want
Brian
start script
set pause off
set pages 0
set feedback off
set echo off
set verify off
accept TNAME prompt Enter the table name / string, hit ENTER for all tables :
accept TOWNER prompt Enter the table owner to count, hit ENTER for
That sounds wrong. Thanks everybody, not just Gene.
This discussion is great. I just meant I liked Gene's
format on this posting.
y
-Original Message-
From: Yosi
Sent: Wednesday, June 20, 2001 12:06 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: New system, cart blanche,
Of course, to actually *measure* any performance difference,
you'd need to turn timed_statistics on anyway...lol.
Reminds me of Schrodinger's Cat.
-Original Message-
Sent: Wednesday, June 20, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L
I believe the consensus is
On 8i there are several cursor sharing bugs (1210242,
918002, and others) where cursors aren't shared when
timed_statistics is enabled. Most of them have been
fixed in 8.1.6.3 and 8.1.7.1. A workaround for most
of them is to set _SQL_EXEC_PROGRESSION_COST=0.
Symptoms are contention on the
Hi
Lee,
Here's
how you can do it in PL/SQL. It can easily be converted to SQL if realy realy
want it :).
set
serveroutput on size 100declarecursor c is select table_name
from user_tables;rec
c%rowtype;begin open c; fetch c into
rec;
dbms_output.put_line('select ');
Yup
-Original Message-
Sent: 20 June 2001 18:33
To: Multiple recipients of list ORACLE-L
Plus the cost of living is higher in Europe, I think.
Is this correct?
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Hi
In a sql stmt what will be the impact if we used DISTINCT clause and how we
can overcomes on the performance bottleneck caused by DISTINCT.
like ... SELECT DISTINCT A,B,C FROM TAB_1
I want to get same output without using distinct?Is this possible?If, YES
then how?
Thanks in advance
-Seema
hi all
i am using the following query to get the sql_text and user
select a.ADDRESS,a.SQL_TEXT,b.USERNAME
from v$session b, v$sqltext a
where a.address=b.SQL_ADDRESS;
the user has changes his password...
but i am not getting the sql_text when the user changes his password
plz
Hi
Is there any way to find which oracle process is taking much CPU except at
OS level.Is there any view available from which we can see the cpu
utilisation of particular user query.
Thanks in advance
-Seema
_
Get your FREE
it creates various support tables and views for eg dual, or tab(when u do
select * from tab) etc
for more info open the sql.bsq from u'r orant/home/rdbms80/admin/sql.bsq
Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They
We just got an oracle error ora-1041 on an operation. The oracle error text
is:
ora-1041: internal error. HOSTDEF extension does not exist.
In typical oracle clarity, the book says this:
Cause: The pointer to the HOSTDEF extension in HOSTDEF is null.
Can anyone give me a little more
I use
this script, counter.sql:
set
echo offset pages 0set trimspool onset lines 199set feed
off
set
term offspool counter1.sql
prompt
col table_name form
a30 head 'Table
Name'prompt col cnt form
,999,999 head 'Count'prompt spool counter.lstprompt set term
onprompt prompt Table
u can try hetrogenous services(HS) provided by oracle..it comes with the
product...
u have to set the entries in ur oracle machine to talk to sql server box..
i use this method to setup replication between oracle sql server.
Thanks
Harvinder
-Original Message-
Sent: Wednesday, June
This is another way, although you don't get it in your required format:
select 'select count(1) '||table_name|| ' from ' || table_name ||';' from
user_tables;
HTH
Prakash
-Original Message-
Sent: Wednesday, June 20, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L
Hi Lee,
You could use files with passwords.
PASSWD_FILE=/directory/pass.file
cat ${PASSWD_FILE} | sqlplus user@ORACLE_SID @file.sql
password does not show up with the ps command.
periodically changing passwords is made simple too.
Shaheer.
-Original Message-
Sent: Wednesday, June 20, 2001
1 - 100 of 163 matches
Mail list logo
