Security :: Database Hung While Generating AWR Report
Apr 13, 2013My 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
ADVERTISEMENT
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.
SQL & PL/SQL :: Generating Hourly Report From Oracle Database
Jun 30, 2011I 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?
SQL & PL/SQL :: Generating Weekly Report
Apr 1, 2013I 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?
Reports & Discoverer :: Migration From 6i To 10g - Report Not Generating In Web Layout?
Oct 5, 2010Im 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.
Reports & Discoverer :: Report Generating Wrong Data In Windows 7
May 7, 2012I 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 RelatedOracle Hung Transactions
Jul 22, 2012I have the following PL/SQL program.
declare
v_amount NUMBER;
v_paymentno INTEGER := &sv_paymentno;
v_playerno INTEGER;
v_payment_date DATE:= SYSDATE;
begin
select 500 into v_amount from dual;
select 44 into v_playerno from dual;
insert into penalties values (v_paymentno, v_playerno, v_payment_date, v_amount);
end;
I forgot to add the commit statement and now I have hung transaction with dirty data with v_paymentno 27. Is there a way to commit or rollback that transaction?
Server Utilities :: Datapump Export Taking Long Time (HUNG)?
Aug 23, 2012Expdp directory=xxx.dmp dumpfile=aaa.dmp logfile=xxx.log FULL=Y
: :: : : :: : : : ;
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 24.87 MB
Processing object type SCHEMA_EXPORT/USER
[code]...
then my export hangs..... checked in alert log nothing found.and then killed the job and reran again but same....checked the status and it's saying EXECUTING.
RAC & Failsafe :: Oracle 11gR2 Grid Infrastructure Installation Hung At 65% Of Completion
Jul 4, 2013I tried to install 11gR2 grid infrastructure for 2 nodes RAC using VMWare as per the instructions provided in the below link.
[URL]
Until 65% installation went fine without any issues but after reaching this step "updating '/u01/app/11.2.0/grid/install/cluster.ini",it starts to hung. In the installation log file, I found these details.
Quote:filename = /tmp/.GsdDisplayed
INFO: Query Returned: false
INFO: Calling Action fileActions10.2.0.6.0 appendStringToFile
source = /u01/app/11.2.0/grid/install/cluster.ini
stringToAppend = [cluster_info]
cluster_name=rac-scan
[code]....
Security :: To Find All Failed Logins Through Audit Report
Feb 9, 2011I 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 RelatedSecurity :: Viewing Report Of Audit Trail From Dba_audit_trail
Apr 11, 2013in 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;
Application Express :: IR Report Page With Download (specific) Column Security?
Apr 24, 2013i have IR report page and download column as blob,how can security applied in specific column wise?e.g. Report page have more rows, and applied query in condition.
Select ID,dbms_lob.getlength(Blob_file) Download from Document_master
where Created_by=UPPER(:APP_USER)
OR
(exists (select '' from apex_workspace_group_users awgu
where awgu.user_name =:app_user AND awgu.GROUP_NAME='EMPLOYEE_GROUP'
)
)
Now all the rows with Download column to see EMPLOYEE_GROUP users,but i need control the download column only except Created_by=UPPER(:APP_USER) ,this case how can do the security.
Security :: Database Hardening?
Mar 13, 2009regarding Database Hardening, i am new to this concept
View 2 Replies View RelatedSecurity :: Password In New Database
Mar 7, 2012i have created a database on my pc and i have given a password at the time of installation , after the installation it is accessed successfully by the given password , but i observed that when i gave anything in password then it is also accessed by it and i don't have any other database of this same name.
And when i access it through another system then it is accessed only by its original password not by any other password.
Security :: How To Secure Database
Jul 18, 2010how can i secure my database from hacking by any one of these:
1-sql injections
2- DON(Danial Of service)
3- buffer overflow
4- listner hack
Security :: Database Field Size
Nov 28, 2012We have Employee table, there is a field name Employee_no. field size is 6.can we restrict some one not to increase or decrease the field size of Employee_no. even User has admin role.
is there any way to restrict admin user that he should not allow to enter the value of field more or less than 6 characters through Toad or SQL Plus 8.0.
------------------------------------------------------
for example
field: employee_no
feild_size: 6
field_type: Varchar2
When we enter Employee no A000001(7 digit) then database not allowed to update because its field size is 6 characters we want to restrict admin user in Toad or SQL Plus 8.0 because he is Toad and SQL Plus user.
Security :: Disconnect From Oracle Database
Jul 21, 2010Is there any setting on oracle that allows to disconnect users automatically and display a message to users such: "Try a new connection to the db in 30 minutes"?
View 7 Replies View RelatedSecurity :: How To Encrypt The Database Password
Aug 31, 2010We currently hardcode the password inside our Java application to make the connection with the Database,this makes the password to be visible to all users who can read the application code. How can we encrypt the database password so we don't have to hardcode it into the application?
View 1 Replies View RelatedSecurity :: Queries Run By Database Auditors?
Sep 10, 2012what sort of queries IT auditors run against the database? assist me wit these so that I can run them before hand in order to sort out any security vulnerabilities which we might potentially have prior to this being picked up by external auditors?
View 2 Replies View RelatedSecurity :: Virtual Private Database
Aug 25, 2012I am having one table Where,different country names are stored. while viewing data, I have to make sure that if country name having "USA" can only view its data. How can i do at DB level without passing where clause. Is Virtual Database in this case?
View 25 Replies View RelatedSecurity :: How To Encrypt 9i Database-link Passwords
Oct 13, 2010how to encrypt 9i database-link passwords? In 10g when we browse the link it show **** but in 9i it shows the actual password.
View 5 Replies View RelatedSecurity :: How To Find Current User In Database
Sep 22, 2011query to find the current user accessing the database
View 5 Replies View RelatedSecurity :: Export Policies And Import To Another Database?
Aug 24, 2012How can I export FGA / row level security policies from one database to another? I have created a new version of my schools ERP database, with upgraded application software, and now need to get the policies from our current production system to the new one.
View 5 Replies View RelatedSecurity :: Use Oracle Database On AIX With Active Directory
Apr 28, 2011I'm checking the possibility to use Active Directory to log on the our Oracle databases. But only for dba's and developers, not application users. We use Oracle 10.2.0.4 (and soon 11g) As OS on the databaseserver we use AIX5L 5.3
Is it possible to implement Active Directory on databases running on AIX ? If it is possible, what must be done to get it to work, software ... etc ?
Security :: ORA-06512 While Installing Datavault On 11g Database
Aug 7, 2013While installing datavault on 11g database, getting error in between the process. Error is as below -
ORA-01031: insufficient privileges
ORA-06512: at "DVSYS.DBMS_MACADM" line 1740
ORA-06512: at line 1
how to rectify the problem.
I used the below link for configuring database vault on existing database.{URL]////
SQL & PL/SQL :: Conducting Security Audits Of Database - Three Privileges
Oct 24, 2013While conducting security audits of our databases, I noticed that the DBA role has three privileges I've never heard of, let alone used:
UNDER ANY TABLE
UNDER ANY TYPE
UNDER ANY VIEW
I can't find anything in the Oracle documentation or on Metalink about them.
Security :: How To Configure Log Miner With Oracle Database 11g
Nov 2, 2012Database 11.1.0.7
Applications 12.1.3
OS RHEL 5.5
how to configure log miner with oracle database 11g as we need to analyze redolog files.how to install,configure,use log miner.
Security :: Database Authentication Through Open LDAP
Mar 28, 2013I'd like to have my 11g database authenticate users against an OpenLDAP service. We'd still create accounts in the database, and do authorization within the database, but I'd just want to the user's passwords authenticated externally, against the OpenLDAP service. Is this possible? My searching through these forums and Google seems to indicate that you can do it if you run an Oracle Internet Directory (OID) service. I do not want to have to install and maintain an Oracle Internet Directory service. I'd like to do it without it.
I have a working PL/SQL function (below) that can authenticate a passed in username & password against our OpenLDAP directory. Is there any way for me to have Oracle call this function for the database user authentication? Or is there any other way for me to get the Oracle database to directly authenticate against OpenLDAP without having to run OID?
create or replace function ldap_authenticate(username varchar2, password varchar2)
return boolean is
begin
begin
if dbms_ldap.success = dbms_ldap.simple_bind_s(
[code]........
Security :: Audit Database Session From A Particular Applications?
Aug 14, 2013Is there a way where we can audit database session from a particular applications? For example : We need to audit Toad and SQL developer sessions .
View 1 Replies View RelatedSecurity :: Find Out The User Access The Database?
Nov 8, 2011Is there a way to find out the user access the database?
View 1 Replies View Related