How will you check Memory leakage in the SGA and how to rectify it.
Regards
MANI PS
-
Sify Mail - now with Anti-virus protection powered by Trend Micro, USA.
Know more at http://mail.sify.com
Want to get into IIM? Take the Sify Mock CAT now!
sultan wrote:
Hi friends,
I have a tables A and B
DESC A
IDNUMBER
NAME VARHAR2(10)
DESC B
---
ID NUMBER
SUBNAMEVARCHAR2(20);
In the above table B.ID is the foreign key to A.ID.
How can I create unique value
What I have understood is that against each ID in table A there are several
Sub-Names in table B.
Your data in table A is:
1,
and in table B is
1*,
1*,
1*,
(* has an ID 1 which is there in table B)
You want that the any of above 3 record should not be possible to insert
Congrats!!!
Hope everything goes well, I'll keep me bits crossed :o)
-Original Message-
Sent: 31 August 2002 03:18
To: Multiple recipients of list ORACLE-L
MY SISTER IS PREGNANT!!!
Early days yet, and she will be very very very careful for a long time
yet but she's pregnant!
Title: normal user obtaining program info?
Hello Gurus,
I would like to try and build in some security onto a certain schemas tables, using for instance from system, I can do a select from v$session to obtain program name etc. ie,
SELECT PROGRAM FROM V$SESSION;
An extention of this a
Title: Can DB tell if connection from odbc?
Hello Gurus
Is there anyway that Oracle 817/Win2K can pick up whether the user is connecting via ODBC at all?
As I understand it the ODBC comes in through the Net8 and therefore the above is not possible.
Regards
Denham Eva
Oracle DBA
In UNIX
Thanks Naveen,
Lets forget aboutthe statistics and
performance, but I have such type of requirenment than is there any way out
?
Marul.
- Original Message -
From:
Naveen Nahata
To: Multiple recipients of list ORACLE-L
Sent: Saturday, August 31, 2002 11:58
PM
Denham Eva wrote:
Hello Gurus
Is there anyway that Oracle 817/Win2K can pick up whether the user is
connecting via ODBC at all?
No. Concerning your problem about getting the program name, it doesn't
seem to belong to the list of what SYS_CONTEXT can return. Write a
function as SYS
For a NEW SQLServer2k Database Setup what are the Current Best-practices for :-
Qs What should be the Filesystem Block-size ?
Qs What should be the Stripe Width for an OLTP/Hybrid Nature of Application ?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Hi
By 64K block size Did you mean File system (FS) Block-size Or Stripe Width (RAID 0)?
Qs On Windows is there a Concept of File system (FS) Block Size Like Unix O.S.?
Qs What would be the Stripe Width (RAID 0) Advisable for OLTP/Hybrid Application?
NOTE - FS Block Size Differs from Stripe
Apage, Satanas, apage!
:-)
On Monday 02 September 2002 13:18, you wrote:
For a NEW SQLServer2k Database Setup what are the Current Best-practices
for :-
Qs What should be the Filesystem Block-size ?
Qs What should be the Stripe Width for an OLTP/Hybrid Nature of Application
?
Thanks
--
Title:
Marul,
have a
look at table partition and ALTER TABLE EXCHANGE PARTITION WITH TABLE statement.
Using the combination of these approaches you're able to limit index rebuilding
with a few partitions if your indexes are local. At least you will be able to
separate I/O.
Regards,
Ed
Could you have a trigger which before insert, inserts into another empty
table with exactly same layout but rejects the insert on the main table.
Then disables the trigger and adds these at a non-busy stage and reenables
the trigger. Would be a whole lot quicker if it's possible.
1)How to deduct memory leakage and to recify it in oracle 8i
2)From header file where is the location of the last SCN
Regards
MANI
-
Sify Mail - now with Anti-virus protection powered by Trend Micro, USA.
Know more at http://mail.sify.com
Want
Iain,
thats a fantastic idea.
Naveen
-Original Message-
Sent: Monday, September 02, 2002 5:28 PM
To: Multiple recipients of list ORACLE-L
Could you have a trigger which before insert, inserts into another empty
table with exactly same layout but rejects the insert on the main table.
Hi Eva
Have a look at VPD (Virtual Privet Database) and FGA Fine Grained
Access) in the manual
Denham Eva wrote:
Hello Gurus,
I would like to try and build in some security onto a certain schemas
tables, using for instance from system, I can do a select from
v$session to obtain program
if u are very sure about the data, then how about
inserting these data into a temporary table until eod, and insert into actual
tables after ur busy hrs.
- Original Message -
From:
Marul Mehta
To: Multiple recipients of list ORACLE-L
Sent: Monday, September 02, 2002
Hi!
How to find out number of CPU's and
ammount of RAM on AIX machine?
Thanks,
Vladimir
Query V$SGA. Unless you are running Oracle9i, there are no memory leaks in
the SGA, because all allocation of memory for the SGA (prior to Oracle9i)
occurs at instance startup and then at no other time. Just as in crime
investigations, you must have MO: motive and opportunity. No
opportunity,
Hello,
We're trying to understand the reason behind this !!!
When we run a specific job against the database when it is in noarchivelog mode, it completes without a problem.
When we run the same job after we switch the database to Archivelog mode (and during a hot backup), we're seeing
Vladimir Barac wrote:
Hi!
How to find out number of CPU's and ammount of RAM on AIX machine?
Thanks,
Vladimir
For the number of CPUs the most portable command I have found is
SQL select value from v$parameter
2 where name = 'cpu_count';
I wish there were the same thing for memory
As SYS,
create view MY_SESSION as
SELECT ... FROM V$SESSION
WHERE SID IN (SELECT SID FROM V$MYSTAT);
grant select on MY_SESSION to public
create public synonym ...
hth
connor
--- Denham Eva [EMAIL PROTECTED] wrote: Hello
Gurus,
I would like to try and build in some security onto
a
Hi Vladimir,
For Ram: 'lsattr -E -lsys0' or lsdev -C | grep Memory
For Cpu: vmstat
Tool : smitt
Alessandro Guimarães
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 02, 2002 8:08 AM
Vladimir Barac wrote:
Hi!
How to
Hi Vladimir,
To find number of procs:
# lsdev -C | grep proc
To find amount of physical memory:
# lsattr -l sys0 -E or
# lsdev -C | grep mem and to each memory board
# lsattr -l mem0 -E
HIH,
Antonio Belloni
Sunny,
During
the hot backup, Oracle uses Log files and Rollback segments extensively if
writes are being performed against the objects in the tablespace currently in
HOT BACKUP.
That
explains ORA-1555 because the data in the rollback segments gets overwritten
pretty soon(causing
Hi All,
I know the problem is on NT machine, whereas most of the people in the list
are working on UNIX based systems. Still any pointers will be appreciated.
I have a system with 2 databases, both running on the same server.
DB - 8.0.5.
OS - Windows NT
When i connect thru server manager to
___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis!
Descárgalo ya desde http://messenger.yahoo.es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
TEST
Hi List.
does anybody know what the OPTIMIZER_MODE = NONE
mean in v$sqlarea view ?
I've found this document Doc ID: 48131.996 in
metalink, but it seems that I don't have access to it.
The problem I'm facing here is that I am getting this
information when analyzing v$sqlarea.
its showing up, ur test works.
cease and desist.
joe
Diego Cutrone wrote:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
ok, I'm sorry Joe.
But I really do not see my own postings.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 02, 2002 4:18 PM
its showing up, ur test works.
cease and desist.
joe
Diego Cutrone wrote:
--
Diego Cutrone[SMTP:[EMAIL PROTECTED]] wrote:
ok, I'm sorry Joe.
But I really do not see my own postings.
Send a help message to [EMAIL PROTECTED], ( e.g. put HELP ORACLE-L as the
subject/body). This should return some useful info about the options
available to you. While the engine running
Have not heard from Oracle as of yet regarding removing the SQL*Plus
interface. To my knowledge, there are extensive enhancements being made to
SQL*Plus.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL
Denham Eva[SMTP:[EMAIL PROTECTED]] wrote:
Hello Gurus
Is there anyway that Oracle 817/Win2K can pick up whether the user is
connecting via ODBC at all?
As I understand it the ODBC comes in through the Net8 and therefore the
above is not possible.
Denham,
It might be possible, but
Naven,
On NT while creating the service (prior to creating the Database) using ORADIM (oradim SID= PFILE= INTPWD=...), one gets to specify which PFILE should be used while starting up (as the default). I am wondering if that is where the problem lies. The good news is that the you can easily
Did anyone else run into the error dbbackup_begin: syntax error at line 521
'end of file' unexpected after trying to use the Velpuri backup scripts for
Unix? Where was the problem at and how did you resolve it? I downloaded the
scripts from the Osborne website and this is the error that keeps
Please don't sent any more mail to this ID
Please take it as a request
Please ignore my name
Mail ID : [EMAIL PROTECTED]
Thanks
System Admin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: RO-Hosur
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
40 matches
Mail list logo