Blogs about: Oracle Tech
Featured Blog
Catchback: Oracle Reg Expressions
This is useful in cases where there is a need to replace only a part of a text and the before and after parts have to be retained. Eg: http://mywebsite/page/1.htm has to be changed to http://yoururl/p… more →
Technorama
Catchback: Oracle Reg Expressions
vinayaknp wrote 1 month ago: This is useful in cases where there is a need to replace only a part of a text and the before and af … more →
Getting sql plans
vinayaknp wrote 4 months ago: One of our sql procedure executions took a lot of time. But it was not being monitored when it was e … more →
Adding partitions to table
vinayaknp wrote 5 months ago: Recently, we had performance issues in our SQL code and one of the ways we thought was to increase t … more →
Finding rows in table partition
vinayaknp wrote 5 months ago: There are cases when we would need to know how many rows are present in each partition. This would h … more →
Scheduler job monitoring
vinayaknp wrote 8 months ago: Use the following query to take a look at oracle jobs that have run in a scheduler SELECT * FROM dba … more →
Oracle: locked objects
vinayaknp wrote 8 months ago: The following query is helpful in figuring out if any objects have been locked during script executi … more →
Oracle: Query Rewrite settings
vinayaknp wrote 10 months ago: Query rewrite is a very useful concept provided by Oracle so that queries on a table can be redirect … more →
Table sizes in oracle
vinayaknp wrote 10 months ago: To find out how much physical space a table occupies in Oracle Database, use the following query : S … more →
Maintain timestamp zone in Database
vinayaknp wrote 11 months ago: We have a requirement where we get timestamp data for any time zone. But when we store it in the dat … more →
Editing an Oracle Job
vinayaknp wrote 1 year ago: After you create an oracle job, you may need to edit it. Oracle provides a procedures for the same. … more →
Tablespace info using Command Prompt
vinayaknp wrote 1 year ago: In the absence of any UI based Oracle Database access tools, one has to access the same using SQL PL … more →
Calling stored Procedures from shell script
vinayaknp wrote 1 year ago: To call an oracle stored procedure from shell script you have to use sqlplus sqlplus -SILENT "user/p … more →
SQL Loader options
vinayaknp wrote 1 year ago: The following are the options available for SQL Loader. The OPTIONS parameter allows you to specify … more →
Varchar length in SQL Loader
vinayaknp wrote 1 year ago: SQL Loader by default limits the length of any varchar to 255 . Hence it throws an error that the ma … more →
About Oracle Jobs
vinayaknp wrote 1 year ago: When creating oracle jobs for running stored procedures, we have to create them as the user who has … more →
Oracle: Analyze tables
vinayaknp wrote 1 year ago: Analyze table is a feature in Oracle. When it is run on a particular table, it rebuilds the indexes … more →
SQL : Best Practices
vinayaknp wrote 1 year ago: This post is about the SQL best practices that I have come across: Make a note of the indexes or pri … more →
PL SQL coding - Best Practices
vinayaknp wrote 1 year ago: This has a collection of PL SQL best practices that I have learned .. some times the hard way When w … more →
Connecting as sysdba
vinayaknp wrote 1 year ago: To connect as sysdba on oracle, do the following: 1. Login to the oracle machine. 2. export (or set) … more →
