Hi all
gurus,
I want to learn the way to ook
at
Which tables are in buffer
cache./Analyzed?
Is there a system view showing these
tables??
Thanks to All.
Bunyamin K.Karadeniz Database
Group / Information Systems Department HAVELSAN Ankara
/TURKEY Tel : +903122873565 / 1681
Mobile
Hi,
Error messages???
Not sure if it matters, but could it be that export was done with 8.0.4
binaries, and impirt tried with 8.1.5 binaries?
If I'm not mistaken you can run the catexp.sql that belongs to the 8.0.4
database (List ??)
Jack
hi all,
there is an urgent problem that cropped up while
ihad some problems with oracle 8(version 8.0.4) database and after taking
all the necessary backups, full database exports, physical copy of database and
net8 folder.. deinstalled it.
i then installed oracle 8i (version 8.1.5) and
Bunyamin,
You can check how many blocks are in the buffer cache for segments through
the x$bh and v$bh views.
Try this query,
select count,b.object_name from
(select count(*) count,objd from v$bh
group by objd) a, user_objects b
where a.objd=b.data_object_id
/
Regards
Suhen
Hi
from root (or from the starting directory you want to search from) do the
following
find . -type d 2/dev/null
Regards
Lee
-Original Message-
Sent: 02 May 2001 00:05
To: Multiple recipients of list ORACLE-L
what I would like to see is all directories...not files starting
Currectly I have specified UTL_FILE = * in my init.ora file because we
access files from several directories, including directories which are only
created at runtime.
Is it possible to specify UTL_FILE so that it gives access to all files
under a parent directory.
Or is it the case that we must
You have to setup heterogeous services.
Check in the Net8 guide under Configuring connections
to non-Oracle Databases Services.
Here what I've done to have a dblink between Oracle
816/Solaris and SQLServer 6.5 via ODBC MERANT.
Modify listener.ora to listen to hsodbc.
Add en entry in
At the moment they are doing and I kid you not, a range of Indian themed
burgers.
Lamb Korma
Chicken Tikka Masala
and another one.
Apart from the veggie burger, chicken sandwich and the filet-o-fish which
have been around for years and years the non-beef burgers are usually
special promotions
oops, I missed off the -exec bit.
find . -type d -exec ls -ld {} \; 2/dev/null
Cheers
Lee
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the
Bunyamin,
You should be able
to view these tablesfrom the SYS
schema.
Regards
Suhen
I see that there is no X$ tables in my
database or I can not view them . My O.S. is NT .
How can I view them.??
Thanks
Bunyamin K.Karadeniz
Database Group / Information Systems
Hi all!
Oracle 8.1.7 on AIX (8GB RAM (+ swap space 9GB)).
It concerns AIX memory 'problem'.
When I issue vmstat command, we got following result:
/u01/app/oracle/product/8.1.7.vmstat 2 4
kthr memory page faultscpu
- ---
In the alert log?
HP9K, HP-UX, Oracle 8.0.6.0.
I'm getting about 6 a day.
No apparent harm to the DB.
Metalink as usual says: can't reproduce
problem to most of these bugs.
Couldn't find a concrete fix to this anywhere.
Nope, I'm not using direct export.
TIA for any feedback.
Cheers
Nuno Souto
Hi,
As I understand, deja had been acquired by a company.
How to read/post messages to new usenet including web based or Netscape
Messenger ? I could not read by Netscape Messenger.
thanks...
--
Use itrprof SQL Analyzer.
It formats SQL_TRACE/Event10046 traces and gives tuning advises.
It's
Does anyone out there know what the best method would be to migrate from Oracle 8.1.6 Enterprise Edition to Oracle 8.1.6 Standard Edition? It appears from the docs that the only way to migrate from Enterprise to Standard is to do an entire rebuild of the database. (Export, de-install, re-install,
Hi list,
I have a problem with one of my customers databases. The value of
WILLING_TO_WAIT_COPY = 100. I have read that this value should be smaller
than 1. Parameter LOG_SIMULTANEOUS_COPIES is set to 4 in init.ora. Database
is Oracle 8.0.5 under Windows NT 4.0. Hardware is a 2 CPU machine.
Now
Title: RE: V$session
It's in v$process. Here's a script that displays it that I got off this list a while ago
set linesize 2000
column logon_time format a17
column username format a16
column unix_pid format a8
column machine format a20
column client_Program format a20
set pagesize 200
Does anyone have any examples of how to run a unix command from a java
stored procedure, and returning the exit code of the unix command?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Title: off topic: c, c++ and java list
Hi, all
Could anyone tell me there is any list regarding C, C++ and Java ?
thanks
li
Performance/Internals Wizards!
Anyone ever play with _row_cache_buffer_size?
I am having trouble with a crappy application and out of control
packages ( too big ) and public synonyms out the ying yang.
My 734 instance has DD cache size swells that remind me of
A Perfect Storm, except I bear
Title: RE: WILLING_TO_WAIT_COPY 1%
I had the same problem. Its shows 56% on 8.0.5 database.
But here is a thought. When I upgraded to 8.1.6 it shows 0%.
I still have one database on 8.0.5 where it shows 57%
Also this parameter LOG_SIMULTANEOUS_COPIES is gone in 8.1.6
Brijesh
You hit the nail on the head here:
Or is it the case that we must specify each directory individually if we
don't use UTL_FILE= *
Dan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dasko, Dan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Sound to me the same thing had happened.
He did not force a log switch after he finished back up all the datafiles
to tape.
If the required log (probably archive log) which is generated during the
hot backup of the database can no longer be found. Part of that hot backup
will be unusable.
--
" import the exported files after making the same
structue(tablespace and users) as there were in previous
install."
You
don't have to create the users. The import will create it for you. Also in your
case you don't have to create the database as the same path already exists as
old
'Oracle heterogeneous services' are purchased separately. They are services
that run on the target systems that allow Oracle to talk to them through
Net*8. We use an Oracle gateway to talk to our AS400s. For the most part,
this works well. Call your rep.
Todd Carlson
Oracle 8i Certified DBA
Everything u have specified set correctly it was
network problem as specified by jared and I was able
to solve the problem.
Thanks for ur help
Brijesh
--- Behar, Rivaldi
[EMAIL PROTECTED] wrote:
If ping is Ok and listener is running, try using IP
address
in your tnsnames.ora instead of
Lisa,
This is unfortunately quite difficult -- and if you have any circular
dependencies it's pretty much impossible. Otherwise, what you need to do
is follow the dependencies in the dba_constraints view.
For the drop order.
1) Drop all of the tables for which their PK constraint is not
ls -ld `find * -type d -prune`
note that those are back-quotes around the find command.
If you're worried about blowing your command-line buffer, if you've got a
*lot* of directories, use:
find * -type d -prunt | xargs ls -ld
At 03:05 PM 5/1/01 -0800, you wrote:
what I would like to see is
What kind of error you are getting from the import?
Since you already have created the tablespaces and users in your new
database, did you put IGNORE=Y when you perform the import?
Winnie
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~``~
(@ @) @}-`-,-`-,--- Winnie
At 07:20 PM 5/1/01 -0800, you wrote:
Haven't seen this one mentioned yet:
find . -type d -print | xargs ls -ld
Jared
This one does a recursive list. The one I posted only does the current
directory. Not sure which variation the poster wanted.
Dennis Taylor
Could someone please tell what is OS block size on solaris 8
Mujeeb
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mujeeb Chowdhry
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
Hi, We recently lost our DBA, and as I was standing
too close to our IT manager, now I'm it. As I get
started on reading and studying, I quickly need some
scripts to monitor 'normal' stuff on 7.3.4. I'm used
to SQL as a developer, so that helps. So, do you know
of a source where I can download
I'm starting to feel my signature is inadequate!
Mark
(plain and simple boring me)
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, May 02, 2001 06:57
To: Multiple recipients of list ORACLE-L
Sound to me the same thing had happened.
He did not force a log switch after he
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.
Sonja,
The 'fre' column is not exactly
The column named PROCESS.
[EMAIL PROTECTED] 05/02/01 12:00PM
Hi
Which column in v$session indicate os process?
Thanks
-seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official
Lisa, your attachment had a virus in it. My local server detected it. Everyone, DO
NOT OPEN THE ATTACHMENT in emails with the Subject: Uniquely Weird - duplicate rows.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
INET: [EMAIL PROTECTED]
Fat City
Basically you should drop the constraints of type 'R' first, then drop the constraints
of type 'P' and 'U'. See the CONSTRAINT_TYPE in the USER_CONSTRAINTS view.
[EMAIL PROTECTED] 05/01/01 05:50PM
Hi -
When dropping and/or re-applying constraints for an entire schema, is there
a dictionary
Remember use ignore=yes to ignore create errors on existing tables, users. If you
don't, the import will probably fail.
[EMAIL PROTECTED] 05/02/01 02:06PM
import the exported files after making the same structue(tablespace and
users) as there were in previous install.
You don't have to
Hi
We had ORA-00600 [729] problem on a regular basis too. I am not sure
about your database errors, but in out database these errors are due to
audit_trail being turned on. In the PGA Ptvt. Audit Info memory chunks are
not being considered and they are being falsely identified as space
It is relating to incomplete/terminated export of database or any large
table. You may check this happening to your systemOracle patch 7.3.4.5
claims that it is fixed but it is still the problem...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
would it be reasonable, then to alter system archive log current, and then
back up all archived logs ... are there any pitfalls? ... thanks you
Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd.
Boca Raton, Florida 33487
nglasrot @seisint.com mailto:[EMAIL PROTECTED]
Direct
That error is in their knowledge and they can check in patchset note for
7.3.4.5 for fixes and they claim it is fixed but problem still exist
while terminating export while database goes down. We have this problem
with HP-10.20 and version 7.3.4.5
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
Metalink has some really good scripts. I'd try that (it's actually been
running half-way decent lately, you might get lucky =).
-::YEX::-
)))
-Original Message-
Sent: Wednesday, 02 May, 2001 11:37 AM
To: Multiple recipients of list ORACLE-L
Hi, We recently lost our DBA, and as I was
Where can I download the OCI drivers from ?I need the drivers
for Unix and NT.
Should I install the Oracle client to install the oci drivers.?
I was told that OCI drivers with JDBC connection pooling helps
to improve the performance.
Can pls anyone comment or contirubute their experience on
Ross,
Is this OPS?
According to Steve Adams ( this is how you make mail show up
in his mailbox :) that is for OPS.
Sorry, that's all I have to offer.
http://www.ixora.com.au/q+a/0008/31163237.htm
Jared
On Wednesday 02 May 2001 11:01, Mohan, Ross wrote:
Performance/Internals Wizards!
Suggestions anyone?? I'm attempting to get a standby database to run in
managed recovery mode, so that the archived logs
are automatically applied, however, when running the command 'recover
managed standby database' I receive the following error message:
SVRMGR recover managed standby
Hi All,
Yes, '_row_cache_buffer_size' does nothing for single instance Oracle.
There is a tip on setting '_row_cache_cursors' at
http://www.ixora.com.au/tips/tuning/row_cache_cursors.htm on the Ixora web site.
Ross, unless you can get an ALTER SESSION SET CURRENT_SCHEMA statement in there,
the
Title: RE: Sample Scripts
He was the one between Rick and Rick's IT manager.
-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Sample Scripts
I'm sorry to hear that
Thanks Steve.
The only useful reference to this parameter is on your web site. :)
Jared
On Wednesday 02 May 2001 14:22, Steve Adams wrote:
Hi All,
Yes, '_row_cache_buffer_size' does nothing for single instance Oracle.
There is a tip on setting '_row_cache_cursors' at
Listers,
6i Forms Server in a test environment is crashing quite frequently, 3 to 4
times a day.
I'm relaying this question, and I'm not real familiar with the back end
configuration details, so I might be off on some things. They have an 8.1.7
test environment with 9iAS 1.0.2. Platform is
Space leaks = Oracle malloced memory and did not free it when done.
There is actually an init.ora event that can be set to ignore memory leaks so
you don't have to see them in your alert log.
10262, 0, Don't check for memory leaks
// *Cause:Setting this event to level one causes memory
Please change the settings in your mail software so
that mail is sent out as plain text, at least for this list.
Jared
On Wednesday 02 May 2001 09:20, Fred Smith wrote:
htmlDIV
PFONT face=Courier NewDoes anyone out there know what the best method
would be to migrate from BROracle 8.1.6
Helmut,
Oracle *can* push the criteria down into the view definition in many
situations. Certain operations, though, will not allow this to happen. You
can find some info on Metalink, and, in the Oracle 8i Designing and Tuning
for Performance manual. There are other source as well. Here is a
Larry, I haven't worked with 9iAS yet, but have set up the previous
version of iAS on Solaris with Forms 6i.
This also uses the Apache server, Jakarta, etc, and we did not
experience the problems that you are.
Could be that 9iAS is still a bit on the bleeding edge. :)
Also, I was using the
Dick,
Backing up the redo logs can have some serious consequences.
Let's say you are restoring the database files, and a number of
archived logs to roll forward through.
Following that, you are going to roll forward through all archived logs
that are still online, and then through your
On Wednesday 02 May 2001 08:30, Mark Leith wrote:
You will need to either be connected as SYS or SYSDBA:
Well, you can easily remedy that.
http://www.ixora.com.au/scripts/sql/create_xviews.sql
Courtesy of Steve Adams.
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
On Wednesday 02 May 2001 12:50, Behar, Rivaldi wrote:
Hi,
I want to grant to Scott to Truncate my Emp
table (not to truncate all table).
How can I do that ?
Rivaldi
2 ways.
1. grant DROP ANY TABLE to the user. This is not recommended.
2. create a stored procedure to truncate the
On Wednesday 02 May 2001 12:51, Eric D. Pierce wrote:
Jared,
Apparently there are super geniuses at IBM may have invented a time
machine (along with free underground golf planners) that explains
the 90 days business.
The fact that these 'super geniuses' have hitched their carts
to Win2K
Lee,
If you quit using -exec you will do yourself a big favor.
That line will fork a shell for each directory found by find.
It can be rewritten as:
find . -type d | xargs ls -ld
Jared
On Wednesday 02 May 2001 02:05, Robertson Lee - lerobe wrote:
oops, I missed off the -exec bit.
find
On system A I am running oracle 8.1.7 on Solaris 5.7. I have a listener.ora
file which specifies port 1521. I start the listener. After about 1 to 2
minutes the PMON process registers the second listener and things look like
this...
LSNRCTL services
Connecting to
Hi all,
Do you have a handy way or some scripts to create a
schema which is identical to an existing schema (has
the same objects, data, grants, etc)? Thank you.
Leslie
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
Hi,
We have a number of large tables that we want to increase the performance of
queries against.
This will be using 8171 on NT utilising the Parallel query option (PQO) on a
server with 4 CPUs.
Ideally we would like to partition the tables but due to the cost of the
partitioning option
Same exact box, same instance. On NT, I found that I can do an ORADIM -delete, deinstall the software, reinstall the new software, do and ORADIM -new, and then run u0801050.sql. Problem is it leave all of the remnants of enterprise options such as MDSYS,CTXSYS, and AURORA$ORB$UNAUTHENTICATED
I'm sorry to hear that about your DBA. How did he die?
--Walt Weaver
Bozeman, Montana, USA
-Original Message-
Sent: Wednesday, May 02, 2001 9:37 AM
To: Multiple recipients of list ORACLE-L
Hi, We recently lost our DBA, and as I was standing
too close to our IT manager, now I'm it. As
Hi Fred,
On Friday, April 20, 2001 4:21 PM, [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] answered the same question for version 8.1.7
I actually did this yesterday and I seems to have worked fine on Windows
2000 for Oracle 8.1.7. I don't know if you can do this for 8.1.6 though.
Here are
64 matches
Mail list logo