Hi!
I have installed client only on a client machine when I use DBMS_OUTPUT at
SQL*Plus, it says that it should be declared first.
How to make it available on the client machine?
TIA!
Aleem
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Abdul Aleem
INET: [EMAIL
Look at http://www.oriole.com for PDQOUT. It might be what you need at a low
cost.
-Original Message-
Sent: Tuesday, March 26, 2002 21:29
To: Multiple recipients of list ORACLE-L
Also look into the option BUFFER in export.
Srini
-Original Message-
Sent: Tuesday, March 26,
Here's a convincing stat for your architect:
There will be no RBO in a future version of Oracle. That version is
not far away (conjecture is perhaps as early as 10). As often
occurs, this is a case of do what we say, not what we do, since
RBO is still used in the data dictionary tables.
Hi All,
Has anyone using fine grained access have had any
problems such as high Latch waits or high number of
SQL executions?.
We have an OLTP database which uses FGA and have seen
high number of SQL executions to the tune 100 users
logged in and the SQL executions are 3000.
Thanks in advance
Hello Aleem,
I don't think NT will automatically do it for you, but the Database
Administration Assistant can make it a little easier by allowing you to
select OS groups of users and create database accounts for them.
You might also be able to write your own procedure to automate it
somewhat.
It sounds like there is no synonym for DBMS_OUTPUT or the user doesn't
have execute rights ?
Try calling it as SYS.DBMS_OUTPUT
And try GRANT EXECUTE ON SYS.DBMS_OUTPUT to user;
-Original Message-
Sent: Friday, March 29, 2002 3:18 AM
To: Multiple recipients of list ORACLE-L
Hi!
I
T
Todd
-Original Message-
Brian
Sent: Thursday, March 28, 2002 6:53 PM
To: Multiple recipients of list ORACLE-L
If you haven't already done this, the find's are unneeded.
How about replacing 1,3,4 with:
create dba group
usermod -l oracle -g dba oracle2
Since the ownership's in UNIX
Jack,
If you run 'namesctl stat' you will find a line therein that tells you when
the server will recheck the region database, as in:
franklin:/ora1:04:namesctl stat
Oracle Names Control for HPUX: Version 8.1.6.0.0 - Production on 29-MAR-2002 09:
08:34
(c) Copyright 1998, 1999, Oracle
ORA-00031 session marked for kill
Action: No action is required for the session to be killed, but further
executions of the ALTER SYSTEM KILL SESSION command on this session may
cause the session to be killed sooner.
Hmmm... what if I hit the enter key HARDER?? ;-)
-Original Message-
I'm just joking with you...
-Original Message-
Sent: Thursday, March 28, 2002 4:25 PM
To: Multiple recipients of list ORACLE-L
Does this mean we can freely copy these books now??
Of course not!! :-(
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database
Hey Jeremiah,
I ripped them all down from the website back in 99. I believe that was the
year that Oracle decided not to hand out a CD.
I have all the presentations and papers burned to two CDs.
Attached is the webpage that describes all the presentations (which only
Jeremiah will get). If
I need to create a generic dynamic procedure to create and execute any
procedure I wish.
===
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack van Zanen
Aha! That would explain it. And while I don't have time to test it, if
that is the case, then my most humble apologies to Waleed! :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original
I believe I used GoZilla. This was discussed on this list (or was it the
other list?) way back when...since everyone else piped up and shared the
name of the software they had used. GoZilla allows you to point to a
specific URL and download all the files at that URL. Checkout
www.shareware.com
Jeremiah,
strings $ORACLE_HOME/lib/libclntsh.so | grep "^Version"Version
8.1.7.0.0
This is not showing me what I expect. On a 8.1.7.3
database environment, SQL*Plus shows me that it is 8.1.7.0.0. Does the 8.1.7.3.0
patch not perform upgrades to SQL*Plus? Or is there a separate
Chris,
I'd like to get my hands on the OWB (Oracle Warehouse Builder) paper. Is
this possible ?
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Friday, March 29, 2002 9:54 AM
To: Multiple
Wish I knew where I stole this from. If I knew, I'd created them . . .
Good luck!
Barb
Generic DBMS_SQL procedure:
/* to execute: EXECUTE exec_ddl ('SET TRANSACTION USE ROLLBACK SEGMENT r05')
*/
CREATE OR REPLACE PROCEDURE exec_ddl
(p_statement_txtVARCHAR2)
AS
-- This
Hi
A developer is getting a sporadic errors when trying
to access ORacle
database via a Cold Fusion screen. The messages on the
screen are
Oracle Error Code = 0 Timeout while obtaining an
Oracle statement lock. I turned tracing on in his
session and found this in the trace file:
update seg$
Hey all,
I know there are developers lurking out there as well as dba's
that have a great deal of development experience that could help me to help our
developers on this project.
We have an old application that is running on a VMS machine.
The Oracle version there is 8.0.5. Our
144 Oracle Warehouse Builder (OWB) Victoria Whitlock Oracle Corporation
I don't have it. It's listed on the web page but there are no links to the
files. And therefore I have no files. Sorry.
Obviously, not all of the presentations were posted on the website, but most
of them were.
Can anyone tell me the difference between
alter system archive log current
and
alter system switch logfile
(Seems they both perform checkpoint and both switch a log file).
Is one preferred over the other for purposes of switching log files prior to
applying to a standby
How do I display time zone in date format using SQL?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
One new thing
you can do with PRO*C 8i is to use the The PREFETCH
Precompiler Option if your application is processing a lot of data in a
sequential manner (and you don't already do bulk
fetches)
Caver
-Original Message-From: Stephen Andert
[mailto:[EMAIL PROTECTED]]Sent:
Will alter system archive log current work, if the database is not in
archive mode?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 29, 2002 11:23 AM
Can anyone tell me the difference
Actually I use alter system archive log all. I saw that if the database was
behind with archiving, this would ensure that all logs were written to the
arc destination. archive log current only did the most recent.
Am I wrong? Please correct me if I am .
Lisa Koivu
Oracle Database Baby Oven
Anyone else get an email like this that sounded kinda threatening?
-Original Message-
From: SANS Research Office [SMTP:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 12:05 PM
To: [EMAIL PROTECTED]
Subject: Oracle Step-by-Step Guide feedback
This is a note to the 167
is there any way to check on WIN2K
-Original Message-
Sent: Thursday, March 28, 2002 6:43 PM
To: Multiple recipients of list ORACLE-L
Here's a way on unix:
strings $ORACLE_HOME/lib/libclntsh.so | grep ^Version [7-9]
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 28 Mar
I think that datatype DATE has no info about time zone in v. 8i.
If you want to show time zone you have to read it from your server env
or to store it separately in other column (and insert looks like
INSERT VALUES( ... ,SYSDATE,'CE', ...) for central european time zone
etc.).
JP
On
Another utility like GoZilla that I know works well is WGet (available for both
Unix and Windows/DOS platforms). The one I have is a command line tool, but someone
may have made a gui out of it. It allows you to specify files to download (i.e.
*.html, *.jsp, *.pl), files NOT to
I believe alter system archive log current will wait until archiver has
successfully archived the file, thus this is the one you would want to use
in any backup scripts.
- Ethan
-Original Message-
Sent: Friday, March 29, 2002 10:24 AM
To: Multiple recipients of list ORACLE-L
Can
SQL alter system archive log current;
alter system archive log current
*
ERROR at line 1:
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
1* alter system archive log current to '/tmp/dummy.log'
SQL /
alter system archive log current to '/tmp/dummy.log'
*
ERROR at line 1:
We currently have PeopleSoft running on HP-UX 11.0 64-bit OS and Oracle 8.1.6 32-bit.
We want to upgrade to Oracle 8.1.7.3 on the same OS, but the question is, do we go
with 32-bit or 64-bit Oracle? Any feedback or information would be much appreciated.
Jim
--
_
No, actually it does not. I just tried it on a db with archive turned off
and got an error message (ORA-00258: manual archiving in NOARCHIVELOG mode
must identify log).
Good point. Thanks.
--
From: Igor Neyman[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent:
You can
select sessiontimezone, dbtimezone from dual;
I don't know how to manipulate it though. It seems like you should be
able to do something like
select sysdate-substr(sessiontimezone,1,3)/24 from dual;
to get the GMT, but I haven't been able to get it to work...
Beth
guess, it depends on how much trouble we caused.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 29, 2002 12:18 PM
Anyone else get an email like this that sounded kinda threatening?
FYI, for those of us with web sites we finance out of our measly
pocketbooks, it sucks when someone does this because most hosting companies
charge for traffic, I get an 8GB limit. This can seriously hurt the little
guy if he is hosting large files such as my site.
- Ethan
-Original
The 'ALTER SYSTEM ARCHIVELOG CURRENT' is the preferred one that should be
used for backup scripts.
The reason being, if you have noticed when you do an 'ALTER SYSTEM SWITCH
LOGFILE', you get the prompt back immediately. This command performs a
database checkpoint, switches to the next log,
Just thought I would pass these links along to the list.
It seems that there are a number of unix newbies on the
list lately asking about automating jobs via cron.
Hope these prove useful.
Jared
Automating Tasks with Cron and Crontab files
http://itw.itworld.com/GoNow/a14724a55415a79856347a1
They are using the PREFETCH option with mixed results between
8.1.6/8.1.7 and 8.1.7.3. I have a TAR open for why it's not working in
8.1.7. (There is a bug) I also have another message on the list
about determining the version of the client. Using the way Jeremiah
suggested (strings
That's exactly, what I meant (besides the fact, that alter system archive
log current will return only after Archiver is done archiving current
log).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday,
I think that Oracle is actually concentrating on the 64 bit now. Especially
on HP. Personally I would go 64 bit. There seems to be no specific bugs
that are 64 bit related (although I would do your own research on that one).
Therefore, all that would happen is that you would be potentially
IMHO if you're running 64-bit O/S you should go to the 64-bit
database. You'll want to be there for 9i and upwards, so
just go there now.
Cheers,
Mike
-Original Message-
Sent: Friday, March 29, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
We currently have PeopleSoft
[EMAIL PROTECTED] wrote:
We currently have PeopleSoft running on HP-UX 11.0 64-bit OS and Oracle 8.1.6
32-bit. We want to upgrade to Oracle 8.1.7.3 on the same OS, but the question is, do
we go with 32-bit or 64-bit Oracle? Any feedback or information would be much
appreciated.
Jim
Hello,
The UNIX grep will fail if the libclntsh.so has 0 bytes, so just for a
quickie look, it may be better to see what's there for the libclntsh, and
grep that, or use a wildcard.
$ strings $ORACLE_HOME/lib/libclntsh.s* | grep ^Version [7-9]
Version 8.1.7.0.0
Version 8.1.7.0.0
$
Thank you,
You may be comparing apples to oranges here.
I have had ex-VMS people tell me that VMS is a screamer. So VMS to Unix is
one issue.
You are also comparing v8.0.5 to v8.1.7.3. I haven't done a time
comparison/benchmark for some years but when I was a developer I notice
that my Pro*C programs
Dear list,
Feel like having a good rant? Need to take some frustrations
out on lies, ignorance and misinformation?
I received a document from a friend that live in both the Sybase
and Oracle worlds. He was interested in my comments on it
as he recognized it as a rant against Oracle that was
Hi
Can some one send me automatic shutdown and startup db script for WIN'2000?
Thx
-Seema
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
--
Please see the official
Hi List,
I am looking for some scripts to generate some dummy data and insert it in
alot of tables which related to each other, any site or url or scripts?
Appreciate
Thanks
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
The information contained in this message and any attachments is
[EMAIL PROTECTED] wrote:
Hi
Can some one send me automatic shutdown and startup db script for
WIN'2000?
Thx
-Seema
no.
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL PROTECTED]
You
I will say I sat in a meeting with a customer recently who is a big Sybase
shop and they were having huge difficulties because the generate 9 GB of
redo on one database each day in a high replication environment. In their
minds this was really a lot. I have also been reading up on Sybase and
Hello All,
I am trying to install the statspack utility by assigning PERFSTAT user to a
locally managed tablespace of size 500 MB, it is giving me the following
error
create table STATS$LEVEL_DESCRIPTION
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in
I'm inclined to agree with the extraordinarily incompetent part, or at
least in one case. On point number 38, the author states that Oracle's LDAP
server (assuming Oracle Internet Directory) is to cover up the severe
problem that all users in an Oracle database cannot readily share the tables
of
Part II of ???
The author states in point 1 Oracle has no provision to store numbers in
the computer's own native format, namely IEEE. I'm not sure what he means
by the computer's own native format, but the last I knew, IEEE was a set
of software libraries on most machines, and not a native
Part III of
Point 23: Only one database per server Oh no! Now what do I do with
our HP that has 3 or 4 Oracle instances on it!?
OK, OK, I need to stop reading this and get back to work...
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
I've used Sybase (along with Ingres and Informix) in a DBA role in the past and the
one thing about Oracle I can say is;
At least Oracle doesn't have an entire chapter in the manuals on corruption and how to
detect, prevent and fix it. (see dbcc). To me, that is an admission of failure.
Our
Hello,
I suggest that you read the readme file for the STATSPACK installation. If
8.1.7, it says that it needs approx. 45MB. You could create a schema, or use
something like TOOLS for the default tblsp, and use TEMP for the temporary
tblsp. Also, I would suggest that you read the articles on
Ethan,
Point well taken. But, I feel this utility is meant for downloading directories
where you want everything in it anyway, not just sucking everything you can off of a
website. And if you narrow the scope of your download properly, it turns out to be no
different than saving each
I can only speak to Sybase 11 since that is the book I am reading but the
book actually makes the suggestion to speed up backups on large databases to
split your database into multiple databases because you can backup each
database independently. This also appears to be how they exert more
Ethan,
I would never use one of these utilities on your website, only on the big
guys.
BTW, what is your URL.
-Original Message-
Sent: Friday, March 29, 2002 3:34 PM
To: Multiple recipients of list ORACLE-L
Ethan,
Point well taken. But, I
It shouldn't take that much space to install. Is CCXSTL01 the correct
tablespace? After you get it installed the space requirement depends on how
many snapshots you take and how long you retain them. I take level 5 snaps
every 15 minutes and actively purge data and rebuild indexes. I retain some
Yeah I did read all the SPDOC.txt in $ORACLE_HOME/rdbms/admin.
I have created a tablespace of ( a locally managed , uniform , extent size
10 MB ) of size 500 MB , but still getting the below mentioned problem, I
think I have to go for auto extend rather than uniform with 10 MB each. If
you have
How many sites are doing cold backups? At what frequency?
How many sites are doing hot backups? At what frequency?
Does anybody know the existance of any Best Practices
paper on the web that discuss the topic of Oracle backups?
If so, what's the URL?
TIA!
--
Charlie Mengler
seems like I need small extent size , I have given 10MB for each extent ,
and in your case it is just 128 K.
so by reducing the extent size , should it work ?
-Original Message-
Sent: Friday, March 29, 2002 2:59 PM
To: Multiple recipients of list ORACLE-L
It shouldn't take that
Hello,
I used my TOOLS tblsp., having first and next of 1MB.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Friday, March 29, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L
seems
List,
SANS is a reputed non-profit organization dedicated to Security issues and I
think Alan Paller is their director. They have done excellent work related
to Computer Security and awareness over the last 6 years that I have known
them. Understandably, they are senstive about dishing out
I read (most of) it and it made my day. People who write this kind of
stuff know they are only telling half truths (did you see any quotes or
references?). It's email spam for techies. And a reply does nothing more
than make their day. If some of it is true, fine. Let the Oracle kernel
Yupp, lot's of small tables. You could even go down to 64K.
-Original Message-
Sent: Friday, March 29, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L
seems like I need small extent size , I have given 10MB for each extent ,
and in your case it is just 128 K.
so by reducing the
What percent of developers know how to explain and trace SQL, interpret
these reports and tune?
In my experience it's about 10%, so most SQL tuning is done by DBA's. Is
that about right?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL
Perhaps he is not installing as user SYS. The PERFSTAT user is granted
UNLIMITED tablespace in the install scripts on the tablespace that is
selected, so either there is not enough free space or the grant is bombing
because he is not SYS...or something else that I am not thinking about at
the
You made me laugh. I have never worked with Sybase but have heard about
this utility. Interesting to note though, we have validate structure
cascade and several events to detect corruption, and also the dbms_repair
package. But I don't put Oracle's detection and correction in the same
Jared,
There are too many mistakes in that document to even begin to answer.
However, one I do love
#26 Oracle will use the redo logs to create an index.
Obviously the author is working from that same INACCURATE book that
says that Oracle doesn't write to the datafiles when a tablespace is
HI LIST,
How can I see the output of my procedure, my procedure return one output, I
have tried with set serveroutput on but the procedure successfully completed
with NO RETURN value???
Thanks
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
The information contained in this message and
Greg,
The reason may be driven by the requirement of
'develop-within-this-deadline' for Developers, and
'get-this-query-to-respond-within-1-sec' for DBAs. The DBA's responsibility
(among others) is to run a well tuned system, the Developers' responsbility
is to develop a working product, and the
Yep , Ethan , you are mistaken , Seems my problem is with very big extents ,
I will try with small extents , let all you guys know.
-Original Message-
Sent: Friday, March 29, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L
Perhaps he is not installing as user SYS. The PERFSTAT
In my shop, 0 out of 3. Which wouldn't be so bad, but they also show 0 interest in
learning... and every time a new job goes into production and takes 10 hours to run,
its a database problem... ok, i'll stop ranting now...
-Original Message-
Sent: Friday, March 29, 2002 5:38 PM
To:
Do you have a DBMS_OUTPUT line in your procedure?
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Hamid Alavi
In my previous shop they all wanted to learn. Once I sent them all a
document on SQL tuning and one of the developers would just not leave me
alone. I did such and such and now its this much faster. I got that for
every SQL statement he did. The novelty eventually wore off and he stopped
Kim, What document did you send them?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 29, 2002 5:03 PM
In my previous shop they all wanted to learn. Once I sent them all a
document on SQL tuning and one of the developers would
Greg,
You *do* see DBA's doing the bulk of the SQL tuning work in many shops. But
it's not necessarily because the developers, or at least some them, can't,
or, that many of them don't care (and *many* of them never do give it a
thought). I've seen places where the developers begged for the
Well, that certainly was interesting!! No database will always compare favorably to
others for every feature. There are some tings SYBASE does better than Oracle.
However, he is either ignorant of such things as the no logging directive, or
refuses to consider them because they are not
Oh yes, it's *always* a DB problem. Why don't you fix your database, it's
your problem and your fault ;-) I think most can understand your rant.
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Its an internal document that some developed.
-Original Message-
Sent: Friday, March 29, 2002 5:43 PM
To: Multiple recipients of list ORACLE-L
Kim, What document did you send them?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday,
82 matches
Mail list logo