Hi,
The X$ tables are the source of the V$ views. They are very cryptic and
only few are documented (NOT by Oracle).
Jack
"Sinardy Xing"
On Thu, 19 Apr 2001,Jared Still scribbled on the wall in glitter crayon:
-If you're familiar with the Help Desk software 'Remedy', you will know that
-it has one of the worst schemas ever designed by man or beast. If you
-haven't seen it, you would have a hard time imagining it. Yes, worse
Hi Iain,
Let me quote from my book ... "Note also that the 'enqueue timeouts' statistic
in V$SYSSTAT does not represent the number of enqueue wait timeouts. Rather,
this statistic is incremented when an enqueue request or enqueue conversion is
aborted entirely. This can be due to a distributed
Hi,
I actually had to write some Perl scripts to transfer user data from a
billing software's DB to Remedy ... and I was eventually slightly
surprised that the Remedy folks were really able to deliver a ER model
even worse then the billing software's model. But they did a great job
in
Hi,
look here, they have forums for most of the MS Office tools:
PEACH.EASE.LSOFT.COM
The Access list is very busy (and good).
[EMAIL PROTECTED] schrieb:
Anyine whom knows about an Access forum where I can ask questions?
Roland Skldblom
--
Please see the official ORACLE-L FAQ:
Mohammad,
http://technet.oracle.com/products/forms/
"Upgrade Developer Forms 4.5 to Oracle Forms 6" towards the bottom of the
page (or click the migration link towards the top of the page to take you
there.
Larry G. Elkins
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
Hello all,
Funny you mention Remedy. I've been recently introduced to Remedy here at my
new job. I was about to refresh our QA database with production data when I
discovered the schema's were different! I took a look at the two schemas and
WOW, was that a shock (uglyy). Seems the DEV
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
Steve Adams discusses enqueue_resources
Maybe I am missing something, but if this is only one table that you are trying to
change a field from NULL to 00 then why not UPDATE the table SET column = 00
where column is NULL; before you run the procedure against the table. To prevent the
column from being loaded as NULL place a
Hi Allan,
Thanks for that reference. It is a much better treatment than the Oracle paper
on the matter. The Oracle paper says "Stripe all files across all disks using a
one megabyte stripe width". The Sun paper stops short of saying "all ... all"
which is a very significant difference. It says
I apologize for being off topic here, but I am stuck.
I have been struggling for 3 days on what I believe is a simple script.
Here is the piece of code which is not functioning as I require:
1 UserIP = Request.ServerVariable("REMOTE_HOST")
2 IPCheck = Left(UserIP,7)
3 If UserIP = "192.168"
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
I do not know ASP but shouldn't line 4
Hi
How about:
=
1 UserIP = Request.ServerVariable("REMOTE_HOST")
2 IPCheck = Left(UserIP,7)
3 If IPCheck = "192.168" Then
4 parser.setSingleSessionField "My_Template", "template_i"
5 Else
6 parser.setSingleSessionField "My_Template",
I apologize. I grabbed an older version of the script. In fact, line 3 is
'IPCheck' and not 'UserIP'. I couldn't get anything working with UserIP.
-Original Message-
From: Hallas, John [SMTP:[EMAIL PROTECTED]]
Sent: Friday, April 20, 2001 10:26 AM
To: Multiple recipients of
William,
Have you tried to figure out Portal? Next to this beast, Remedy looks
pretty good.
David A. Barbour
Oracle DBA
"Thater, William" wrote:
On Thu, 19 Apr 2001,Jared Still scribbled on the wall in glitter crayon:
-If you're familiar with the Help Desk software 'Remedy', you will
All,
Pretty much says it
all in the subject line BUT, does anyone have any links to whitepapers with
recommendations on this please ??
Oh yes, the Tru64 is
at 5.1
Regards
Lee
The information contained in this communication is
confidential, is intended only for the use of the recipient
William,
The only other thing I can think of (not knowing ASP syntax):
Is the string comparison operator a '=' or something like 'eq' or '==', while
the assignment operator is a '='?
donita
:Date: Fri, 20 Apr 2001 06:50:24 -0800
:To: Multiple recipients of list ORACLE-L [EMAIL
OH crappers, we just put Remedy in here. They are running it in SQL Server
though. They just let me have a second DBA. Maybe I will give him
responsibility
over that one:-)
-Original Message-
Sent: Thursday, April 19, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L
We had a customer who are using Oracle8i Enterprise
now , and they try to use Oracle8i Standard instead. I
don't know why they try to do this(maybe standard cost
less??). Anyway, is it easy to accomplish?
TIA.
Chris.
__
Do You Yahoo!?
Yahoo!
I am trying to tune a 30GB database and to configure
the initSID.ora files to use PQO. From my understand,
they are some back requirements: multiple CPUs of the
machine, stripe the tablespace datafiles, etc. If I
only have 3 disk drive, do I have to stripe the
datafiles to 3 disks, index files to
Hi List ,
I am supposed to install oracle 816 on win2K ( I
knowI should go for real OS !! ) I am very much of
a UNIX bigot and I am looking for any pitfalls and
things I should look out for .
TIA .
Regards,
RS
__
Do You Yahoo!?
Yahoo! Auctions
Dick,
Don't take this the wrong way...it's NOT meant to be sarcastic:
You said "SAME is a great theory, but I can't and haven't seen it perform
well in practice, yet."
My question to you: Have you seen it in practice at all? An actual working
implementation?
For that matter; has ANYONE seen
Hi list,
I have a problem with package UTL_SNMP. I have a procedure which sends mails
to special recipient. My problem is, that the body of the message
(utl_smtp.data(mail_conn, message);) will not be sent. Any help is welcome.
Following the procedure.
create or replace PROCEDURE sendmail
AS
Hi
Which dictionary table is used to see all X$ tables.
Thnaks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
It seems to me this is a debate about whether to separate tables from
indexes at the hardware (RAID stripe) level, vs. doing it by placing them in
different tablespaces, with the tablespaces located on separate devices.
Either way the indexes and the tables should not be on the same physical
I am trying to test a jdbc application using Oracle' thin client driver from
AIX. The database that I am trying to go against is 8.1.6 server on an NT
box. I keep getting the following error on compile:
OracleConn.java:10: Class oracle.jdbc.driver.OracleDriver not found in type
declaration.
I forgot to mention:
We assiduously separated table from index...across controller and
channel...and we separated "hot" and "cold" data tspaces as well.
There's nothing like having enough disk and I.O.
:)
== -Original Message-
== From: Mohan, Ross
== Sent:
Title: RE: x$ksppi table
-Original Message-
From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
Do you know what are x$ tables for ?
What information inside there and the different with v$.
You can find out the relationship between v$ views and x$ tables by querying against
The installer hung at network configuration, but I think it's because we
launched the installer remotely through a Terminal Services window. The
database service does not come up automatically even though it says the
service is started. A patch is available for this, but I have not applied
it
Title: RE: dictionary information
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Which dictionary table is used to see all X$ tables.
(g)v$fixed_table where name like 'X%'
(g)v$indexed_fixed_column
--
Jacques R. Kilchoer
(949) 754-8816
Quest Software,
Title: RE: RE: Never split index and data files ...
Long ago in a galaxy, far far away, I did
a semi-SAME thing on a Sequent box. Everything
but logsfour controllers, each with full
four-channel fastwide SCSI. Software raid0+1
(not 1+0). Stripe width 128Kblocks, 64Kbytes.
Worked like a
Hi Chris,
PQO is great if you have the hardware to support it. For example,
say you have a large table in lots of partitions, and each partition
is on a separate device. Then, a query can scan the whole table way
faster, since the query is broken into parallel pieces, each scanning
a small part
HTH YMMV!
REATE OR REPLACE PACKAGE BODY mwh816
AS
PROCEDURE send_mail (senderIN VARCHAR2,
recipient IN VARCHAR2,
message IN VARCHAR2)
IS
mailhost VARCHAR2(30) := 'chiron.mwh.com';
mail_conn
Hi All,
Oracle 8 running in Archivelog
One of my coworkers said they did the following:
1. Added a datafile to a tablespace
2. Took datafile offline and renamed at OS
3. ALTER DATABASE RENAME ... to new name
4. Attempted to bring datafile back online and get file needs media
recovery.
Tried
I have done this on a development box. The application running on top of it
is up and running and so far I haven't encountered any problems.
At 09:25 AM 4/20/01 -0800, Raj Sakthi wrote:
Hi List ,
I am supposed to install oracle 816 on win2K ( I
knowI should go for real OS !! ) I am very
Hi !
The downgrade (if you call it) is pretty simple
and straight forward.
Just shutdown the database (and take backups!!)
Remove the EE and Install the SE and create the service and
restart the database .
-Original Message-
Sent: Friday, April 20, 2001 9:26 PM
To: Multiple
Hi !
I don't think any dictionary table has info about X$ tables. These
are directly from Oracle Source code. It is bit exposed via
V$FIXED_TABLE.And the contents of these tables (or views) are
dynamic. It has very limited life (till the shutdown) and you
can not export the data from these
Hi !
Can you tell me how many CPUs you have and
the number of PHYSICAL DISKs
-Original Message-
Sent: Friday, April 20, 2001 9:41 PM
To: Multiple recipients of list ORACLE-L
I am trying to tune a 30GB database and to configure
the initSID.ora files to use PQO. From my understand,
Hi !
It is bit cryptic and I guess this stands for
X$ ( something un known??)
K Kernel Layers?
S Services Layer
P Parameter
PI (INstance) Parameter
It is exposed to you as V$ parameter view.
As everyone said the current authority for these tables is
This problem has been resolved
re-FTPed the classes111.zip file to the AIX server and it appears to be
working now.
Thanks,
Manas.
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 2:01 PM
I am trying to test a jdbc
Are you sure? I read that the data dictionaries are not compatible. I know
to go from standard to enterprise you must take an export, load the
software, create a new instance, then import.
--- K Gopalakrishnan [EMAIL PROTECTED] wrote:
Hi !
The downgrade (if you call it) is pretty simple
Hi,
I may be wrong but
Oracle suggests that the file should be "COPIED"
at OS level before renaming at Oracle level. Here
I think is that Datafile is "MOVED" before renaming
at Oracle level.
This is what causing the difference ..
I am afraid there is solution
Listers,
Can someone tell me how to automate procedure
execution
from within Oracle.
I would like to execute this procedure at 10:00 p.m.
sqlplus execute jrunit
Thank in advance.
abdullatif
__
Do You Yahoo!?
Yahoo! Auctions - buy the things
I have 29 physical disks on Sun Solaris 2.8(just
talked
to SA). And they are all striped. But I have only 1
logical drive. So I cannot stripe on the Oracle side.
I have 4 CPUs. And I have a big database with 20GB.
And that's a static table, but we have intensive
selects on this one(It's our
Damn Haskins!! You are the man!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 12:40 PM
Kev,
In many organizations, the System (server) Admin is not the same person
who
is the DBA. If the DBA doesn't know any better,
Thanks to all replies
Turns out they started recovery and it appear to be hung and they attempted
to start another recovery while that was running. After stopping the
recovery and reissuing it recovered.
Thanks
Rick
-Original Message-
Sent: Friday, April 20, 2001 3:31 PM
To: Multiple
Check out this package dbms_job!
Hitarth Trivedi
Oracle Certified DBA (7.3)
Sun Certified Java 2 Programmer
MCSE, MCP+I
315-362-1162
[EMAIL PROTECTED]
-Original Message-
From: abdul latif [mailto:[EMAIL PROTECTED]]
Sent: Friday, April
I've got a developer that says they need the unix password for oracle so
they can do a trace and run tkprof without having to jump through a bunch
of hoops. Anyone set up trace so someone other than oracle can do this?
The permissions on the trace files only allow reading by the file owner, so
I got the following answers from Oracle support:
You can convert from Enterprise Edition to standard
edition.
You need to shutdown and backup the database and
software.
-- De-install 817 Enterprise Edition.
-- install 817 Standard Editon
-- start the database and run catalog.sql and
catproc.sql
You can use dbms_job to achieve this ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts,
Tell me 'bout it..!!!
--- Kimberly Smith [EMAIL PROTECTED]
wrote:
Only one real pitfall - Win2000
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ:
Hi Dave,
Pl change permission on the existing trace files that belong to the user.
Add _trace_files_public = true in the init.ora file and bounce the db to
make it effective. All future trace files will have public read access.
However, tkprof should already be public executable. They don't need
Hi !
You can use the undocumented paramter
_trace_files_public=true
-Original Message-
Turner
Sent: Saturday, April 21, 2001 1:24 AM
To: Multiple recipients of list ORACLE-L
I've got a developer that says they need the unix password for oracle so
they can do a trace and run tkprof
Can you create a database link back to same database?
I have a product that uses database links to create a copy of the database,
the users now want to copy it back to another schema on the same instance.
I get ORA-02019: connection description for remote database not found
or ORA-2082
Either
I'm not sure, but don't you need to execute 2 more commands:
alter database recover datafile 'new_file_name';
alter database datafile 'new_file_name' online;
Hope this helps,
donita
:Date: Fri, 20 Apr 2001 10:51:01 -0800
:To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
:X-Comment:
Great! Thanks for the info!
--- CC Harvest [EMAIL PROTECTED] wrote:
I got the following answers from Oracle support:
You can convert from Enterprise Edition to standard
edition.
You need to shutdown and backup the database and
software.
-- De-install 817 Enterprise Edition.
-- install
If I remember correctly the user can set autotrace on in the session and the output if
sent to the terminal after the sql command is completed.
Give it a try.. You might have to set up permessions or privileges to get it to work
for a user.
ROR mm
[EMAIL PROTECTED] 04/20/01 03:54PM
I've got
Make an entry in your tnsnames.ora like the one below:
DBSID_LOOP = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1601)
(HOST=127.0.0.1))(CONNECT_DATA=(SID=DBSID)))
Then create your db link with: using 'DBSID_LOOP';
It should work, this is on HPUX, Oracle 7.3.4.
Scott Shafer
San
hi,
I think that oracle is not finding the database descriptor (using
'fr.is.inr.com';) in the tnsnames.ora archive.
try this on the OS.
tnsping fr.is.inr.com
it should report something like this:
TNS Ping Utility for IBM/AIX RISC System/6000: Version 2.3.4.0.0 -
Production on
20-APR-01
Ian,
Thanks for the tip. Sounds right, but how much of a threat
do you think it is given the campus firewall, etc.? It would
only be intended for "internal" department use, at least
initially, so we could presumably use NT user authentication
for some kind of security (???).
(Larry folks:)
ED,
Damn good question! No I won't take it as sarcastic at all.
Now to your point: We had to implement this particular strategy about 4
years ago due to the vendor we bought a disk array from (IPL). They were
somewhat ahead of the curve here. Simple theory, they configured the 30GB
Frankly, I am guessing, but all I could find in the documentation is that
user must have analyze privilege for running dbms_space package, so my guess
is it uses "estimate statistics" (sampling ) internally. Hence, the
inaccuracy?
-Original Message-
Sent: Friday, April 20, 2001 4:46 PM
Hi RF ,
export is Fairly straight forward .
1.Use direct export
2.Use parallel export processes . Run your biggest
table export first and fire off other exports
simultaneously . Take a look at parallel download
script at
http://www.oriole.com/frameindexTK.html
Now import is another kind of
abdullatif
Easiest way,
1) add to the init.ora "job_queue_processes = 2", "job_queue_interval =
300". This will start two job running processes that will wake up every 5
minutes.
2) shutdown restart the DB
3) Use this anonymous pl/sql block:
declare
job number;
begin
On 19 Apr 2001, at 17:50, Jared Still wrote:
Date sent: Thu, 19 Apr 2001 17:50:27 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
...
In my experience, DBA's are scum and developers lobby the managers
with tales of how terrible life will be
Is it possible that it can be networking or OS
problem , when I send the data across network after some 7000 bytes data is
getting corrupted carriage return or linefeed are added in between data
.
Any Expert
-Bigp
- Original Message -
From: Big
Planet
To: Multiple
I
can't answer your question directly but I would like to point out a few
things. Your select count on rowid will miss chained blocks, the first
block of the first segment which is used for freelist chains, and as I learned
some time ago that oracle used more blocks to keep track of the
Hi Ed and list,
Most of my bad experiences with SAME have been related to adding disk capacity,
rather than its performance which is normally OK.
The first time I hit it was about 5 years ago when someone had configured the 30
4G drives as a single striped and mirrored volume 15 disks wide, and
I've thought that it would be interesting and lucrative work offering
third party apps companies my services in modeling and designing
databases.
Problem is, they don't understand how bad they truly are. Anyone
have ideas on selling ignorant ( no disrespect intended ) folks on
why they need
Listers,
Oracle Designer can now be bought as a part of the "Oracle internet
Developer Suite" which has Developper (FormReports) and JDevelopper as
weel. I would like to know what is the relative relation of the prices of
those three parts. Does anyone has an older PO with Developper and
I guess I'm saying that I can't recall starting with a completely
normalized database ( just 3rd normal form here ) and then denormalize if
we found it necessary for some reason.
We've usually have had some denormalization in as soon as we started
doing physical modeling. Sigh.
Do you know the syntax?
--- "Jamadagni, Rajendra"
[EMAIL PROTECTED] wrote:
You can use dbms_job to achieve this ...
Raj
__
Rajendra JamadagniMIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is
Manas,
Recheck your classpath and the versions of your classes file(i.e. correct
jdk / classes compatibility). This error is clear, it can't find the JDBC
drivers.
Sam
-Original Message-
Sent: Friday, April 20, 2001 10:01 PM
To: Multiple recipients of list ORACLE-L
I am trying to
73 matches
Mail list logo