|
|
Viewing 0 - 20 out of 17 Articles |
- How to determine free memory and used memory in Oracle
How to determine free memory and used memory in Oracle
The summary information of the SGA is determined by,
SQL> select * from V$SGA;
NAME VALUE
------------ --------- --------- --------- ------......
Posted in:
Oracle | By:
Hari | Date: 04 Sep 2008 10:35 pm |
Comments (0)- How to know database initialization parameter in oracle
How to know database initialization parameter in oracle 1)SHOW PARAMETER option: If you
use SQL*Plus then you can use SHOW PARAMETER parameter_name to display
the values of parameters currently in u......
Posted in:
Oracle | By:
Hari | Date: 04 Sep 2008 10:33 pm |
Comments (0)- How to monitor alert log file in Oracle
How to monitor alert log file in Oracle
We know in a UNIX system with tail -f we can monitor alert log file to see how alert log file is populated. For example the latest happenings in alert log file......
Posted in:
Oracle | By:
Hari | Date: 04 Sep 2008 10:36 pm |
Comments (2)- How to Schedule or Automate Backup through Crontab
How to Schedule or Automate Backup through Crontab Schedule or Automate Backup is a needed thing almost in all
environment. We can do automate or scheduling tasks through two ways, one is DBMS_SCHEDU......
Posted in:
Oracle | By:
Hari | Date: 04 Sep 2008 10:53 pm |
Comments (0)- Convert CLOB to BLOB
Convert CLOB to BLOB
I will write a procedure clob_blob_proc which convert description
column of test table of type clob to blob. Here is the procedure.
1)Create a Table with Clob Column:
----......
Posted in:
Oracle | By:
| Date: 04 Sep 2008 11:20 pm |
Comments (6)- difference b/w fal_client and fal_server
FAL_CLIENT <service_name> of the current host database which will act as client for the archive log shipping
FAL_SERVER <service_ name> of the standby or remote database which will be shi......
Posted in:
Oracle | By:
Hari | Date: 06 Sep 2008 4:22 pm |
Comments (3)- When you would make Index and when not.
* Create an index if you frequently want to retrieve less than 15% of the rows in a large table.
* To improve performance on joins of multiple tables, index columns used for joins.
* Small table......
Posted in:
Oracle | By:
Admin | Date: 06 Feb 2010 2:06 pm |
Comments (0)- Oracle INSERT Performance
Yesterday we had an issue to increase the speed of insert statements. We had to insert about 500K record to database as quickly as possible. We were inserting at a rate of 10 records/sec. Well, I was ......
Posted in:
Oracle | By:
Admin | Date: 06 Feb 2010 2:09 pm |
Comments (0)- Optimize Data Access Path in Oracle
To achieve optimum performance for data-intensive queries, materialized views and indexes are essential when tuning SQL statements. The SQL Access Advisor enables to optimize data access paths of SQL ......
Posted in:
Oracle | By:
Admin | Date: 06 Feb 2010 2:13 pm |
Comments (0)- ORA-12154:TNS:could not resolve the connect identifier specified
Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the nami......
Posted in:
Oracle | By:
rekha singh | Date: 21 Oct 2010 5:12 pm |
Comments (0)- Steps to troubleshoot Oracle connectivity:
To troubleshoot & diagnose Oracle connectivity problems, follow this checklist:
Check with "ping" using the IP address ("ping 198.11.34.43"
Check with "......
Posted in:
Oracle | By:
rekha singh | Date: 21 Oct 2010 5:20 pm |
Comments (0)- Supreme Court derails discrimination suit against Wal-Mart
Washington - A sex discrimination lawsuit against Wal-Martpandora uk charms cannot move forward as a class action, the U.S. Supreme Court ruled Monday. The lawsuit against the world's biggest retai......
Posted in:
Oracle | By:
yun che | Date: 21 Jun 2011 8:30 am |
Comments (0)- Greece takes the eurozone's future to the bink
Some economists and politicians have forecast the euro's demisepandora bracelets for years. The game, they argue, is just taking longer than expected to reach its denouement. But there is no doubt ......
Posted in:
Oracle | By:
yun che | Date: 21 Jun 2011 8:34 am |
Comments (0)- Albert Pujols Out 4-6 Weeks
Albert Pujols, the St. Louis Cardinals superstar first baseman, is out 4-6 weeks with achristian louboutin sale fractured left forearm. The team announced the results of an MRI and CT scan Monday, ......
Posted in:
Oracle | By:
yun che | Date: 21 Jun 2011 8:37 am |
Comments (0)- World's oceans in 'shocking' decline
In a new report, they warn that ocean life is "at high risk of entering aTrue religion jeans phase of extinction of marine species unprecedented in human history". They conclude tha......
Posted in:
Oracle | By:
yun che | Date: 21 Jun 2011 8:40 am |
Comments (0)-
......
Posted in:
Oracle | By:
| Date: 30 Nov 1999 12:00 am |
Comments ()- Supreme Court derails discrimination suit against Wal-Mart
Washington - A sex discrimination lawsuit against Wal-Martpandora uk charms cannot move forward as a class action, the U.S. Supreme Court ruled Monday. The lawsuit against the world's biggest retai......
Posted in:
Oracle | By:
yun che | Date: 21 Jun 2011 8:49 am |
Comments (0)
1
