Mladen,
Thanks for everyone's response on this.
I think that this is just a misperception on the part of the developer. I
took the phrase verbatim from his change request. I suspect that he has
only ever used sequences in the SELECT from DUAL statement so he thinks
that they are actual
bp,
indexes are used when limiting conditions are equalities not inequalities
(, !=, NOT IN)
How
about rewriting the query to replace the byan outer
join.
-Original Message-From: BigP
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 30, 2002 3:20
PMTo: Multiple recipients of list
OK, I checked Google and my own old mail and I know I've seen this here
before, but can't find my notes, so please forgive this same old question...
I need to execute a system call from within a PL/SQL block. Specifically,
I am looking at starting out report request demons as part of a post
Cherie,
Terminology -- make sure they understand that sequences are not
created attached to any table and can be used for more than one table.
Rachel
--- [EMAIL PROTECTED] wrote:
Dan,
Haven't heard the why yet but I think it may be just a poorly worded
request. I suspect he wants
Hi,
What is the reason behind DB_Name/SID usually 4 chars
length only. I have a customer who is asking us to
create instance/db with 6 chars length. We usually
keep instance name and db_name parameters same in .ora
file. Can someone please explain the reason behind
db_name 4 chars only. Is it a
We have SIDs 9 chars long!
Ron SMith
-Original Message-
Sent: Tuesday, July 30, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L
Hi,
What is the reason behind DB_Name/SID usually 4 chars
length only. I have a customer who is asking us to
create instance/db with 6 chars length. We
Who's got time for an abacus? It takes a lot of effort to chisel those bits into the
stone tablets. Used to take a lot longer before I got my electric chisel 8-)
Kevin Kennedy
First Point Energy Corporation
If you take RAC out of Oracle you get OLE! What can this mean?
-Original
If I can write good SQL to roll up data ... and still generate the charts
... is that a bad thing?
I get your point, but right now, I can't get MRTG working without a web
server, and I was looking for a pure file system based solution.
Raj
__
Database name is limited to 9 characters, see name column in v$database.
Instance name is limited to 181 characters (at least according to inst_name
in v$active_instances).
All this under 8.1.5.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of
You have to write an external stored procedure (C, C++, Java) and call it
from your PL/SQL block.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:56 PM
OK, I checked Google and my
To be more accurate, a sequence does not even have to be used for a table.
It is a construct to populate a variable (could be a table column, could be
run time) with a number that is generated in a specific order (though it may
contain gaps).
Dan (as he ducks a knitting needle).
-Original
All...
Will some of you please provide some insight on your table naming
conventions? I'm in the very early planning stages of what will likely
be a large and complex schema (IT asset inventory). I have a chance to
start it correctly. TIA
Gary Chambers
You can go to 8. We use up to 8 character SID's here. I have tried going 9 on an 8.0.5
system and it barfed on the create scripts.
Rodd
On Tue, 2002-07-30 at 15:08, Srinivas wrote:
Hi,
What is the reason behind DB_Name/SID usually 4 chars
length only. I have a customer who is
This relates back to the dos days (break out that chisel). 8.3 filename format
requires a sid less
than 5 characters, eg, init.ora
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're sober.
--William Butler
Yeats.
At least you had a light console.
-Original Message-
Sent: Tuesday, July 30, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L
coding? ha! I used to flip switches to load my programs directly into core
memory! and then I had to read the results from the light console! up-hill
Srinivas
Some systems have trouble with long identifiers. The SID gets various
prefixes and postfixes, and if you have a long SID this can cause problems
for systems that have restrictions on identifiers. An example is the server
processes. This can cause issues on client platforms that are
Actually it isn't that hard.
1. Stuff your data every N minutes into a table with time stamp.
2. Aggregate data every N hours and stuff in other tables (weekly,
monthly, yearly). I wrote some functions that round time to nearest half
hour, two hours etc...to make this easy.
3. Delete old data
Title: RE: Why DB_Name 4 chars only.
What is the reason behind DB_Name/SID usually 4 chars
length only. I have a customer who is asking us to
create instance/db with 6 chars length. We usually
keep instance name and db_name parameters same in .ora
file. Can someone please explain the
For most unix Platforms, the SID can be upto 8 characters in length. For
NT, I think, it should be 4 mainly because of DOS file name limitations. I
dont have the resources on hand, but I guess one could confirm this by just
trying to mount an instance with varying SID Names, until you get the
Take a look at Doc Id 50868.1 on metalink
Babu
John Weatherman [EMAIL PROTECTED]@fatcity.com on
07/30/2002 02:56:37 PM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
OK, I checked Google and my own
Here's a start. Not a checklist by any means, just kind of a micro pet
peeves list.
* Decide today whether table names will be singular or plural. Do you
want a THING (singular) table? Or a THINGS (plural) table?
* Don't use case-sensitive names. E.g., use THING (without quotes) in
your CREATE
Hi,
Is it possible to import .dbf files that were created in dbase III+ into Oracle?
Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALCAS
INET: [EMAIL PROTECTED]
Fat
Hi,
Where can I find the site to download the 9.2.0.1 upgrade. We currently have 9.0.1'
Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALCAS
INET: [EMAIL PROTECTED]
My std. also, 4 chars for db with last char denoting db use (Production, Test,
Development, Training, etc.). I started on VMS Oracle 6, seemed to be the case back
then, still hold to it. I used to have dns aliases for db names, VMS node name limit
was 6 chars. For example:
Payroll DB Names
Hi all,
On 8.1.7.2.0 on HP/UX 11.0, I need to create an index online. So, I see how
much space I have:
select max(bytes/1024/1024)
from dba_free_space
where tablespace_name = 'MY_IDX_TS';
...and it returns 147.3475. So I create my index:
CREATE INDEX myschema.mycoolidx
ON
Title: RE: Table Naming Conventions
My supervisor/client wants object types in names - except tables like I_ for indexes. Why do you say stay away from this?
-Original Message-
From: Cary Millsap [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 5:10 PM
To: Multiple recipients
Title: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Ha! I use to bang rocks together in sea water so that the sand could be used to make the first silicon chip 1,000,000 years later.
Of course that was in my younger days..
Jerry Whittle
ACIFICS DBA
NCI Information
Ethan - I empathize with some of the monitoring issues you had trouble with.
In a former life I was tasked with implementing a custom monitoring system
for a shop with over 150 database servers. In fact - we dedicated a server
to monitoring the others. A couple tips that saved us a lot of time:
Cary,
you said
* Don't embed the object type in the object's name. I used to see this
all the time with tablespaces called XYZ_TS, indexes called IND_THING,
and so on.
what's your logic behind that?
Rachel
--- Cary Millsap [EMAIL PROTECTED] wrote:
Here's a start. Not a checklist by any
Carle
http://otn.oracle.com/software/products/oracle9i/content.html
Alessandro
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 2:09 PM
Hi,
Where can I find the site to download the 9.2.0.1 upgrade. We currently
have
On Tom Kyte's site asktom.oracle.com he had a question about the cost of
Oracle vs. SQL Server. The upshot was that Oracle offers some fairly
inexpensive options for small applications.
Oracle SE with small numbers of users is very inexpensive. You are looking
at $1,500 USD for 5 named users.
...from http://www.gksoft.com/a/fun/unix-c-hoax.html...
Creators admit: UNIX and C Hoax!
In an announcement that has stunned the computer industry, Ken Thompson,
Dennis Ritchie, and Brian Kernighan admitted that the Unix operating system and
C programming language created by them is an
Rich,
1)Run following script to check fat size which will indicate how big your
initial extent may be as you are not finding contigous space in your
tablespace. when it ask for value give your tablespace name..
undefine table_space
set verify off
prompt This script provides a report useful for
Title: Microsoft Bids to Acquire Catholic Church
Microsoft Bids to Acquire Catholic Church
VATICAN CITY (AP) -- In a joint press conference in St. Peter's Square this
morning, MICROSOFT Corp. and the Vatican announced that the Redmond software
giant will acquire the Roman Catholic Church
If a common login is used (which is the case with most applications),
dbms_application_info can be used to set the actual username in either the
module or action. As long as the application is not using dbms_application_info
to set both, you should be able to get the info from v$session.
Title: Message
You
already have paret of what you need from the stats$sql_summary table which tells
you how often a statement has been executed. Bear in mind this table will
truncate any statement to 1000 bytes. You will probably also need
the stats$sqltext table. This table was added to
One solution is to write custom code to call as an external procedure.
A simpler method might be to just write a daemon that starts up prior
to Oracle and is controlled through data passed via a table.
The daemon tries to connect periodically, and after doing so, polls
the control table on a
If I'm interested in a specific RBS, how do I determine which user(s)
are making use of this segement?
How do I determine which RBS a particular user is using?
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641
Hello List,
Here is my question:
If a composite foreign key (defined using on delete cascade) is partially
indexed, will a delete operation on the referenced table use the index on
the partial foreign key?
More Detailed Explanation of Question
Assume the following
1. A master table with
I just think it's a waste. You can tell by context what kind of thing a
thing is. For example, consider: select a.flarg from bloing a where
a.croopoo 7. This can be understood by syntactical context (even with
the nonsense names), without having to rename bloing to
bloing_table.
Most of the
An interesting use of sequences might be to encrypt information.
Properly sequenced sequences could be used to easily encode
information that would be destroyed upon being read.
Know, I dunno where that came from, just hit me out of the blue
while reading this thread. Could be fun though.
Title: RE: user(s) RBS
-Original Message-
From: Charlie Mengler [mailto:[EMAIL PROTECTED]]
If I'm interested in a specific RBS, how do I determine which user(s)
are making use of this segement?
How do I determine which RBS a particular user is using?
You could try this
select c.segment_name, e.sid, e.username,
b.object_name, b.object_type,
d.used_urec, a.os_user_name,
d.xidusn, d.start_time,
e.process, e.program, e.status
from v$locked_object a,
dba_objects b,
dba_rollback_segs c,
v$transaction d,
v$session
I ran into a problem with this once. I had a procedure that I used to
monitor database statistics that I named monitor_stats. I stored that
data in a table called monitor_stats (OK, I should have named the table
stats, but that seemed too generic). With a procedure and table named
the same,
You already know it's an index, why would you include that as part of the
name?
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/30/2002 02:29 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Title: RE: ORA-1658 even though there is enough contig free
Could it be because of the minimum extent size? Though I would think it unlikely that your minimum extent size would be greater than 147MB.
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
On 8.1.7.2.0 on
Oh I love it! And I had forgotten about Bored of the Rings :)
--- Tim Gorman [EMAIL PROTECTED] wrote:
...from http://www.gksoft.com/a/fun/unix-c-hoax.html...
Creators admit: UNIX and C Hoax!
In an
Title: RE: Ids and passwords for application users
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
If a common login is used (which is the case with most
applications),
dbms_application_info can be used to set the actual username
in either the
module
Hmmm. Seems I have to play devil's advocate on this one. So, you see no purpose to
index names such as:
P_EMPLOYEE for a Primary key on the employee table
or UM_METER_CODE for a unique index on the meter table meter_code column
or FE_DEPT for a foreign key index on the employee table dept
Hi Gary,
In our environment, there are many applications in one database. We always
create public synonym for all the tables. To avoid confusion, all the tables
have to be tagged with the application prefix .eg. Student System has the
prefix STD, so the tables will be STD_XXX where XXX is the
I can see your point, In the data warehouse we are building here, the
modeler is planning on prefixing tables with the type of table (D_ for
dimension tables, F_ for fact, etc)
Hm, you mean we have to go back and revisit the naming standards that
they developed? Can I please suffix the column
All,
I am having a problem with a cluster. My environment
is Oracle 8.1.7 on Win2k on a COMPAQ server. This is a
production DB that has been running for a year or so
and I have now taken it over.
My problem is that there is a table that has 1 column
in a cluster. The cluster does not contain any
Thanks Alex.
Yes that thought occured in my mind but that would be my last option.
I'm still trying to find other ways than remote mounting filesystems.
Rgds,
Ross
-Original Message-
From: Alexandre Gorbatchev [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 31 July 2002 0:03
To:
I don't like such prefixes because they make it easier to lie or make
mistakes. I've seen people try for hours to figure out why something
doesn't make sense, only to find out that the index whose name has a 'U'
in it actually wasn't created with the UNIQUE attribute.
Names falsely cause
Hi Tom,
My backup starts on BoxA. It uses the rman binary in BoxA. So I do 'connect
target user/passwd@BoxB'.
Well I too thought that the backupset will be created in BoxA. Looks like
backupsets gets created wherever the target db is.
rgds,
Ross
-Original Message-
From: Mercadante,
Dennis,
Someone did mention that to me but found it hard to believe Oracle does not
have an option to save the backupsets in the box where you initiated RMAN.
Maybe Oracle thought by allowing it, it will saturate the network. Still, I
would have preferred the option to be there.
Rgds,
Ross
Rachel, one of the SQL statements in our Clinic that people find the
hardest to optimize is one that has a thing that looks like id_number =
1 in the where clause. id_number is the table's primary key, yet
the query spends 20 seconds executing a full-table scan. Any guesses?
It's because
That's a classic one, taught in various courses ever since version 5.
The most famous example was
select...
where date_column='12-31-99'
where date_column would be implicitly converted to varchar2. A little
'explain
plan' effort and all the confusion is easily avoided.
On 2002.07.31 00:08
I want to insert the following characters ,
1.) '
2.)
3.)
for example i want to insert the following line as it looks...
where part_no='1234' and name='guest'
how to do ?
can anyone help ...
Regards,
Prakash.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Guys , my insert statement is below . explain shows 828 for redo
size . does it mean the no of blocks ? what should be the ideal
value for the same ? what does the value for redo size = 828
indicate ?
kindly explain me.
insert into MSG_History
Guys , my insert statement is below . explain shows 828 for redo
size . does it mean the no of blocks ? what should be the ideal
value for the same ? what does the value for redo size = 828
indicate ?
kindly explain me.
insert into MSG_History
That getenrated redo size for this statement was 828 bytes. If an
instance ecovery
is needed, redo log files will be read and your transaction will be
applied. If
your transaction was committed, it will not be rolled back. Redo log
files are
only read during recovery. There are some
101 - 162 of 162 matches
Mail list logo