Solaris, I believe, uses the System V shutdown command. Although you
could use init to switch to the appropriate reboot runlevel, the typical
way to reboot a Solaris system is:
# /etc/shutdown -i 6 -g 0 -y
I'll assume you haven't mucked with your inittab.
(This provides no grace period for
Folks,
Any good online documentation on Oracle's Table API/triggers, a deployable
component available via Oracle Designer? The documentation for this suite
of applications is poor -- in contrast to the database and iAS docs.
Thanks,
Adam
--
Please see the official ORACLE-L FAQ:
Sorry -- my question was probably unclear.
Oracle Designer includes some deployable functionality known as a Table
API -- it's basically a package of procedures on the table to automate
checking and autopopulation of fields, along with triggers on various
events on the table. The key is the
Not recommended to include the password on the command-line -- you're then
exposing it to other users (via ps, for example), particularly on UNIX
systems.
Adam
Khedr, Waleed [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/14/2003 10:09 AM
Please respond to
[EMAIL PROTECTED]
To
Multiple
I'm using it as well -- a bit quirky, and I don't particularly like its
PL/SQL development interface, but for schema design-to-generation, it's
decent. I still prefer ERwin.
Adam
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/14/2003 10:44 AM
Please respond to
[EMAIL
Is there any documentation (particularly a schema diagram) of the Oracle
Designer data model, with comments? I'm doing a lot of work with the
repository, particularly in cross-workspace reconciliation, and knowing
the internals would help immensely.
Thanks,
Adam
--
Please see the official
It probably contains an unprintable control character or an extra space.
Try doing
$ ls -li# to get the inode
$ find . -inode inode -exec mv {} newname \;
or something similar.
Adam
AK [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/23/2003 04:49 PM
Please respond to
[EMAIL
Are you using vi? Sometimes if you try to :wq! to a specific name a
little too quickly, you might accidentally punch in a non-printable
control character in the filename.
Adam
AK [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/24/2003 10:24 AM
Please respond to
[EMAIL PROTECTED]
To
How about some more details? Are you cloning to a similar platform? Are
you using a cold backup with controlfile recreation? RMAN backup or
restore? RMAN duplicate? ...
Adam
John Blake [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/27/2003 02:24 PM
Please respond to
[EMAIL PROTECTED]
Refer to
http://asktom.oracle.com/pls/ask/f?p=4950:8:5481819534388360937::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1562813956388,
for the answers to some of your questions below. I think it's safe to say
that DUAL is a rather 'magic' table. The normal rules for DML don't work
on it; I'd not
I believe
select sid from v$session where audsid = USERENV( 'SESSIONID' );
is a universal way to determine one's current internal SID based on the
sessionid returned by userenv.
Adam
George Leonard [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/01/2003 11:44 PM
Please respond to
So your approach is to write a series of custom scripts, add them to (I
assume) oracle's crontab for periodic execution. Do you have one single
machine (or pair of machines) that monitor remote databases? Or do you
install these scripts on each database server? Do you leverage dbms_jobs?
I guess the impetus here is my Occamian approach to technology problems. I
abstract to the point of maximum flexibility with minimal complexity,
which often also requires maximum time and effort. Reality of course
dictates that a solution that ends up in common ground.
So it's not that I'm
Perhaps it should have said Occam's razorian ;)
Bellow, Bambi [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/05/2003 01:59 PM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
RE: Database management techniques and frameworks
Folks,
Anyone know if it's possible to pass a package record type as a parameter
to a Java stored procedure?
e.g.,
create or replace package el_zip_pkg
is
type file_rec_type is record (
namevarchar2(255)
, datablob
);
type
This could simplify life, particularly with wait event-based tuning. If
Oracle properly instruments these additional layers for timing, it makes
it easy to diagnose performance problems, not harder. Interested in
Cary's thoughts on this.
Adam
Goulet, Dick [EMAIL PROTECTED]
Sent by:
Folks,
Is there a straightforward way to dynamically create a LOBFILE
specification via an Oracle expression?
For example, assume the following table (note there is /not/ a field for
the file name itself):
create table clob_data (
id number
, data clob
);
And the following
I recently rewrote a poor-performing data load procedure (with single row
inserts, commit batches of 2000) to a pipelined table function, which
enabled insert /*+ append */ into the target table, which greatly enhanced
performance. The original routine contained an embedded select, a second
At the time, I did: I used simple sql_tracing for much of the analysis,
and definitely analyzed in stages. Unfortunately, most of the trace data
was lost. I have a couple of the files, from which I started with 10,000
row inserts (with commit batches of 2000) vs. 10,000 directly appended
In the interests of documentation, and if I have time, I could engineer a
similar 'dumb' procedure, perform trace as each modification is made, and
post the results here. It's pretty easy to come up with an artificial
routine, though, to do this kind of analysis oneself. Use Tom Kyte's
Directly in the SQL. We use Designer TAPI autosequence generation for
day-to-day operations, but triggers slow down inserts and of course can't
be enabled for direct path inserts.
Adam
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 11:29 AM
Please respond to
[EMAIL PROTECTED]
My responses below are below
Ryan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 11:54 AM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
great response. questions inline.
-
My responses below are below -- sigh, it's been a long day. lol
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 01:59 PM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
My responses
Folks,
I've noticed -- at least on our 9.2 instances, that it does not seem
possible to generate two trace files from the same session. Meaning, if I
start a trace in a session, then stop it, use tkprof to run some analysis,
and then erase that trace file, a second start_trace does /not/
We run Spotlight here, although I go right to the various v$ tables. I
did notice some quirkiness in how Spotlight's 'Top 10 SQL' lists rows.
It's like it returns # of rows for a static query (e.g. select 'Y' from
some_table where some_predicate = :b1) as '1' although it's executed with
25 matches
Mail list logo