Finding the SQL_ID for a SQL Statement is straight forward task. You can use query like below to find the SQL_ID
SQL> SELECT sql_id, hash_value, SUBSTR(sql_text,1,40) Text FROM v$sql WHERE sql_text LIKE '%&An_Identifiable_String%';
To Determine the SQL_ID of a SQL Statement in a PL/SQL Block below steps can be followed:
2 CommentsCouple of ASM disk headers were accidentally removed by UNIX sysadmin team.
After disk headers got removed, the database kept running for some time as the data inside disk was intact. When scheduled RMAN backup kicked off the database came down.
1 CommentA normal SQL statement go through below phase before producing results.
1) PARSE PHASE
In our EBS R12 instance we have seen forms process consuming high CPU resources causing other applications processes to run slow. Our EBS R12 application…
1 CommentIn one of our EBS database we faced issue when connecting to SQLPLUS
Error message which was coming up was as below:
[oracle@dbserver bin]$ sqlplus apps/apps
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 11 (asmadmin), current egid =
17 (oinstall)
We have seen this error couple of times in the Concurrent manager Administer screen in our 11i/R12 EBS instances.
Below steps have proven helpful in sorting out this issue:
2 CommentsAll of the big data enterprises today use Apache Hadoop in some way or the other. Hadoop is by no means an out-of-the-box solution. Hadoop is open source system but to simplify working with Hadoop, many enterprise versions like Cloudera, MapR and Hortonworks are available in market. Vendor distributions are aimed at overcoming the issues that the users typically encounter in the standard editions. Think of various distribution of Linux like Red Hat.
Leave a Comment
Let us try to understand Big Data concept in simple language.
Your friend brought you one of one hard disk of say 2 TB which contained lots of data in the form of dat files (exported from relational database), lots of excel files, csv files. He asked you that he needs some critical reports based on this data. You created one new database and related schemas. Then you took all this data and imported it into your datbase by standard tool. You used data querying language like SQL and fetched required reports. Mission accomplished.
Leave a Comment
