ORA-15032: not all alterations performed – ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)
Cause: Sometimes when you delete files under ASMCMD, files not get delete Workaround: Use -rf with rm forces deletion
REGEX SQL
As you know regex is a powerful string manipulation function used to filter the strings,numbers,characters etc very effectively. Below are the useful functions to pull desired filter REGEXP_SUBSTR REGEXP_SUBSTR(source_string,pattern [,position[,occurence[,return_option[,match_parameter]]]] [[:digit:]] is a parameter used in regex_substr to filter only digits from string REGEXP_LIKE is a function which can be used in where clause of … Continue reading REGEX SQL
SHELL SCRIPT TO MONITOR LOAD AVERAGE IN LINUX
Its too critical to monitor the load in linux system where multiple process spawn to bring down the performance and in the worst case, collapse the server A custom shell script to monitor the load for every 30 seconds Script: One liner for load average monitor per 30 seconds We get two output per every … Continue reading SHELL SCRIPT TO MONITOR LOAD AVERAGE IN LINUX
IO HOT SPOT EXADATA STORAGE LAYOUT
Default allocation policy: In exadata celldisks ,outer region is faster and inner region is slower. So oracle recommends to create griddisks which require high IOPS on the edge of the disk platter and other diskgroups which are non critical just for storing historical archive data or non critical data which are touched not too often … Continue reading IO HOT SPOT EXADATA STORAGE LAYOUT
HYBRID COLUMNAR COMPRESSION (EXADATA)
Standard oracle block format and row format: Rows are stored in no specific order,but columns are generally stored in the order in which they were defined in table. For each row in a block there will be a row header and column data for each column. These rows are stored in standard oracle block format … Continue reading HYBRID COLUMNAR COMPRESSION (EXADATA)
HDFS not starting : java.io.IOException: the path component: ‘/var’ is owned by a user who is not root and not you. Your effective user id is 993; the path is owned by user id 977, and its permissions are 0755. Please fix this or select a different socket path. at org.apache.hadoop.net.unix.DomainSocket.validateSocketPathSecurity0(Native Method)
Cause: HDFS is not starting from cloudera because of permission error after installing spark. After spark is installed, the ownership of /var mountpoint change to spark:spark Workaround: Change the owner to root Check the ownership
ORACLE DATABASE STATIC HEALTH CHECK SCRIPT
Are you looking for a basic health check report for your oracle database ? Hope this consolidated script might help you in your project for a high level peek on behaviour of database. Below are the parameters included in this script Oops ! It looks like too much of information in one report. Some of … Continue reading ORACLE DATABASE STATIC HEALTH CHECK SCRIPT
SQL QUERY TO FIND PROCESS AND SESSION RESOURCE LIMIT ORACLE
If there concurrent sessions and process connections overflow in your database,then you might get into trouble of customer complaint because of performance or connectivity issues. This query will help you to get limit compared with current and max utilization of processes and sessions SQL Query: Output:
SQL QUERY TO GET TABLESPACE USAGE IN HTML FORMAT ORACLE
Everyone like colourful output which looks beautiful.If you ask tablespace usage report in html format to me and i have one for you. SQL Query: Normal output: SQL Query for HTML: HTML OUTPUT: Enjoy!
SQL QUERY TO FIND TOP SQL ORACLE
My job was at stake due to performance issue from a financial application database.Client was bleeding money due to report deadline with in financial year. There should be a quick way to identify the top SQL which eats up the database bit by bit and crash the database. Thats why its always keep a handy … Continue reading SQL QUERY TO FIND TOP SQL ORACLE
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
