How To Monitor ALTER TABLESPACE Ddl Change

Jan 8, 2013

I can use trigger to monitor ALTER TABLESPACE ddl statement against a particular tablespace in a schema.

CREATE OR REPLACE TRIGGER HOT_MAIL_DDL_CHANGE
AFTER ALTER TABLESPACE <tbs_name>
ON SHANNURA.SCHEMA
BEGIN
INSERT INTO HOT_MAIL_DDL_AUDIT_LOG VALUES
(SYSDATE,
SYS_CONTEXT('USERENV', 'SESSION_USER'),
ORA_SYSEVENT,
ORA_DICT_OBJ_TYPE,
ORA_DICT_OBJ_NAME
          );
END;
/

I think, line no.2 isn't a valid statement. Or can I use AUDIT instead - in fact, I want to monitor/audit only ALTER TABLESPACE ddl statement and that too for a particular tablespace only.

View 3 Replies


ADVERTISEMENT

Server Administration :: Monitor Increment Of Space Of Tablespace Based On Table?

Jun 9, 2011

How to check for the increment of a space of the tablespace based on the particular table. (i.e.) Say a scenario, if am trying to load the data for a particular table, for first I loaded some 10000 records and then again loading 50000 records ,so based on the icrement of the reocrds the tablespace size also increases gradually . so for this scenario how to monitor the increment of the space.

View 13 Replies View Related

Way To Alter Tablespace

Jan 22, 2013

I have issue of TABLESPACES on test instance. Tablespace files are TEMP1,TEMP2 and APPS_UNDOTS1. Initially TEMP1 and TEMP2 were of 4 GB but now the have grown to 32 GB each respectively. Resulting an occupied space of 64 GB on test server. I want to reuse that space on test instance as those tablespaces never crosses used space of 1%. Reason of this problem was my DBA set AUTOEXTEND as ON for tablespaces.

Attached File(s)

 1.jpeg ( 1.8MB )
Number of downloads: 1

 2.jpeg ( 1.6MB )
Number of downloads: 1

 3.jpeg ( 1.52MB )
Number of downloads: 0

View 1 Replies View Related

Alter Tablespace Rename

Sep 28, 2012

I would like to rename tablespace A to B , but when I do it tables after rename tablespace have columns tablespace_name.dba_tabkles in A . Is possibility to change it into without move ?

View 6 Replies View Related

Server Administration :: Alter Tablespace

Jan 4, 2011

My tablespace contains two datafiles dfile1.dbf and dfile2.dbf on D drive of my filesystem. Now i copied these dbf files on pasted it on a location in E drive. Now i want my tablespace to use dbf files pasted in new location.

Will i have to Alter Tablespace Add Datafile with Reuse clause

View 2 Replies View Related

SQL & PL/SQL :: Change Password Without Using ALTER Statement?

Aug 9, 2010

Requirement: I need to create a Function to allow users to change their own password when they are logging in to an application. Also, I would prefer to not use the ALTER command.

View 12 Replies View Related

Alter Existing Users For Default Tablespace?

Mar 5, 2012

My user tablespace has been full and just I create new tablespace like User_Tablespaces.

I want to Alter Default Tablespace and Quota define of all existing user on User_Tablespaces.

How we do in a SQL Query or PL/SQL query that can all existing users has been alter at a time in a single query.

View 2 Replies View Related

Dynamic Alter Tablespace Statement To Add Datafiles

Jan 21, 2013

I need a PL/SQL stored procedure which will accept a datafile name as parameter and dynamically create and execute "alter tablespace" command to add this passed datafile dynamically.

View 6 Replies View Related

Server Administration :: How To Alter / Change Size Of Tablespaces

Feb 26, 2013

1-how can i alter/change the size of tablespaces?.

2-is any changing in tablespace size will effect the over all performance?

Tablespace ; Size (MB); Free (MB); % Free; % Used
------------------------------;----------;----------;----------;----------
USERS ; 5; 4; 80; 20
SYSAUX ; 600; 140.875; 23; 77
UNDOTBS1 ; 640; 114.125; 18; 82
SYSTEM ; 700; 28.3125; 4; 96
TEMP ; 64; 0; 0; 100

View 4 Replies View Related

PL/SQL :: Cannot Create Table After Change Schema With ALTER SESSION

Sep 1, 2012

SQL> ALTER SESSION SET CURRENT_SCHEMA = CLA_T3;

Session altered.
SQL> select sys_context('USERENV','SESSION_USER') current_user,
2 sys_context('USERENV','SESSION_SCHEMA') current_schema
3 from dual
4 ;

CURRENT_USER
--------------------------------------------------------------------------------
CURRENT_SCHEMA
--------------------------------------------------------------------------------
CSR_ETL
CLA_T3

SQL> set linesize 300;
SQL> /

CURRENT_USER
----------------------------------------------------------------------------------------------------
CURRENT_SCHEMA
----------------------------------------------------------------------------------------------------
CSR_ETL
CLA_T3

SQL> create table cla_t3.test (r number, b char(2));
create table cla_t3.test (r number, b char(2))
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> create table test (r number, b char(2));
create table test (r number, b char(2))
*
ERROR at line 1:
ORA-01031: insufficient privileges

After Setting current schema to 'CLA_T3', I am unable to create table in cla_t3 schema.

View 5 Replies View Related

How To Change Tablespace Plugged_in (no Status To Yes)

Aug 6, 2010

how to change tablespace plugged_in =no status to yes

View 1 Replies View Related

Server Administration :: Trying To Change Tablespace And Datafile Properties On Fly

Aug 21, 2011

This facility has one last 10g database and a very problematic tablespace and last datafile associated with it. The tablespace was set up with INITIAL_ EXTENT of 131,072 (128K) instead of the more 'normal' 4,194,304 (4M) and NEXT_EXTENT of 262,144 (256K) instead of 4,194,304 (4M).

More worryingly, the datafile has INCREMENT_BY set to 1 (8K) instead of 1,280 (10M) or 2,048 (16M).Has anyone ever updated sys.ts$.dflinit and sys.ts$. dflincr to modify the INITIAL_EXTENT and NEXT_EXTENT, and sys.file$.inc to modify the INCREMENT_BY?

View 7 Replies View Related

Server Administration :: Change Tablespace Of A Table Using Dbms_redefinition

Aug 10, 2011

Does dbms_redefinition can move the tablespace to another of a table,including indexes?

View 4 Replies View Related

SQL & PL/SQL :: Difference Between Alter Session And Alter System

Jun 19, 2013

What is the difference between alter session and alter system?

View 2 Replies View Related

Can Monitor 10.2.0.2 Databases Using OEM 11g

Feb 7, 2011

In my company we have few 10.2.0.2 databases and few 10.2.0.4 databases.Currently we are monitoring using OEM 10g (10.1.0.5.0) installed on a seperate server.

Planning to install OEM on a new server as part of server room renovation. let me know the process of installing OEM on a different server without loosing the historical data?Also wondering if the OEM 11g will support the current databases?

View 2 Replies View Related

Flag Or Monitor CPU Utilization?

Dec 22, 2010

I have to run a resource extensive SQL. It utilizes CPU to a great extent. I've created a new user just to run this particular report. I need to ensure that this particular user doesn't uses more CPU.

Hence, I need to generate an alarm (email) only if a threshold is exceeded for a certain period of time (above x% for y minutes),(example more than 80% for 10 min.), so that I can either kill the process or continue running it depending on CPU usage.

Can I do it using scripts or OEM. I couldn't find any specific metrics to do it in latter. (I'd prefer scripts though. )

My system details are as follows:

1. Database: Oracle 10g R2
2. Unix: Sun OS 5.10

View 2 Replies View Related

How To Monitor Oracle Application R12

Jul 16, 2011

How can I monitor Oracle Apps R12 on Linux RHEL5. Application and database status.

View 2 Replies View Related

SQL & PL/SQL :: Monitor Jobs From Procedure?

Dec 31, 2010

We have a job table, and whenever jobs are added to this table the job processing procedure should be started.

In unix we have crontab facility where we can schedule to run for 24/7.

similarly do we have any option in oracle daatbase, to keep on running a prcedure in loop.

View 2 Replies View Related

Windows :: Monitor The Cpu Utilization On Xp?

Jul 16, 2010

how can we monitor the cpu utilization on windows xp.

View 2 Replies View Related

How To Monitor Drop User

Jan 31, 2013

How to monitor the DROP USER command?

OS: AIX, Oracle: 11.2.0.2

View 8 Replies View Related

How To Monitor Space Of Database In RAC And NON-RAC

Nov 17, 2012

I need to monitor the Database daily, so i need to check whether the size of the DB is increasing @ a slow rate or rather than that. I need to do it in RAC & NON-RAC.

View 3 Replies View Related

Monitor The Creation Of New Datafiles / Tempfiles?

Oct 15, 2012

I am looking for a way to monitor the creation of new datafiles / tempfiles.Let's say I am creating a new datafile of 8GB in size, and it takes a few minutes to create.

I have looked at v$session_longops, and several other system views, but cannot find any that indicate how the file creation is progressing.

I want to be able to display something simple, such as "72% complete".

View 1 Replies View Related

Client Tools :: SQL Monitor Alternative?

Jan 5, 2011

Many moons ago, at a previous employer, I had access to the SQL Monitor tool that came with TOAD. I could really use an alternative to this now, as we don't have TOAD here, and it would need to be free. I'm getting a problem with a forms update failing, and I really need to see what's actually being submitted to the database by the form. We're still stuck on Forms 6 by the way

View 2 Replies View Related

Replication :: How To Monitor Complete Refresh

Oct 29, 2008

I am using basic replication in oracle 10.2.0.3. My materialized view object contains around 3 million records. Usually we are using FAST refresh but in my materialized view having some problem that’s the reason I am going to Complete refresh.

If I start complete refresh it will take 8-12 hours to complete refresh.

My Question is: During Complete refresh how to monitor complete refresh running or not except using

v$mvrefresh.

Is there any way to monitor complete refresh because suppose target database not available/network problem/ dead lock occur in my database. I can’t able to track refresh.

Even there is no notification in alert log.

View 1 Replies View Related

Server Administration :: Monitor PGA Utilization?

Dec 28, 2011

I have a requirement to monitor the PGA utilization with time to time. Provide a good script which will effectively show the pga utilization.

View 2 Replies View Related

Security :: SQLs To Monitor User Access?

Jul 2, 2011

There is a user account called 'BALA'.How to create SQLs to monitor 'BALA' user access ?

View 9 Replies View Related

Server Utilities :: How To Monitor Export And Import Job

Apr 28, 2012

how can i monitor the export and import job and how increase the export and import job performance.

can i monitor the export and import job by checking the log and dump file created by export and import and can its performance increase by configure parallism. m i right or not?

View 2 Replies View Related

How To Monitor Alert Log File (using Any Tool Or Manual)

May 10, 2013

1)How to monitor alert log file (using any tool or manual)?

2) What are the implications of a database with multiple data block sizes?

View 4 Replies View Related

Windows :: Tool To Monitor Oracle Host And Services?

Jun 29, 2010

What tool can be used to monitor Oracle host on Windows environment if the database goes down? I know about "Nagios" but like to know is there any other tool available?

View 6 Replies View Related

Networking And Gateways :: Logs Or Queries To Monitor Clients IP

Oct 13, 2012

Is there any logs or query where I can monitor client's IP previously connected to the database? I have created 2 listener with 10.1.2.x and 10.1.100.x network. I would like to separate the oracle traffic to the 10.1.100.x alone. As of now both can connect to the database. I like to monitor if everybody is already transferred to the 10.1.100.x network before I will disable the 10.1.2.x.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved