Free buffer requested

Hi list, Scenario Sun 880 Solaris 8, Oracle 8.1.7.3, 8GB Ram, 4 processors Redo logs 200MB size 4 groups in 1 disk DBWriter = 2 log buffer 200 BM Shared Pool 1 GB db block buffers 100,000 db block size 8K I started a process and checked the V$sysstat and get those values are extremely high

RE: System applying grants

Thank you Jared, I was confused, thought that the GRANT ANY PRIVILEGE ROLE, would allow that !!! Tks -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of Jared Still [EMAIL PROTECTED] Sent: Saturday, April 20, 2002 1:28 AM To: Multiple recipients

System applying grants

Hi gurus, I created a script to assign some grants automatically to some roles and users. As the user sys, I assigned to user system the GRANT ANY PRIVILIGE, GRANT ANY ROLE, roles and when run the script get the error of insufficient privileges. What I dont want is to connect to each user to

RE: DB Trigger to keep record of DDL

Thanks Jesse and Stphane. This script works, and is more elegant than my workaround. Tks. Ramon -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of Jesse, Rich [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 5:28 PM To: Multiple recipients of

Audit DB

Hi List, Is there any article that describe the pros and cons about activating the audit options in a Database. In oracle class manuals and Oracle 8i Administrator Guide, there is not enough information about that topic. What I have read and heard is that DB Audit should be the last option

RE: How to tune SQL and CPU usage

David, The parameter PROCESS control the number of process that can be running in the instance. Yes, you can tune the SQL instruction. You can use the Trace utility or the plan table to do that. Ramon -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of

RE: DB Trigger to control PK change

Thanks to all that reply, I will make a try Ramon -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of John Carlson [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 8:33 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:

RE: DB Trigger to control PK change

My version is 8.1.7.3 on AIX and Solaris. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of Jesse, Rich [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 6:24 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:RE: DB

DB Trigger to keep record of DDL

I did that trigger, it works if the only is logged in just once. It gives me the errors of more rows returned 1422. How can I know in what session he is. CREATE OR REPLACE TRIGGER CONTROL_DDL BEFORE DDL ON DATABASE DECLARE NOMBRE_MAQUINA VARCHAR2(20); USUARIO_MAQUINA

Trigger to control DDL in DB - Solved

Hi list, This is the solution to my problem. If anyone interested take a look and go ahead. TKS. Ramon CREATE OR REPLACE TRIGGER CONTROL_DDL BEFORE DDL ON DATABASE DECLARE NOMBRE_MAQUINA VARCHAR2(20); USUARIO_MAQUINAVARCHAR2(20); BEGIN SELECT MACHINE, OSUSER INTO

RE: Ticket tracking system

The solution of adding a column es very good, but you can create a table to keep the closed tickets(deleted) and if you want to reopen it, just look it in that table and recreate it. Assuming that the quantity of reopened tickets is small this will work for you Luck -Original

DB Trigger to control PK change

Hi List, I want to create a trigger that insert into a table anytime a user change or compile a package doesn't matter who create it or compile it. Is there a trigger at DB level, like the on logon, that I can create to keep this kind of control. I did some FM but couldn't find nothing.

Creatin TBS in Raw Devices

Hi List, First time using raw devices. I created the raw device, made the link ln -s /dev/rdata01 /oradata/orcl/data01 and when trying to create the TS get an error of not enough space. create tablespace my_data datafile '/oradata/orcl/data01' size 100m extent management local uniform

RE: Error in procedure with dba_users

Tks Suzy and all that reply, I will do some FM to take a look of DBMS_STATS Ramon -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of Suzy Vordos [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 7:48 PM To: Multiple recipients of list ORACLE-L

Error in procedure with dba_users

Hi list, I have this procedure under the system user, and when try to create it I get an error CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS CURSOR ESQUEMAS IS SELECT USERNAME ESQUEMA FROM SYS.DBA_USERS WHERE USERNAME IN ('RAMON', 'SCOTT'); BEGIN

RE: Error in procedure with dba_users

tKS David, that worked. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of [EMAIL PROTECTED] [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:14 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:Re: Error in procedure

RE: Error in procedure with dba_users

Adary, I am creating the procedure as system. I can select the table without no problem. I changed to all_users and worked fine, but the dbms_utility doesn't work. Below is an example. TIA Ramon. CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS CURSOR ESQUEMAS IS SELECT

Raw device

Can anyone point me to a FM or explain me what is a raw device, and why not use simple file system instead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: Error in procedure with dba_users

Tks Jesse, I like that solution, more than I worked it out. tks -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of Jesse, Rich [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 6:13 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]