-
What is procedure cache and data cache?
kurar
- Mar 9th, 2008
Procedure cache is the memory area where compiled query tree run e.g, procedure, batch query. Data Cache is the memory area where data that is required for the current querys running is bought from Disk on to memory for building result sets.
-
Table Locks
How to lock a table in sybase? give me its text command.
samala_naresh
- Aug 7th, 2008
lock table table_name in {share | exclusive} mode [wait [no_of_seconds] | nowait]
-
Sybase Workspace
How is Workspace used in Sybase?
mikeob
- Jun 17th, 2009
I think it needs clarification. The only 'workspace' that comes to my mind here is a *.ws file from Sybase Power Designer. In that case a workspace serves as a container for physical, logical ERDs and reports, etc.
-
Purge Data
How will you purge data from audit database?
mikeob
- Jun 17th, 2009
To back up sysaudits_0n, set up a threshold which, when triggered, copies its contents into a permanent table and uses sp_configure to set the new active audit table to sysaudits_0(n+1). This will get...
-
Stable Device
What do you mean by Stable Device in Sybase replication?
mikeob
- Jun 17th, 2009
I think the textbook term is 'stable queue' - the place on disk where transacitons/data is stored until it reaches its destination(s). Plays the role of a ledger file in JMS/Tibco.
-
Replication Thread
How will you handle when an replication thread goes down?
Rep_dba
- Apr 1st, 2010
Check Replication server error log to see why the thread is down. Fix the error and resume the thread. If it is DSI thread that is down, run following command in Rep server.resume connection to data_server.database
-
Replication Exception Log
What is exception log in replication?
Rep_dba
- Apr 1st, 2010
Skipped transactions and orphaned transactions in replication server are logged into Exceptions log. Exception log is set of three RSSD tables rs_exceptshdr, rs_exceptscmd, rs_systext. You can run rs_helpexception to see the exceptions.
-
Secondary Truncation Point
What is Secondary Truncation Point?
luisgranados
- May 20th, 2011
Is a mark in the primary db log up to which the replication agent has processed transactions.
-
Query Performance Tuning
What parameters would you look for while trying to optimise your query? How is the cost of a query measured
subi_sybase
- Dec 20th, 2010
Do a set showplan oncheck each query and see if any table scan is used....if yes, check if any index is present on tables...if index is not present try adding it....if index is present, determine what...
-
-
-
Sybase Prefetch
What is the significance of the keyword 'prefetch' in SQL queries?
Tejas More
- Jul 7th, 2011
prefetch improves performance by anticipating the pages required for certain well-defined classes of database activities whose access patterns are predictable. The I/O requests for these pages are iss...
-
Query Plan
How does Sybase system decide on which plan to use for a query? Can you force a plan to be used by the Sybase system
-
Performance Tuning
What is the role of page size and data and cache memory in increasing the performance of the query. What other external factors can cause performance issues?
Sybase Interview Questions
Ans