|
|
|
Viewing 0 - 40 out of 50 Articles |
Sql
- SQL: Report contiguous space in a database
The purpose of this script is to display contigous space in all tablespaces for SAP system (ORACLE) named SID REM SET PAGESIZE 60 REM SET LINESIZE 80 REM SET FEEDBACK OFF REM SET TAB OFF REM ... Posted in: Database Administration, | By: Shailesh Singh | Date: 07 Oct 2005 5:25 am | Comments (0)- Report all jobs submitted using DBMS_JOB procedure
This script displays a listing of all jobs submitted via DBMS_JOB. set echo off col jobno heading job# format 9999 col job heading job# format 9999 col log_user heading "USER NAME" format a10 c ... Posted in: Database Administration, | By: Shailesh Singh | Date: 07 Oct 2005 5:27 am | Comments (0)- What is a deadlock and how does oracle handle it?
A deadlock is a condition where two or more users are waiting for data locked by each other. Oracle automatically detects a deadlock and resolves them by rolling back one of the statements involved in ... Posted in: Oracle Database, | By: Shailesh Singh | Date: 08 May 2006 2:52 am | Comments (0)- What does 'SNIPED' status in v$session mean?
When IDLE_TIME is set in the users' profiles or the default profile. This will kill the sessions in the database (status in v$session now becomes SNIPED) and they will eventually disconnect. It does n ... Posted in: Oracle Database, | By: Shailesh Singh | Date: 09 May 2006 7:07 am | Comments (0)- Database Crashed. Server manager doesn't come up
This happened to me one fine morning. For one of my databases, DBWR crashed and then all other processes died. After that neither svrmgrl not sqlplus were even starting. These just returned back to un ... Posted in: Oracle Database, | By: Shailesh Singh | Date: 09 May 2006 7:09 am | Comments (0)- How to find your log block size?
You can find your log block size in bytes with the following query (connected as SYS or internal): select distinct lebsz from x$kccle; You can find your log block size in bytes with the followin ... Posted in: Oracle Database, | By: Shailesh Singh | Date: 12 May 2006 3:23 am | Comments (0)- Simpler way of finding plan and statistics of a query
Executing EXPLAIN PLAN and then selecting from plan_table is one way to get the execution plan of a sql statement. But for this you need syntax of both statements and patience to type all that stuff f ... Posted in: Oracle Database, | By: Shailesh Singh | Date: 12 May 2006 3:41 am | Comments (0)- Change Oracle Installation Location on Linux
I installed oracle 10g on a linux machine, which has two hard drives, the current installation is at /u01/app/oracle/product/10.1.1/myoraclehome However, there is not much space left on this drive ... Posted in: Oracle Database, | By: Shailesh Singh | Date: 13 May 2006 6:08 am | Comments (0)- Introduction to Oracle
SQL*Plus — schemata — data types — DML & DDL examples — editing commands — using external files — the dual pseudo-table — introduction to transactions — optional exercise — reference ... Posted in: Oracle / SQL Tutorial, | By: Shailesh Singh | Date: 05 Jul 2006 5:38 am | Comments (2)- Introduction to PL/SQL
Need for PL/SQL — declarative vs. procedural — anonymous blocks — debugging — a first program — code compilation — code execution — procedures & functions — PL/SQL in SQL — SQL in PL ... Posted in: Oracle / SQL Tutorial, | By: Shailesh Singh | Date: 05 Jul 2006 6:23 am | Comments (0)- Oracle's Data Dictionary
Data dictionary — meta-data — system & object privileges — dictionary structure — ``user'' tables - ``all'' tables — ``dba'' tables — ``v$'' tables — frequently used tables — usage exa ... Posted in: Oracle / SQL Tutorial, | By: Shailesh Singh | Date: 05 Jul 2006 7:51 pm | Comments (0)- DreamCoder for Oracle - Description
DreamCoder for Oracle is a powerful Integrated Development Environment (IDE) for Oracle Databases. Using the intuitive DreamCoder's GUI will increase your code quality and reduce the development proce ... Posted in: Oracle News, | By: Shailesh Singh | Date: 08 Jul 2006 9:56 pm | Comments (1)- Oracle Certified Professional Exams IZ007
Q. The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from hig ... - FAQ: SQL server analysis and avoiding deadlocks
1. What is the relationship between SAP work processes and SQL server processes? Each work process is connected to the MS SQL server database via the database interface. The system uses a series of c ... Posted in: Oracle Database, | By: rekha | Date: 15 Mar 2008 7:01 am | Comments (0)- FAQ: SQL Server 2000 I/O performance
1. Which counters on I/O performance does SQL Server provide? From release SQL Server 2000 the system function fn_virtualfilestats records I/O values for each database file. This includes the numbe ... Posted in: SQL Server, | By: rekha | Date: 15 Mar 2008 5:00 pm | Comments (0)- FAQ: Answers to questions about the Security Audit Log
Configuration [1] Question: What is the difference between static and dynamic configuration? Answer: Static configuration is used for the ongoing storage of a Security Audit log configuration in t ... Posted in: Basis, BASIS, | By: rekha | Date: 16 Mar 2008 11:53 am | Comments (1)- Microsoft SQL Server
Q1: Is it possible to disable the transaction log completely ? A1: No.As the transaction log contains the 'redo' and 'undo' information for the transactions, it can't be disabled. This information is ... Posted in: SQL Server, | By: rekha | Date: 17 Mar 2008 1:44 pm | Comments (0)- Oracle Net
1. What is Oracle Net or (Net8/SQL*Net V2)? Oracle Net Services (Oracle 9), Oracle Net (Oracle 8) or SQL*Net V2 (Oracle 7) are used for communication between an Oracle client (for example, an R/3 ins ... Posted in: Oracle Database, | By: rekha | Date: 19 Mar 2008 4:06 pm | Comments (0)- FAQ: Oracle SQL optimization
1. What is SQL optimization? SQL optimization (or SQL statement tuning or Shared Cursor cache analysis) refers to the identification, analysis and optimization of SQL statements that are responsible ... Posted in: SQL Server, | By: rekha | Date: 25 Mar 2008 8:50 am | Comments (0)- Attach/Copy SAP Business One database into a new database.
Solution Create a copy of SAP Business One database in the same SAP Business One Server. The database copy can be saved on the original database server or on a different server. Two different methods ... Posted in: Business One, | By: Shailesh Singh | Date: 26 Mar 2008 6:00 pm | Comments (0)- What is difference between Open SQL & Native SQL?
Open SQL Open SQL allows developers to control SQL statements directly. Open SQL encapsulates the semantics for statement execution, parameter binding and results fetching provided by each database v ... Posted in: ABAP/4, ABAP, | By: rekha | Date: 28 Mar 2008 3:10 pm | Comments (14)- FAQ: MaxDB SQL optimization
1. What is SQL optimization? SQL optimization involves the identification, analysis, and optimization of SQL statements that are responsible for the highest load as regards I/O at the database level. ... Posted in: MaxDB, | By: rekha | Date: 30 Mar 2008 3:41 pm | Comments (0)- FAQ: Microsoft SQL Server
Q1: Is it possible to disable the transaction log completely ? A1: No.As the transaction log contains the 'redo' and 'undo' information for the transactions, it can't be disabled. This information is ... Posted in: SQL Server, | By: rekha | Date: 31 Mar 2008 8:15 am | Comments (0)- FAQ: MaxDB Performance
1. Where do I find more information about MaxDB Tuning? For information about MaxDB Tuning, see the SAP Developer Network (SDN) under the following link: https://wiki.sdn.sap.com/wiki/x/jRI 2. Can ... Posted in: MaxDB, | By: rekha | Date: 01 Apr 2008 7:32 am | Comments (1)- Is BRTools comes with SQL Server
Hi can any one tell me BRTools also come with SQL Server ... Posted in: SAP Third Party Products, | By: Manoj | Date: 08 Apr 2008 6:11 am | Comments (1)- Java SQLException Error
While processing the XML file the following errors occured in the Audit log (sender Communication channel). 1. Putting message into send queue failed, due to: com.sap.aii.af.ra.ms.api.DeliveryExcepti ... Posted in: SAP Exchange Infrastructure (XI), | By: Manoj | Date: 09 Apr 2008 5:04 am | Comments (0)- How to caculate the difference(in days) between two dates
The query below calculates number of days between two dates. For example: 1. The user needs to calculate the difference between today and the &nb ... Posted in: SQL Server, | By: rekha | Date: 17 Apr 2008 6:44 am | Comments (0)- OCS: Known problems with Support Packages in Basis Rel. 6.20
1. SPAM/SAINT updates Symptom: When you import the SPAM/SAINT update, a range of different runtime errors may occur: LOAD_PROGRAM_LOST LOAD_TEXTPOp_L ... Posted in: BASIS, | By: rekha | Date: 21 Apr 2008 3:44 pm | Comments (1)- JUNIUOR Sap Basis Admin
Name ... Posted in: SAP BASIS Resume, | By: PATEL NIKHIL | Date: 02 Jun 2008 4:14 am | Comments (3)- How to login on SQL server with Oracle 8.1 and SAP 4.7
There are two methods to login on SQL server SQL 1. go to cmd > type sqlplus /nolog (you will get a sql prompt) 2. sql>conn ... Posted in: BASIS, | By: Shailesh Singh | Date: 23 Jul 2008 8:10 am | Comments (3)- SENIOR PROGRAMMER ANALYST-ERP
global leader in medical technology with a history of success and exceptional Experience: 5 - 7 Years Location: Delhi/NCR Education: UG - B.Tech/B.E. - Any Specialization PG - MCA - C ... Posted in: SAP Jobs, | By: Manoj | Date: 02 Aug 2008 2:46 am | Comments (0)- Problem with Setting a Select Statement
I have problem setting a select structure to calculate the total days from a table .The problem is like that: I have 2 tables first of which contains 'days' and 'objnr3' fields.objnr3 conta ... Posted in: ABAP, | By: | Date: 06 Aug 2008 1:16 pm | Comments (1)- MS-SQL Log file to large
We are using SAP ECC 5.0 on Windows 2003 with MS-SQL 2000 as database, our SQL- Logfile is very large 137 GB now, and total size of Datafiles are 90 GB only. Details of Files in Development ... Posted in: BASIS, | By: Manoj | Date: 11 Sep 2008 3:42 am | Comments (5)- V-Soft Consulting Group Inc.
Senior SAP Basis Administrator Location: Norwalk CT Duration: Job Description: Senior SAP Basis Administrator Additional Responsibilities ... Posted in: SAP Jobs, | By: Sudha | Date: 16 Oct 2008 6:43 pm | Comments (0)- scc4 giving error SQL Error 600 occured
dear all facing this peculiar problem when i execute the transaction SCC4 am getting the error DV ERROR : SQL Error 600 occured Specified database error occured when executing the SQ ... - JAVA/SAP Developer
Jain SunilKumar &n ... Posted in: SAP Resume, | By: | Date: 06 Jan 2009 9:40 am | Comments (0)- PL/SQL books Download for Free
Here u can download tops ranking PLSQL books. These are very helpful books. The link is given below. http://rapidshare.com/files/270289824/oracle_ebooks.rar Pls check them. ... Posted in: SAP Books, | By: Shailesh Singh | Date: 24 Aug 2009 8:30 am | Comments (0)- 5147FL - SAP BASIS/NetWeaver Systems Administrator - Miami FL
All, We need matching resumes for the below requirement along with consultant’s best all-inclusive C2C rate, availability and direct contact information. Position: SAP BASIS/Ne ... Posted in: SAP Jobs, | By: Rajesh Jain | Date: 24 Aug 2009 6:19 pm | Comments (0)- sql error 942 or 941
Hi When i am trying to logon it comes sql error 942 or 941, why it is coming and how it can be reloved.......... Thanks Ajay Kaushik ... Posted in: BASIS, | By: | Date: 25 Aug 2009 6:41 am | Comments (1)- 2 Plus years of experience. Unxi scripting, SQL and PL/SQL.
2 Plus years of experience. Unxi scripting, SQL and PL/SQL. ... Posted in: SAP Resume, | By: | Date: 20 Oct 2009 11:43 am | Comments (0)
|
|
