Security :: Generating Traffic Report Of Tablespace Or Schema?

Nov 11, 2013

 at an Oracle 11gR2 (11.2.0.3.0) Enterprise Edition (fully licensed) with RHEL 6 as OS

I'm trying to generate a statistic, that shows me a weekly or monthly report over the traffic on a tablespace or a schema. Until now, I've worked with the

HIST_VIEW dba_hist_tbspc_space_usage

(I mean there is also one nearly called so for schema), but that view show me only the grow of a tablespace in a timeline of 1 week.

But that would not be the hole traffic. Because SELECT statements will nothing do on the grow of the tablespace but it generates traffic. In that case it wouldn't be so important, if it is more tablespace or schema sided because at this database each tablespace has it's own schema and timeline would be nice if it is weekly or monthly.

View 5 Replies


ADVERTISEMENT

Security :: Database Hung While Generating AWR Report

Apr 13, 2013

My database is hung while generating the AWR report. I observe the mmon is running for long time. is it okay if i kill, will that have any impact to database.

View 2 Replies View Related

Generating Schema From XSD Files?

Jul 7, 2010

generating oracle table definitions from XML .xsd files?

View 5 Replies View Related

Generating Script For Roles For Schema Import?

May 19, 2011

I want to import schema1 from sourcedb to targetdb. For this I need to generate create sripts and grant scripts for roles related to schema. For example schema1 has role1; rol1 has rol2; rol2 has rol3 and some system privileges and object privileges. How can I generate this script from sourcedb?

View 1 Replies View Related

Security :: Schema Consolidation And User Schema Mapping Based On Service

Jul 24, 2011

We have an application with many separate databases (one per customer). Given they share the same business requirements (service hours, change mgmt etc), we're interested in potentially consolidating the separate DBs (which are relatively small) into separate schemas within a fewer no of databases to reduce the overhead.

Our issue is that the application is hard-coded to use a specific administrator and application connection user name. Changing this is unfortunately not an option.

Given this limitation, is there any possibility to map a generic user into a customer-specific schema based on the database service that they connect to? Each customer connects to different database services but may use the same user name. We considered using private synonyms but this seems to acheive the opposite (i.e. many different users could connect and map to a single users schema). One thing to point out is that where there is a single user name, it is acceptable for a single password to be used across the different customer DBs as they will be a single admin/user.

View 5 Replies View Related

SQL & PL/SQL :: Generating Weekly Report

Apr 1, 2013

I know I am using a outdated Oracle what to do my company are not willing to upgrade because of the economic situtation.

I need generating weekly report.

I have a condition for monthly like this

invoice_date BETWEEN TO_DATE('01-JAN-13 00:00:00', 'dd-mon-yy hh24:mi:ss')
AND TO_DATE('31-JAN-13 23:59:59', 'dd-mon-yy hh24:mi:ss')

now if I want a weekly report Monday - Saturday, How to go about it?

View 2 Replies View Related

SQL & PL/SQL :: Generating Hourly Report From Oracle Database

Jun 30, 2011

I am working on SQL Developer 1.5.1, i need to prepare hourly record of the activity on the database, for that i have a sql query that gives me the report as per selected columns on hourly basis.I need to prepare 24 reports a day.

Each time i have to go to the query , change the date as per hours like form 22:06:2011 10:00:00 to 22:06:2011 11:00:00 and get the report and export it in excel.

I want to automate the script so that whenever i run the script , it just asks me the date and runs the script 24 times and fetch me the hourly report of whole day.

the query syntax is something like this

Select
............................
...........................
..........................
from
..........................
........................
........................
where
And.......................
And...................
And......................

And req date between to-date( 22:06:2011 10:00:00) And to-date(22:06:2011 11:00:00)
Order by 7,1,2,3,4,5

Is there any possibility that i can automate the script to automatically change the hour itself and generate a report in excel 24 times?

View 6 Replies View Related

Reports & Discoverer :: Migration From 6i To 10g - Report Not Generating In Web Layout?

Oct 5, 2010

Im using forms & reports 6i and 10g. I migrated a form from 6i to 10g.The form is working fine, But Im facing problem in report output.When i try to run the report in oracle 10g web layout. It shows error message.

Terminated with error: <br>REP-1247: There exist uncompiled program unit(s). REP-1247: Report contains uncompiled PL/SQL.

When i already compiled the report so many times.
ctrl+k
ctrl+shift+k
ctrl+s

But still got the same error message.

View 1 Replies View Related

Reports & Discoverer :: Report Generating Wrong Data In Windows 7

May 7, 2012

I am actually having problems with a report that is generating wrong data in Windows 7 only. I have the same report working correctly on many Windows XP Computers.

View 9 Replies View Related

SQL & PL/SQL :: Schema Vs Tablespace?

May 2, 2010

what is the data dictionary table to find out the default table space and temporary table space for a user.Let say i have a user called 'Pointers'.How to find out the default table space and temporary table space for this.I have checked in 'dict' table but no luck.

SELECT *
FROM dict
WHERE table_name LIKE '%TABLESPACE%'

View 4 Replies View Related

How To Delete Schema (Tablespace)

Jun 15, 2007

i have used toad to create a tablespace say XYZ and user ABC from the system schema.

Now i want to delete this tablespace xyz.

View 1 Replies View Related

Multiple Schema In A Tablespace

Sep 10, 2010

I'm having issues with things disappearing from my database. I know what you are thinking, OK Crazy things don't just disappear. The only thing I can think of that could be a possible problem is the way the oracle server is set up. (For the record, I don't agree with this set up. I was like this when I started with the company and they don't want to change it "because it works").

We currently have 90 + schemas on the server all in one tablespace. So the server has a data tablespace and an index tablespace. Every schema shares those tablespaces. It gets much worse that this but I'm not going to get into it.

Do you think that this set up would cause things to become missing?

View 6 Replies View Related

PL/SQL :: Moving Schema From One To Another Tablespace?

Oct 30, 2012

We need to move schema from one tablespace to another tablespace.

we are going to use following method:

alter table <tab> move tablespace <new_tbsp>;

my question is do we need to disbale primary keys and foreign keys before move and enable them at end.

View 4 Replies View Related

Changing Tablespace Of Schema

Oct 26, 2012

I have created my schema in SYSTEM schema way back accidentally by forgetting to specify the database tablespace. There is about 60 objects (tables, indexes, functions etc) and 6MB Of data.

What would be the best way migrate the schema to the tablespace I planned to put it into? .

View 7 Replies View Related

Security :: How To Grant A Percentage Tablespace

Mar 13, 2011

Is it possible to grant a user a percentage amount of a specified tablespace ? for instance granting a user called userx 5% of USERS tablespace. How can I do that ?

View 3 Replies View Related

Security :: Creating Table In Other Schema

Dec 29, 2011

I have a query ,

I need to create a structure DATABASE=>SCHEMA=>TABLE as

DB=>SC=>EMPLOYEE ...but after connecting database i could create table only user my user schema(own schema)only . I want to create a new schema called SC as public and need to create a table .

View 2 Replies View Related

Security :: Create Various Users On A Schema

Nov 19, 2010

I do a schema in oracle ... an m my question is if I can create 2 o more users for access to a schema..for example i have schema Project and i need that one administrator and 2 more users with others permission.

View 3 Replies View Related

Security :: Create Table Others Schema

Oct 18, 2010

how can i grant a user permission to create tables and indexes in other user schema.Grant create table permits the user to create tables in his own schema which is part of Resource role.Grant any table will permit him to create table in any schema including system which i don't want.

View 8 Replies View Related

Security :: How To Create User Under Schema

Dec 5, 2012

To make users under one schema.

1) user should have access of all objects with limited privileges.

How can i make it under schema?

View 3 Replies View Related

Security :: Tablespace Encryption - Data Migration?

Oct 22, 2010

Is it possible to migrate everything (tables, indexes) from a unencrypted to encrypted tablespaces online i.e. while the database is being used (DML)?

View 3 Replies View Related

Security :: How To Check Audit Enabled For Particular Schema

Jan 11, 2012

how to check that audit is enabled for any particular schema.

The below is my audit parameter from database level:-

SQL>SHOW PARAMETER AUDIT

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /db17/dbdump/xxxx/adump
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB_EXTENDED

View 4 Replies View Related

PL/SQL :: Tablespace Allocated / Used / Free And % - Used By Every Schema Level

Mar 11, 2013

One tablespace used in two different schemas ,in this case how much space used,free space and persentage of used in each schema level.

Example: USERS tablespace used in two different schemas HR,SCOTT. in this suche case to find the total size of tablespace, used and free space of each schema level.I used the below query not giving appropriate result.

SELECT TABLESPACE_NAME,
OWNER, round(SUM(BYTES/1024/1024),2) "Used Space in MB"
FROM DBA_SEGMENTS
where tablespace_name not in ('SYSTEM','TEMP','SYSAUX','EXAMPLE','UNDOTBS1') 
group by tablespace_name,owner
order by tablespace_name

View 4 Replies View Related

Security :: Enabling Audits Can They Be Applied On Tables Or Whole Schema

Apr 19, 2013

Enabling of auditing in oracle database, can this be done on some tables or applied on the whole schema/user.

View 5 Replies View Related

Backup & Recovery :: Tablespace Versus Schema Export

Aug 22, 2012

I have taken the tablespace export it came 2.1gb and for the same user i have taken the schema export it came 5.1gb

why their is a lot of difference in size?

View 3 Replies View Related

Server Administration :: USERS Tablespace Should Not Contain Schema Objects?

Jan 31, 2012

I heard that USERS tablespace should not contain any other application schema objects.

If the above statements is true , why it should not contain other schema objects ?

View 7 Replies View Related

Security :: Create User With Full Access On Default Tablespace?

Aug 12, 2011

i have been trying to create a user with full access on default Tablespace so that i can access all the objects without any restrictions for the new user.

View 7 Replies View Related

Getting Report For All Database (Tablespace)

Jun 2, 2013

My require is to get all tablespace used,free space report for all the databases. So I have scheduled Job in OEM to get it with below script. But always got error and my job is getting failed again and again. How to get the all tablespace (used,free space) report for all the databases.

sql' select distinct
a.tablespace_name,
SUM(a.bytes)/1024/1024 "Used Size MB",
SUM(decode(b.maxextend, null, A.BYTES/1024/1024, b.maxextend*8192/1024/1024)) "Max Size Mb",
(SUM(a.bytes)/1024/1024 - round(c."Free"/1024/1024)) "Total Used MB",
(SUM(decode(b.maxextend, null, A.BYTES/1024/1024, b.maxextend*8192/1024/1024)) - (SUM(a.bytes)/1024/1024 - round(c."Free"/1024/1024))) "Total
[code]......

View 2 Replies View Related

Schema For Oracle Report Developer 10G Course

Nov 27, 2009

I took the course for "Oracle Reports Developer 10g" but I didn't copy the schema when I took the course.

Now,I have the book "Oracle Reports Developer 10g: Build Reports Student Guide" but I look over the internet and I can't find the schema for this course. I needed the schemas for the following tables:

CUSTOMERS
ORDERS
ORDER_ITEMS
WAREHOUSES
INVENTORIES
PRODUCT_INFORMATION
PRODUCT_DESCRIPTIONS
ONLINE_MEDIA
PRINT_MEDIA

where I can find the sql scripts for this schema ?

View 2 Replies View Related

Security :: To Find All Failed Logins Through Audit Report

Feb 9, 2011

I have to find all the 'failed log ins' through audit report. then it has to be uploaded to a table. The script, either in windows or unix should be reusable and can read files one by one.

View 13 Replies View Related

Security :: Viewing Report Of Audit Trail From Dba_audit_trail

Apr 11, 2013

in my environmnet audit is working audit_trail=db,extended . i am also viewing report of audit trail from dba_audit_trail or aud$. But problem is that i have to generate report on which object of schema what audit is running .

or from which tables we can get information of following commands.

AUDIT ALL BY xx_test BY ACCESS;
AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY xx_test BY ACCESS;
AUDIT EXECUTE PROCEDURE BY xx_test BY ACCESS;

View 3 Replies View Related







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